My Oracle Support Banner

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

Last updated on AUGUST 25, 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

Running  PRC: Generate Intercompany Invoices for a Range of Projects and having poor performance on the following update statement

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'



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.