Pack SKU Counts Not Combining with Component Counts from Separate Child Counts (Doc ID 3037233.1)

Last updated on AUGUST 08, 2024

Applies to:

Symptoms

When uploading a 3rd party Stock Count file, component skus combine with pack skus on separate child counts.

select * from item_Component where ITEM_ID in ('302920079','302920080');

ITEM_ID COMPONENT_ITEM_ID QUANTITY

--------------------------------------------------------------------------------------

302920080 302920079 24

--------------------------------------------------------------------------------------

Snapshot taken after store close and before store open the next morning.

1. Stock Count scheduled for April 8th 2024 - 518819 (Auto Authorize = Yes)

2. Pack and component (Item Type 25) in same child.

3. Pack and SKU included in ThirdParty count file

FDETL|20240219121515||302920079|100||

FDETL|20240219122048||302920080|7||

4. Load the file to Imports folder

5. Run ThirdPartyStockCountImport batch

6. Check the Counted Quantities

select ITEM_ID, COUNT_SNAPSHOT,COUNTED_QUANTITY,APPROVED_QUANTITY, COUNTED_TOTAL, BREAKABLE_COMPONENT, ITEM_TYPE from STOCK_COUNT_LINE_ITEM where STOCK_COUNT_ID = 518819 and ITEM_ID in ('302920079','302920080');

ITEM_ID, COUNT_SNAPSHOT, COUNTED_QUANTITY, APPROVED_QUANTITY, COUNTED_TOTAL, BREAKABLE_COMPONENT, ITEM_TYPE

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

302920079 3887 100 100 268 Y 0

302920080 0 7 7 7 N 25

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue: Approved Quantity is not calculated correctly for the component item. it should have been 100 + (7*24) = 268

Changes

Cause

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