Create Customer with API or Through Customer Interface Completes with Error - ORA-08004: HZ_CUST_ACCT_SITES_S.NEXTVAL exceeds MAXVALUE
Last updated on SEPTEMBER 05, 2017
Applies to:Oracle Receivables - Version 18.104.22.168 and later
Oracle Trading Community - Version 22.214.171.124 and later
Information in this document applies to any platform.
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.
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