My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

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

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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