Third Party Stock Count Import Job Returns Constraint SIM01.STOCK_COUNT_LINE_ITEM_UIN_UK Violated (Doc ID 2940487.1)

Last updated on APRIL 12, 2023

Applies to:

Symptoms

When attempting to process a Third Party Stock Count Import, with a UIN ite, in status 8 included in the stock count import file, the following error occurs.

ERROR
-----------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create Unit & Amount product group with count method as Third party , select only SOH > 0 & SOH < 0 to include in the count
2. Create Product group component and add department item hierarchy (Dept- 1118) and save
3. Schedule the count and on schedule day run Generate Unit & Amount stock batch – Only item 100000147 on Dept 1118 having SOH >0 is included in count
4. Once the Stock count is generated, create a stock count upload file to include UIN item (This was not included on count as SOH =0) with couple valid UINs in status 8 (missing), the UIN item is part of same item hierarchy as items on count . – Serial Item 100000024 which also belongs Dept 1118 is included in upload file
5. Upload the Third party stock count upload file
6. Run the adhoc job ‘Third Party Stock Count Import’ . Batch fails.

Cause

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