Salesprocess Rejecting POSU Files for Ecomm Return Items Going to Different Warehouses
(Doc ID 2977665.1)
Last updated on OCTOBER 05, 2023
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.
When attempting to load some return transactions from E commerce and the POSU file contains multiple lines with the same item and two different warehouses returns are rejected with error:
ORA-00001: unique constraint (RMS.PK_INV_STATUS_QTY) violated@2CORESVC_SALES_UPLOAD_PRST_SQL.PERSIST_CO_RTN_BOOK_TSF
The issue can be reproduced at will with the following steps:
1. Load ecomm return transactions (same ecomm store, same item but different return warehouse for each return transaction) in ReSA and create the POSU file.
2. Run uploadsales_all and salesprocess, error is visible in the log file.
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