My Oracle Support Banner

Updates to the SOStatusCre Message from RWMS Aren't Consumed in the SIM Staged Table (Doc ID 2506765.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.


When Oracle Retail Warehouse Management (RWMS) sends a new SOStatusCre with Status DS in each item, the transfer is created in Oracle Retail Store Inventory Management (SIM).
Every update after that with status SI or SD fails in the staged table with the error "This item already exists as a line item."

Steps to Recreate:

1. Send a SOStatusCre from RWMS with status SI.
2. Remove some inventory so that RWMS sends a new SOStatusCre with SD, the new messages will fail to be processed in the SIM MPS_STAGED_MESSAGE table with the above mentioned error.


To view full details, 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 a vibrant support community of peers and Oracle experts.