R12.2: Performance Issue for Accrual Reconciliation Load Run Program After Upgrade
Last updated on JANUARY 06, 2017
Applies to:Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.
After upgrade to R12.2 application, Accrual Reconciliation Load Run program is having huge performance issue.
Steps to reproduce
1. Connect to Purchasing Responsibility > go to View > Requests > Submit a New Request
2. Name = Accrual Reconciliation Load Run > Enter Date From and Date To parameters for 1 month period
3. Is taking 1 day to finish the request
In the tkprof file of the trace, following query took long time to be executed:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms