HZ_CUST_ACCOUNT_SITE_V2PUB.UPDATE_CUST_ACCT_SITE API Error: Update Territory_Id using TCA API errors with 'No Customer Account Site Was Found For Id xxxx' (Doc ID 1346591.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

In R12.0.3, run the TCA API procedure HZ_CUST_ACCOUNT_SITE_V2PUB.UPDATE_CUST_ACCT_SITE to update territory_id for an existing customer and the following error is received:

Error
No customer account site was found for ID xxxx.


It was verified that the ID exists and is active in table HZ_CUST_ACCT_SITES_ALL.

There is no issue when updating the Territory field manually for the IDs in question via the Customers form.

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