R12 PRC: Create Accounting Process Has Slow Performance
(Doc ID 1472723.1)
Last updated on MARCH 22, 2018
Applies to:Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
When running the PRC: Create Accounting process for the Projects Application, the following statements result in huge performance hit:
UPDATE XLA_AE_HEADERS SET ACCOUNTING_ENTRY_STATUS_CODE = :B3 ,GROUP_ID = NULL
AE_HEADER_ID = :B1 AND APPLICATION_ID = :B2
l_flag := XLA_CREATE_ACCT_RPT_PVT.BeforeReport ;
if (l_flag) then
:XDO_OUT_PARAMETER := 1;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!