"ORA-12899: Value Too Large for Column PA_CT.ID_CT" Error Occurs When Customers are Created in Central Office
Last updated on JULY 18, 2016
Applies to:Oracle Retail Central Office - Version 13.3 and later
Information in this document applies to any platform.
When attempting to create a new customer in Oracle Retail Central office (ORCO) , the following error occurs:
Sample Steps to Reproduce:
- Check the sequence PA_CT_SEQ in the CO database.
- Note the last cached value (in test case, this value is '1021646').
- Create a new customer in CO.
- The ID generated is more than 14 digits, which is the maximum limit of the PA_CT.ID_CT.
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