My Oracle Support Banner

Inconsistency Between RMS and SIM With Setting the Status of Item Location When Receiving Non Ranged Items from POS (Doc ID 1524935.1)

Last updated on SEPTEMBER 22, 2020

Applies to:

Oracle Retail Merchandising System - Version 13.2 to 13.2.6 [Release 13.2]
Information in this document applies to any platform.


Retail Merchendising System (RMS) sets item location status as 'Active' for non ranged items when a transaction is received from Point-Of-Service (POS) via Retail Sale Audit (ReSA) and the POSUPLD batch is executed.
In contrast, Store Inventory Management (SIM) sets the item location status to 'Q' ('Temporary Ranged') status.

Steps to Reproduce:

1. Create a transaction item.
2. Receive sales transaction from ReSA (POSU file) for the non ranged ITEM/LOC combination.
3. Run POSUPLD to upload the transaction to RMS.
4. Observe that new Item/Location relation is created with active ('A') status.

Business/Customer Impact:

Customer’s business practice is to not allow non-ranged items to be ordered or received via Direct Store Deliveries. When RMS receives a POS return transaction from ReSA or an inventory movement transaction from SIM for non-ranged items, RMS automatically creates an item/location record and sets the item status to Active. RMS then publishes this information to the RIB, at which point SIM updates the item status to Active.

This is an inconsistent behavior between RMS and SIM. When SIM loads POSUPLD information from ReSA, if processed prior to RMS or receives non-ranged items, SIM creates an item/location record and sets the item status to Q (temporary ranged). The setting of Q status restricts the business use of the item. This is the expected behavior the customer desires, since the item is not intended to be permanently ranged.


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

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