Create Accounting: XLAACCUP Poor Performance During UPDATE to XLA_AE_LINES_GT (Doc ID 876122.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Attempting to run Create Accounting with the following parameters:

P_APPLICATION_ID=222:
P_SOURCE_APPLICATION_ID=222:
P_DUMMY=Y:P_LEDGER_ID=2021:
P_PROCESS_CATEGORY_CODE=TRANSACTIONS:
P_END_DATE="2009/07/01 00:00:00":
P_CREATE_ACCOUNTING_FLAG=Y:
P_DUMMY_PARAM_1=Y:
P_ACCOUNTING_MODE=F:
P_DUMMY_PARAM_2=Y:
P_ERRORS_ONLY_FLAG=N:
P_REPORT_STYLE=N:
P_TRANSFER_TO_GL_FLAG=Y:
P_DUMMY_PARAM_3=Y:
P_POST_IN_GL_FLAG=N:
P_GL_BATCH_NAME=:
P_MIN_PRECISION=2:
P_INCLUDE_ZERO_AMOUNT_LINES=N:
P_REQUEST_ID=:P_ENTITY_ID=:
P_SOURCE_APPLICATION_NAME=Receivables:
P_APPLICATION_NAME=Receivables:
P_LEDGER_NAME=US_LEDGER:
P_PROCESS_CATEGORY_NAME=Transactions:
P_CREATE_ACCOUNTING=Yes:
P_ACCOUNTING_MODE_NAME=Final:
P_ERRORS_ONLY=No:
P_ACCOUNTING_REPORT_LEVEL=No Report:
P_TRANSFER_TO_GL=Yes:
P_POST_IN_GL=No:
P_INCLUDE_ZERO_AMT_LINES=No:
P_VALUATION_METHOD_CODE=:
P_SECURITY_INT_1=:
P_SECURITY_INT_2=:
P_SECURITY_INT_3=:
P_SECURITY_CHAR_1=:
P_SECURITY_CHAR_2=:
P_SECURITY_CHAR_3=:
P_CONC_REQUEST_ID=:
P_INCLUDE_USER_TRX_ID_FLAG=N:
P_INCLUDE_USER_TRX_IDENTIFIERS=No:

and you encounter poor performance. The trace shows that the following update is slow:

 

Changes

 

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