Performance with Create Accounting Program while Updating RA_CUST_TRX_LINE_GL_DIST_ALL (Doc ID 2270028.1)

Last updated on MAY 26, 2017

Applies to:

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

Symptoms

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.



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