Customer API Performance Issue: API HZ_CUST_ACCOUNT_SITE_V2PUB - Customer Site Use Creation Performance Issue (Doc ID 1191193.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Trading Community - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

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:


SELECT COUNT(*)
FROM
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'



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