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 APRIL 03, 2019
Applies to:Oracle Receivables - Version 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
Oracle Trading Community - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|
|Still Have Questions?|