LAST_UPDATE_DATETIME on ITEM_LOC_SOH Table Not Properly Updated When Re-approving an Allocation (Doc ID 1984656.1)

Last updated on APRIL 05, 2017

Applies to:

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

Symptoms

If the user pushes an 'Approved' allocation back to 'Worksheet' status, the ITEM_LOC_SOH.LAST_UPDATE_DATETIME column gets updated with the current date.   However, if the user then approves the allocation once more, the ITEM_LOC_SOH.LAST_UPDATE_DATETIME gets updated with the initial date (the date that existed prior to being set to 'Worksheet' status) instead of the current date.


Steps to Reproduce:

1. Select an 'Approved' allocation and check the LAST_UPDATE_DATETIME on ITEM_LOC_SOH for the warehouse (WH) and for the store.
2. Push the allocation back to 'Worksheet' and check the LAST_UPDATE_DATETIME on ITEM_LOC_SOH for the WH and for the store.
3. Re-approve the allocation and check the LAST_UPDATE_DATETIME on ITEM_LOC_SOH for the WH and for the store.

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