My Oracle Support Banner

Transfer Partial Receipt with a Catch Weight Item Throws "ORA-01476" Error (Doc ID 2410771.1)

Last updated on JUNE 12, 2021

Applies to:

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


When a Store Inventory Management(SIM) created transfer is received partially in one container, and the rest is later received in a second container, where the second container has at least one catch weight item, the receipt message stays in error on RIB_MESSAGE_FAILURE with error:

Steps to Reproduce:

1. Create two transfers in SIM, one for regular item and one for a catch weight item.
2. Create transfer shipment, attached container one for first transfer and container two for second transfer with catch weight item.
3. Dispatch the transfer.
4. Receive the first transfer (first container) on the destination store.
At this point the item from the second transfer will be reconciled with adjust type NL on SHIPSKU table.
5. Receive the second transfer (second container).
Notice this message is not integrated on Retail Merchandise System(RMS) and stays in error on RIB_MESSAGE_FAILURE with ORA-01476.




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.