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 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
Information in this document applies to any platform.
ARXTWMAI - Transactions
On Transactions Workbench form performance issue is seen while selecting a Customer.
TKPROF file, shows the following most expensive sql:
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 =
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