Need The Logic Behind The Item Count Calculated Between Product Group And Stock Count Stages (Doc ID 2983290.1)

Last updated on OCTOBER 26, 2023

Applies to:

Goal

Need the logic behind the item count calculated between Product group and stock count stages.

There is a Mismatch of items between Product Group components in EICS with Actual Stock count generated in SOCS.

Please can you explain and share the formula that is being used while calculating the number of items in a product group component screen at the time of the creation VS the formula used to calculate the number of items eligible for stock take?

Example:
--------------
1. Create a product group in EICS, add components and check the number of items in the product group
2. Schedule the product group
3. Check the number of items that become eligible for counting in SOCS

Issue: Note that here will be significant difference in the item counts approximated by EICS Vs the item eligible for stock take.
In Store and Stock Count operations, the users who set up the Product Group are not the ones who count the products in store. The count of items estimated when a stock take is planned is significantly different from the count when the stock take is performed.
We are seeing difference with PG count of 3000 items and stock take item count as 20000+.

This makes it impossible for business to plan and line up the right number of resources for the stock count.

Solution

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