My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2018

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

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.