Getting ORA-00060 Error While Running Stockcountprocess.ksh Batch For Warehouse Scenario
(Doc ID 2345478.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Retail Merchandising System - Version 14.0.1 and later
Information in this document applies to any platform.
When attempting to run stockcountprocess batch, the following error occurs.
Error: @0PACKAGE_ERROR@1ORA-00001: unique constraint (RMS13EU.PK_ITEM_COUNTRY) violated@2NEW_ITEM_LOC_SQL.CHECK_ITEM_COUNTRY
Steps To Reproduce:
1. Upload stock count result files with different locations .
2. Make sure that for the test records (in the stock count result upload file) item-location ranging doesn’t exist in RMS.
3. Also make sure the item-location combination falls under different threads of stock count process batch.
4. Run stockcountprocess batch.
5. Note the above error.
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