"ORA-12899: Value Too Large for Column PA_CT.ID_CT" Error Occurs When Customers are Created in Central Office

(Doc ID 1969855.1)

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:

  1. Check the sequence PA_CT_SEQ in the CO database.
  2. Note the last cached value (in test case, this value is '1021646').
  3. Create a new customer in CO.
  4. 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