Retail Merchandising System (MOSC)

MOSC Banner

CUSTOMER_RESV and CUSTOMER_BACKORDERS buckets

edited Jan 6, 2015 12:23PM in Retail Merchandising System (MOSC) 6 commentsAnswered
Hi,
Can anyone please provide me information if these buckets on the ITEM_LOC_SOH table (CUSTOMER_RESV and CUSTOMER_BACKORDER) are used by any process at all?

Their name indicates that they're used for Customer Orders, but current Customer Orders (pickup/delivery or layway) functionality work the following way:

1. Customer Orders are normally captured on the POS.
2. Then, there are 2 mechanisms to integrate the customer orders into RMS/SIM:
    2.1 - Using a web service provided by SIM. In this case, SIM will create the customer order information and generate an inventory adjustment (published to RMS through RIB) to move the stock from available to unavailable, which will move the stock into the NON_SELLABLE_QTY bucket on ITEM_LOC_SOH

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center