Getting ORA-00060 Error While Running Stockcountprocess.ksh Batch For Warehouse Scenario

(Doc ID 2345478.1)

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.

Symptoms

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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms