My Oracle Support Banner

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

Last updated on MARCH 12, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


When attempting to create a customer order with the 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.
  3. Verify the error message 'FRM-40508-Oracle error: unable to insert record.'





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.