My Oracle Support Banner

RIP to ATS Inventory Adjustment Message Sent from RWMS to RMS on Performing Container Putaway for an Open Appointment Fails in RIB-RMS Hospital With ORA-01476 Error (Doc ID 1936235.1)

Last updated on AUGUST 07, 2020

Applies to:

Oracle Retail Warehouse Management System - Version 13.2 and later
Oracle Retail Merchandising System - Version 13.2 and later
Information in this document applies to any platform.


When storing products that are still being received in Retail Warehouse Management System (RWMS) (i.e., storing them before closing the schedule in RWMS), the following error occurs in Retail Merchandising System (RMS):

Operationally, the distribution center (DC) starts storing the products being received before finalizing the receiving portion of it.  That is, the products are stored before closing the schedule in RWMS -- a functionality allowed by the application.  In this situation, RWMS sends the storage messages to RMS ATS (Available To Sell) before sending the receiving messages RIP (Receiving in Progress), which will only be sent out after the closing of the schedule in RWMS. This is generating an error in the RMS Hospital.

Steps to Reproduce:

  1. Ensure SCP (system control parameter) 'receipt_level' is set to A.
  2. In RMS create 2 new items and ensure they flow to RWMS.
  3. In RMS create a new purchase order (PO) for the above 2 items and ensure it flows to RWMS.
  4. Create a PO appointment for full PO.
  5. Schedule it and print labels.
  6. Receive it, but do not close it.
  7. Go to Transport screen and try to putaway the container.  Since it is attached to a Less Than Case (LTC) location, a replenishment is created.  This creates RIP to ATS adjustments to be published to RMS.
  8. Close the appointment.
  9. Check RMS DB and note that the message failed in the RIB hospital tables.  This error is causing discrepancies in the DC stock.




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.