My Oracle Support Banner

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:

Oracle Retail Enterprise Inventory Cloud Service - Version 19.4 and later
Information in this document applies to any platform.


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.

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


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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