Transfer Partial Receipt with a Catch Weight Item Throws "ORA-01476...STOCK_ORDER_RCV_SQL.DETERMINE_RECEIPT_WEIGHT."

(Doc ID 2410771.1)

Last updated on JUNE 18, 2018

Applies to:

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

Symptoms

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.

Cause

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 hundreds of Community platforms