Error "FRM-40508 Unable To Insert Record" When Customers' Orders Exceeds 9999 SEQ_NO (Doc ID 1998638.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a customer order while this customer id already has amount of orders that exceeds 9999, the following error occurs.
Note: This error occurs due to that every CUST_ID there is a ordcust_seq_no in table ORDCUST. This field is NUMBER (4) it means that largest number to be inserted is 9999, this should be changed to greater value as 999999


Steps to recreate

1. Create a customer order where ORDCUST.ORDCUST_SEQ_NO is 9999.
2. Try to Hit the 'OK' button from the 'ORDCUST' screen to complete the customer details. You should see an error message 'FRM-40508-Oracle error: unable to insert record.'

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