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

Last updated on MARCH 08, 2017

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

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