Salesprocess Rejecting POSU Files for Ecomm Return Items Going to Different Warehouses (Doc ID 2977665.1)

Last updated on OCTOBER 05, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.