Salesprocess.ksh Failing With an Error "ORA-00001" For Consignment Items

(Doc ID 2154063.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Retail Sales Audit - Version 14.0.2 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.


When attempting to perform sales for consignment item the following error occurs.

Steps To Recreate:

1.Create a consignment item with 4 decimal value consignment rate.
2.Perform a SALE of the same and  load it to TRAN_DATA table.
3.Perform again SALE for the same item and observe the above error in SVC_POSUPLD_STATUS table.


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