R12 AP: Mass Additions Create Program Bad Performance After Upgrading to R12.1.3

(Doc ID 1606272.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

In R12.1.3, Mass Additions Create program is running for hours. Prior to the R12.1.3 upgrade, the process completed in a few minutes.

The following SQL statement is taking a long time:

 

 

Changes

 Upgraded to R12.1.3

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