Unit & Amount Stock Counts Not Updating Item with 0 SOH to Stock Count When Include SOH = 0 Option Checked in Product Group (Doc ID 2873614.1)

Last updated on JUNE 07, 2022

Applies to:

Symptoms

When a unit and amount third party stock count is generated that includes items in the ThirdParty file whose SOH = 0 at the time of stock count generation, and the Include SOH = 0 option is unchecked in the Product Group, the items are not added to the STOCK_COUNT_LINE_ITEM table and therefore not included in the authorized results.

EXPECTED BEHAVIOR
-----------------------
Expect the items to be included in the authorized results if included in the third party counted file.

Steps to Reproduce:

Data setup:

Item 22526016 belongs to dept 20, cl 1, subcl 8 which had 119 items on stock_count_line_item for stock_count_id 69098. 83 of these items had a non-zero count quantity.
Item 14712094 belongs to dept 57, cl 7, subcl 10 which had 43 items on stock_count_line_item for stock_count_id 69098. 19 of these items had a non-zero count quantity.

ThirdPartyImport file

FHEAD|116|69098|
FDETL|20220203160038||22526016|100||
FDETL|20220203160038||14712094|20||


1. Create product group for Unit & amount count- do not check the include SOH =0 box, check auto-authorize, counting method = third party
2. Add components (all hierarchies)
3. Create schedule...count date is tomorrow
4. Run generate unit & amount count job
5. Take snapshot (run job if not scheduled)
6. Upload the third party count file (it should have some items that had 0 SOH in SIOCS when the count was generated)
7. Run the third party stock count import job
8. Verify results...count should be in authorized status, and items with a count qty in the third party file that had 0 SOH when the count was generated are not included in the authorized results.

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.