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!


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.