Incorrect Result for an Adhoc Stock Count after Setting Variance % And Standard UOM Tolerance (Doc ID 2267913.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

Incorrect Result for Adhoc Stock Count after setting variance % and standard UOM tolerance

Steps to Recreate :

1. Navigate:Login to SIM application> Admin>Setup>Tolerances>Select Topic as 'Adhoc Stock Count'>Click on Apply>For department 5001 and class 5001,set variance % as 10 and variance standard UOM as 0>Click on Save.
2. Login to SIM Handheld> Navigate to Inventory Management>Stock Counts>Adhoc Stock Count >Create a new stock count>Enter the item id >Enter the counted quantity for the count which is greater than the 10% of total quantity of item in the store_item_stock table >Enter another item id>Enter the counted quantity for the count which is lesser than the 10% of total quantity of item in the store_item_stock table.
3. Complete the count>Check stock_count_line_item table for both the items the discrepant column is 'Y' but it should be 'N' for second item and also it is directly going to authorise phase and not going to Recount Phase for the items which are discrepant.
4. Repeat the above steps and Execute adhoc stock count for variance standard UOM as 10 and variance % as 0 for department 5001 and class 5001.
5. In this case also all items have discrepant column as 'Y' in stock_count_line_item table irrespective of the variance provided.
6. Execute an Adhoc Stock Count after setting variance % and variance standard UOM tolerance both as 10 from Tolerances screen of SIM application.
7. For this case the items become discrepant based on the variance provided but the stock count goes directly to authorize phase and does not go to the recount phase.
   
   

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.