My Oracle Support Banner

Unable To Enter Transaction Due to Performance Issue for Specific Customers Only (Doc ID 870792.1)

Last updated on FEBRUARY 14, 2018

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
ARXTWMAI - Transactions
ARTUVALB.pls


Symptoms

On Transactions Workbench form performance issue is seen while selecting a Customer. 

TKPROF file, shows the following most expensive sql:

SELECT 'Y'
FROM
HZ_CUST_ACCOUNTS CUST_ACCT WHERE CUST_ACCT.CUST_ACCOUNT_ID = :B2 AND (
CUST_ACCT.CUST_ACCOUNT_ID = :B1 OR ( CUST_ACCT.STATUS = 'A' ) ) AND EXISTS
( SELECT 'X' FROM HZ_CUST_ACCT_RELATE CR WHERE CR.RELATED_CUST_ACCOUNT_ID =
:B3 AND CR.STATUS = 'A' AND CR.BILL_TO_FLAG = 'Y' AND
CUST_ACCT.CUST_ACCOUNT_ID = CR.CUST_ACCOUNT_ID UNION SELECT 'X' FROM DUAL
WHERE CUST_ACCT.CUST_ACCOUNT_ID =TO_NUMBER(:B1 ) UNION SELECT 'X' FROM DUAL
WHERE CUST_ACCT.CUST_ACCOUNT_ID =TO_NUMBER(:B3 ) UNION SELECT 'X' FROM
AR_PAYING_RELATIONSHIPS_V REL, HZ_CUST_ACCOUNTS ACC WHERE REL.PARTY_ID =
ACC.PARTY_ID AND REL.RELATED_CUST_ACCOUNT_ID = :B3 AND :B4 BETWEEN
EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND CUST_ACCT.CUST_ACCOUNT_ID =
ACC.CUST_ACCOUNT_ID )

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.