Customer API Performance Issue: API HZ_CUST_ACCOUNT_SITE_V2PUB - Customer Site Use Creation Performance Issue
Last updated on SEPTEMBER 05, 2017
Applies to:Oracle Trading Community - Version 22.214.171.124 and later
Information in this document applies to any platform.
You are running API hz_cust_account_site_v2pub.create_cust_site_use, and it is very slow.
The trace shows the following query as the one causing the issue:
HZ_CUST_ACCOUNTS A, HZ_CUST_ACCT_SITES CAS, HZ_CUST_SITE_USES SU WHERE
A.CUST_ACCOUNT_ID = :B2 AND A.CUST_ACCOUNT_ID = CAS.CUST_ACCOUNT_ID AND
CAS.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID AND SU.SITE_USE_CODE = :B1 AND
SU.STATUS = 'A' AND SU.PRIMARY_FLAG = 'Y'
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