RMS Updates ITEM_LOC_SOH With Incorrect AV_COST During Reconcile Process
Last updated on DECEMBER 05, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.
In Oracle Retail Merchandising System (RMS) 13.2.x, we find that when a late document is received and VDATE is greater than the value of "SHIPMENT.RECEIVING_DATE + SYSTEM_OPTIONS.WS_AUTO_CLOSE_DAYS", the DOCCLOSE batch executes the reconcile process and updates ITEM_LOC_SOH.AV_COST with an incorrect value. Because of this error, TRAN_DATA tables are populated with incorrect values, as well.
Steps to Reproduce:
- Partially receive a transfer (TSF) that was shipped but never received.
- Use a late receive_date to simulate the reconcile process.
- Run DOCCLOSE batch to close the TSF partially received in step 1.
- Note that DOCCLOSE batch closes the TSF and does the reconcile process.
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