Create Customer with API or Through Customer Interface Completes with Error - ORA-08004: HZ_CUST_ACCT_SITES_S.NEXTVAL exceeds MAXVALUE

(Doc ID 1531039.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

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

Symptoms

Customer Interface (RACUST) completes with the following error

racina: ORA-08004: HZ_CUST_ACCT_SITES_S.NEXTVAL exceeds MAXVALUE
racina: Error inserting addresses

This issue can also occur when creating a new customer using the public API HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE.

The program fails in HZ_CUST_ACCT_SITES_PKG.

The index HZ_CUST_ACCT_SITES_U2 is a unique index on ORIG_SYSTEM_REFERENCE & ORG_ID, so the code (from HZ_CUST_ACCT_SITES_PKG) is just going to result in a continual loop if encounters a unique constraint violation on this index.

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