R12.2: Performance Issue for Accrual Reconciliation Load Run Program After Upgrade (Doc ID 2218885.1)

Last updated on JANUARY 06, 2017

Applies to:

Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

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:

 

Cause

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