My Oracle Support Banner

iReceivables Performance issue when Opening Account tab/Balances (Doc ID 2416427.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle iReceivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 iReceivables form performance issue when selecting a customer , Account Summary
Clicking on the Account tab /open balances taking long time to retrieve data

 

Tkprof shows the following as the SQL running long

SELECT /*+ index(ARPAYMENTSCHEDULES AR_PAYMENT_SCHEDULES_N2)
LEADING(RaCmRequests)*/ NVL(SUM ( TOTAL_AMOUNT ), 0)
FROM
RA_CM_REQUESTS RACMREQUESTS, AR_PAYMENT_SCHEDULES ARPAYMENTSCHEDULES,
AR_IREC_USER_ACCT_SITES_ALL ACCTSITES, RA_CUSTOMER_TRX CT WHERE
(RACMREQUESTS.CUSTOMER_TRX_ID = ARPAYMENTSCHEDULES.CUSTOMER_TRX_ID) AND
NVL(ARPAYMENTSCHEDULES.TERMS_SEQUENCE_NUMBER,1) = 1 AND ACCTSITES.USER_ID=
FND_GLOBAL.USER_ID() AND ARPAYMENTSCHEDULES.CUSTOMER_ID=:B3 AND
ARPAYMENTSCHEDULES.CUSTOMER_ID= ACCTSITES.CUSTOMER_ID AND
ACCTSITES.CUSTOMER_SITE_USE_ID=ARPAYMENTSCHEDULES.CUSTOMER_SITE_USE_ID AND
ACCTSITES.SESSION_ID=:B2 AND ( ARPAYMENTSCHEDULES.CLASS = 'INV' OR
ARPAYMENTSCHEDULES.CLASS = 'GUAR' OR ARPAYMENTSCHEDULES.CLASS = 'CB' OR
ARPAYMENTSCHEDULES.CLASS = 'DM' OR ARPAYMENTSCHEDULES.CLASS = 'DEP' ) AND(
ARPAYMENTSCHEDULES.INVOICE_CURRENCY_CODE = :B1 ) AND (RACMREQUESTS.STATUS
IN ('PENDING_APPROVAL','APPROVED_PEND_COMP')) AND
ARPAYMENTSCHEDULES.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND(TRUNC(ARPAYMENTSCHEDULES.TRX_DATE)) >= TRUNC(DECODE(
NVL(FND_PROFILE.VALUE('ARI_FILTER_TRXDATE_OLDER'), 0), 0,
ARPAYMENTSCHEDULES.TRX_DATE,
(SYSDATE-FND_PROFILE.VALUE('ARI_FILTER_TRXDATE_OLDER')))) AND
CT.PRINTING_OPTION = DECODE(NVL(FND_PROFILE.VALUE('ARI_FILTER_DONOTPRINT_TR
X'), 'NOT'), 'Y', 'PRI', CT.PRINTING_OPTION)<> -3

 

 

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!


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