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

Last updated on JULY 31, 2011

Applies to:

Oracle Receivables - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5.10 to 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 )

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