My Oracle Support Banner

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

Last updated on MARCH 29, 2022

Applies to:

Oracle Purchasing - Version 12.2 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:





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.