My Oracle Support Banner

Last Update Datetime Column Not Updated in ITEM_LOC_SOH(ILS), While Doing Stock Order Reconciliation For FC,RL,SL Adjust Types (Doc ID 2767934.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

Last update datetime is not updated in ILS while doing stock order reconciliation for FC,RL,SL adjust types.

When BOL/Carton is reconciled via adjust type Freight Claim, IN TRANSIT QTY bucket is cleared in ITEM LOC SOH from destination location but last update datetime is not updated.  This is applicable for Shipping and Receiving Location adjust types as well but not for Forced Receipt. Since Force Receipt is finally increasing Stock On Hand (SOH) of destination location hence SOH_UPDATE_DATETIME and LAST_UPDATE_DATETIME both are updated properly.

But in case of Freight Claim, Shipping Location and Receiving Location adjust types, expectation is LAST_UPDATE_DATETIME should get updated. 

Steps To Recreate:

  1.  Perform stock order reconciliation using Adjust_type as 'Freight claim'/ shipping location / Receiving location.
  2.  Check ITEM_LOC_SOH table, in-transit cleared and tran_data record inserted.
  3.  But ITEM_LOC_SOH.LAST_UPDATE_DATETIME not updated .

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.