My Oracle Support Banner

PAXEXGLD EXC: Transaction Exception Details by GL Period Slow Performance (Doc ID 1953384.1)

Last updated on JULY 13, 2019

Applies to:

Oracle Grants Accounting - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Oracle Project Costing - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

EXC: Transaction Exception Details by GL Period - erroring not completing and the job completes normally 3 hours max.

Here is the expensive query:

 SELECT MIN(PAP.END_DATE)
 FROM
 PA_PERIODS PAP WHERE STATUS IN ('O','F') AND PAP.END_DATE >= :B1
 
 
 call     count       cpu    elapsed       disk      query    current     rows
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 Parse        1      0.00       0.00          0          0          0            0
 Execute 52265012    969.75   973.15          0          0          0            0
 Fetch   52265012   1272.08  1289.60          0  156795036          0     52265012
 ------- ------  -------- ---------- ---------- ---------- ----------   ----------
 total   104530025   2241.85 2262.75          0  156795036          0     52265012

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
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.