Error "FRM-40508 Unable To Insert Record" When Customers Orders Exceeds SEQ_NO
Last updated on MAY 09, 2018
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:
- Create a customer order where ORDCUST.ORDCUST_SEQ_NO is 9999.
- Try to Hit the 'OK' button from the 'ORDCUST' screen to complete the customer details.
- Verify the error message 'FRM-40508-Oracle error: unable to insert record.'
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