My Oracle Support Banner

R2:FC_PRICECHG_JOB Is Failing In Stage (Doc ID 2955567.1)

Last updated on JUNE 15, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run fc_pricechg.ksh, the following error occurs.

ERROR
-----------------------
fc_pricechg.ksh~20230203040908~EXEC_SQL~
@0PACKAGE_ERROR@1ORA-00001: unique constraint (RMS01.PK_COST_EVENT_THREAD)
viola
ted@2FUTURE_COST_THREAD_SQL.THREAD_ITEM_LOC
fc_pricechg.ksh~20230203040911~CAPTU

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Execute fc_pricechg.ksh

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
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.