Getting ORA-00060 Error While Running Stockcountprocess.ksh Batch For Warehouse Scenario
Last updated on JANUARY 05, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms