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.
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.'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms