Performance with Create Accounting Program while Updating RA_CUST_TRX_LINE_GL_DIST_ALL
(Doc ID 2270028.1)
Last updated on FEBRUARY 06, 2018
Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.
Customer is facing performance issue with Create Accounting
Below is the query having issue:
UPDATE /*+ INDEX(ra_cust_trx_line_gl_dist_all ra_cust_trx_line_gl_dist_n6) */
RA_CUST_TRX_LINE_GL_DIST_ALL SET POSTING_CONTROL_ID = :B2 , GL_POSTED_DATE =
:B1 , LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID WHERE POSTING_CONTROL_ID = -3 AND
(CUSTOMER_TRX_ID, EVENT_ID) IN (SELECT EV.SOURCE_ID_INT_1, EV.EVENT_ID FROM
XLA_POST_ACCTG_EVENTS_V EV WHERE EV.APPLICATION_ID = :B3 AND
EV.PROCESS_STATUS_CODE = 'P' AND EV.EVENT_TYPE_CODE IN ('INV_CREATE' ,
'INV_UPDATE' , 'CM_CREATE' , 'CM_UPDATE' , 'DM_CREATE' , 'DM_UPDATE' ,
'DEP_CREATE' , 'DEP_UPDATE' , 'GUAR_CREATE' , 'GUAR_UPDATE' , 'CB_CREATE' ));
This is from arp_xla_extract_main_pkg.postprocessing.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.