My Oracle Support Banner

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 later
Information 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!

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