PRC: Generate Intercompany Invoices For A Range Of Projects Having Performance Issue (Doc ID 2177803.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Expenditure Processing


PRC: Generate Inter Company Invoices For A Range Of Projects Having Performance Issue

SELECT ITEM_KEY
FROM
WF_ITEM_ACTIVITY_STATUSES_V WHERE ACTIVITY_TYPE_CODE = 'PROCESS' AND
ACTIVITY_STATUS_CODE != 'COMPLETE' AND ITEM_TYPE = 'XXPAARIN' AND (
(USER_KEY LIKE :B1 ||'-'||:B2 ||'-%') OR ( USER_KEY LIKE :B1 ||'%' AND NOT
EXISTS ( SELECT 1 FROM PA_DRAFT_INVOICES_ALL PDIA WHERE PDIA.PROJECT_ID=:B3
AND USER_KEY LIKE :B1 ||'-'||PDIA.DRAFT_INVOICE_NUM||'-%' ) ) )

call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 1 0.00 0.00 0 0 0
0
Execute 233 0.07 0.07 0 0 0
0
Fetch 233 76.44 80.08 20356 16519955 0
0
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 467 76.51 80.16 20356 16519955 0
0
.
UPDATE PA_EXPENDITURE_ITEMS_ALL EI SET EI.CC_IC_PROCESSED_CODE =
DECODE(EI.CC_CROSS_CHARGE_CODE,'I','Y','X') ,EI.LAST_UPDATE_DATE = SYSDATE ,
EI.LAST_UPDATE_LOGIN = :B3 ,EI.REQUEST_ID = :B2
WHERE
EI.EXPENDITURE_ITEM_ID = :B1 AND EI.CC_IC_PROCESSED_CODE = 'B'

call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 1 0.00 0.00 0 0 0
0
Execute 15557 3.92 46.67 13685 66079 399194
15557
Fetch 0 0.00 0.00 0 0 0
0
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 15558 3.92 46.67 13685 66079 399194
15557

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