Tuesday, December 06, 2016

Oracle Session Timeout Profile

Oracle Login page session timeout

Login into Oracle Applications as SYSADMIN and search for profile 
ICX:Session Timeout; set this Profile Option to the same value as the one specified by session.timeout in zone.properties. (Default 30 min)

  • This is session timeout limit for Self Service Framework Applications and is specified in minutes. 
  • If the ICX session expires before the Jserv session, the user will be presented with a login page even though the Jserv session is still active. 
  • If the user logs back in before the Jserv session expires, they will see the old state of their middle-tier transaction. 
  • This can be confusing, since from the point of view of the user there is no distinction between the ICX session and the Jserv session.
By using profile for "ICX:Session Timeout” Profile Option For Change  the session Timeout.

Nav: System Administrator > Profile > System > Update System Profile options

 ICX:Session Timeout = 30 (it is consider only minute default ) 

Now you can change  "Session Timeout" accordingly in Minutes.


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