My Oracle Support Banner

Field Shipment.ext_ref_no_in Is Not Updated When The Entire Receipt Is Zero In SIM (Doc ID 2941525.1)

Last updated on APRIL 12, 2023

Applies to:

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


When the receipt is processed at ZERO or when the AUTO CLOSE process is executed in SIM the payload is generated with all the amounts received at zero and also indicates the SIM receipt number, after processing in RMS the receipts are updated to ZERO in the table SHIPSKU
but does not update the field shipment.ext_ref_no although the Payload has the data.

Field shipment.ext_ref_no_in is not updated with receipt Number

shipment.ext_ref_no_in to update with Receipt Number

The issue can be reproduced at will with the following steps:
Scenario 1

-Create PO in RMS
- Create Allocation
- Make the PO receipt;
- Dispatch the allocation to the store;
- In Store Receipt Process:
  We can wait for SIM to automatically close receipt or the receipt can be made manually received with all quantities in 0

Scenario 2

-Create store to store transfer in SIM
-Perform transfer receipt with Zero quantity
-auto close the transfer
-check data in RMS

The issue has the following business impact:
Due to this issue,Required for receipt evaluations in RMS, without this populated field you don't know if it was the base of reconciling process who closed or if SIM sent the receipt in 0 and this field is required by Batch od_lookup_transfer_delivery_cont.ksh.


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.