Salesprocess Rejecting POSU Files for Ecomm Return Items Going to Different Warehouses
(Doc ID 2977665.1)
Last updated on MAY 09, 2024
Applies to:
Oracle Retail Merchandising System - Version 16.0.3 to 16.0.3 [Release 16.0]Information in this document applies to any platform.
Symptoms
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:
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.
Cause
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
Symptoms |
Cause |
Solution |
References |