Wednesday, November 23, 2016

How to assign Oracle Workflow Administrator privileges to users

Note: Oracle By default and design, only SYSADMIN user can views other user’s notifications. What if a requirement comes to enable everyone/certain group of people to view everyone’s notifications.
In the field ‘Workflow System Administrator’ set the value to which you want to assign the workflow administrator privilege.
Setup steps to be followed.
  • Login as SYSADMIN User
  • Navigate to Workflow Administrator Resp go to Administrator Workflow and Administration page.




In the admin page you will see this message “Set * to grant admin privilege to all users”

Put * in the text box “Workflow System Administrator” and click Apply.

To make all users workflow system administrators set the value as " Workflow Administrator Web (New)"  

Finally who to assign responsibility of “Workflow Administrator Web (New)" Can able to view approval notifications.
In case of any error or process struck up with Approval workflow to force to retry once again.

Monday, November 21, 2016

Oracle P2P Accounting entries for Expense Item

In Oracle purchasing Expense Items

1.      Enter Purchase Order:     No accounting takes place
2.      Oracle Inventory Enter a Receipt:
Accounts
Debit
Credit
Inventory Receiving A/c
Dr

Accrual A/c

Cr
3.      Receiving Transaction
- For Expense Item direct receipt – delivered to inventory
Accounts
Debit
Credit
Expense A/c
Dr

Inventory Receiving A/c

Cr

- For Expense Item standard receipt – delivered to inventory
Accounts
Debit
Credit
Expense A/c
Dr

Inventory Valuation A/c

Cr
    
4.      Oracle Payable
a.      Regular payment
·         Enter Invoice
Accounts
Debit
Credit
Accrual A/c
Dr

Liability A/c

Cr
·         Payment against Invoice
Accounts
Debit
Credit
Liability A/c
Dr

Cash Clearing A/c

Cr
b.      Prepayment invoice
·         Enter Invoice
Accounts
Debit
Credit
Prepayment A/c
Dr

Liability A/c

Cr
·         Payment against Invoice
Accounts
Debit
Credit
Liability A/c
Dr

Cash Clearing A/c

Cr
·         Apply Prepayment to Invoice
Accounts
Debit
Credit
Accrual A/c
Dr

Prepayment A/c

Cr
Liability A/c

Cr
5.      Clearing (Cash Management)
Accounts
Debit
Credit
Cash Clearing A/c
Dr

Bank

Cr