Periodic Acquisition Cost Adjustment Processor Is Very Slow Under CMCPAW Request (Doc ID 2014876.1)

Last updated on AUGUST 10, 2015

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

PAC is very slow under CMCPAW request.


Most expensive query seen in the trace

SELECT COUNT(RCV_TRANSACTION_ID)
FROM
AP_INVOICE_DISTRIBUTIONS_ALL AD1 WHERE AD1.RCV_TRANSACTION_ID = :B4 AND
 ((:B1 =1) AND (AD1.ACCOUNTING_DATE BETWEEN :B3 AND :B2 )) OR (:B1 = 2) AND
 AD1.POSTED_FLAG = 'Y' AND AD1.LINE_TYPE_LOOKUP_CODE <> 'REC_TAX' AND ROWNUM
 < 2


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.06          0          0          0           0
Execute   8840      0.14       0.26          0          0          0           0
Fetch     8840   6608.96   12063.44  568624160  569419780          0        8840
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    17681   6609.10   12063.77  568624160  569419780          0        8840

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 173     (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
        1          1          1  SORT AGGREGATE (cr=64414 pr=64324 pw=0 time=72588360 us)
        0          0          0   COUNT  (cr=64414 pr=64324 pw=0 time=72588342 us)
        0          0          0    FILTER  (cr=64414 pr=64324 pw=0 time=72588337 us)
  1111580    1111580    1111580     TABLE ACCESS FULL AP_INVOICE_DISTRIBUTIONS_ALL (cr=64414 pr=64324 pw=0 time=58507207 us cost=17928 size=24492028 card=1113274)

 

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