Incorrect Stock Count APPROVED_QUANTITY and COUNTED_TOTAL Values for Non-Ranged Pack Items
(Doc ID 2431057.1)
Last updated on MAY 27, 2020
Applies to:
Oracle Retail Store Inventory Management - Version 14.1 and laterInformation in this document applies to any platform.
Symptoms
In Oracle Retail Store Inventory Management (SIM), for a unit and amount stock count with auto authorize flag enabled and when the third party file contains counted quantity for a pack item and also for the respective component(s) (breakable component) that are not ranged in the store, the COUNTED_TOTAL column in STOCK_COUNT_LINE_ITEM table is updated as NULL and the APPROVED_QUANTITY is not updated correctly it's updated with the same value as the COUNTED_QUANTITY.
Steps to Recreate:
1. Schedule a unit and amount stock count, third party and auto authorize flag enabled.
2. Take the snapshot.
3. Make sure that the Third Party Stock Count file contains a pack item and also for the respective component(s) (breakable component) that are not ranged in the store.
4. Run the THIRD_PARTY_STOCK_COUNT_IMPORT batch job and notice that the COUNTED_TOTAL column in STOCK_COUNT_LINE_ITEM table is updated as NULL and the APPROVED_QUANTITY is not updated correctly it's updated with the same value as the COUNTED_QUANTITY.
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! |