My Oracle Support Banner

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.

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

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
Symptoms
Changes
Cause
Solution
References


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