Docclose Not Treating Short or Over Receipted Store-to-store Transfers Properly (Doc ID 1905404.1)

Last updated on JANUARY 11, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.6 and later
Information in this document applies to any platform.
Checked for relevance on 11-Jan-2016.

Symptoms

Running Oracle Retail Merchandising System (RMS) 13.2.6.

Docclose does not treat short or over receipted store-to-store transfers properly when being closed.

For store-to-store transfers created and shipped in Oracle Store Inventory Managment (SIM), if the receiving store receives more goods than was shipped or receives less units then what was shipped, when the transfer is closed via the docclose process in RMS, the receipt discrepancies are not handled correctly. When SIM Store to Store transfers are closed in RMS through the docclose process (when tsf_auto_close_st = N), the expected behavior is that the inventory shortage or overage is handled the same as it would be if the transfer was closed automatically ( if tsf_auto_close_st = Y).

   RMS system options:
     SIM_TSF_FORCE_CLOSE_IND = 'NL'
     tsf_auto_close_st = N
     tsf_close_overdue = N
     tsf_force_close_ind = SL
     tsf_over_receipt_ind = SL
     UNIT_OPTIONS.SS_AUTO_LCOSE_DAYS = 1

   SIM ADMIN settings:
     RK_CONFIG Transfers – Transfer Force Close indicator = 'NL' (No Loss).

Steps to Reproduce:
1. In SIM, create a store-to-store transfer with a qty > 1 - Dispatch the transfer
2. Verify that in SIM, units shipped moved to in_transit for the receiving store and removed from stock on hand for the sending store
3. Verify that in RMS, units shipped moved to in_transit for the receiving store and removed from stock on hand for the sending store
4. In SIM, change to the receiving location and receive half of the qty and confirm receipt.
5. Verify that in SIM, units received have been added to the receiving locations stock on hand, units in_transit for the receiving store has been set to 0 and the under-received qty is placed back into the sending stores inventory.
6. Verify that in RMS, units received have been added to the receiving locations stock on hand, units in_transit for the receiving store only been decremented by the qty received
7. Run batch or move the vdate to vdate +1 and then run docclose.
8. Verify that in RMS the intransit qty for the receiving store has been decremented by the un-received qty. and the unreceived qty did NOT move back to the sending store.
9. SOH between SIM and RMS are now out of synch. - Expected that now that the transfer has been closed, SIM and RMS would be in Synch since SIM is set to 'NL' and RMS.SYSTEM_OIPTIONS.SIM_FORCE_CLOSE_IND = NL

(For 14.0, it was noticed that the STOCK_ORDER_RECONCILE_SQL.APPLY_ADJUSTMENTS_DOC_CLOSE has been corrected.)

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