Fcexec Fails With ORA-00001: unique constraint RMS.PK_FUTURE_COST_GTT violated Error (Doc ID 3070599.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Symptoms

On : 16.0.3 version, Other

When Pack Items assigned as Primary Cost Packs are being updated with the Component Item’s Item Parent and this in turn causes any future cost event processing for the component item/pack item,
the following error occurs.

ERROR
-----------------------
(ORA-00001: unique constraint (RMS.PK_FUTURE_COST_GTT) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Take a note of VDATE.
2. Create a New Style Item (ITEM_LEVEL = 1, TRAN_LEVEL = 2).
3.Create Transactional Level (SKU) Item below Style Item (create UPC below SKU as well)
4.Range Style to a Store and a Warehouse location
5.Approve the Style Item and all Children and notice Item Family has been created.
6.Notice the 2 NIL Cost Events created for the SKU at the store and the warehouse:
7.Run fcthreadexec and fcexec and notice that a record has been created in FUTURE_COST for the SKU at each location (notice the ITEM_PARENT value is correct):
8.Create a Simple Pack for the SKU
9.Copy Suppliers, Stores and Warehouse when Creating the Pack
10.Create a UPC for the Simple Pack as well:
11.Approve the Pack
12.Notice the 2 NIL Cost Events created for the Simple Pack at the store and the warehouse
13.Run fcthreadexec and fcexec and notice that a record has been created in FUTURE_COST for the Simple Pack at each location (notice the ITEM_PARENT value for the Simple Pack is NULL which is correct):
14.Assign the Simple Pack as the Primary Cost Pack for the SKU at the Store Location
15.Assign the Simple Pack as the Primary Cost Pack at the Warehouse Location
16.Notice that a Primary Pack (PP) Cost Event have been created for assigning the Simple Pack as the Primary Cost Pack at each location
17.Run fcthreadexec and fcexec and notice the primary cost pack as been assigned to the FUTURE_COST.PRIMARY_COST_PACK field for the SKU at each location and notice the cost has been calculated for the SKU based on the Primary Cost Pack
18.Run dtesys to advance the VDATE
19.Create a Cost Change for the SKU at both locations for a future date
20.Run fcthreadexec and fexec and notice records have been created for each location for both the SKU and the Primary Cost Pack. Notice the Primary Cost Pack has inherited the SKU’s Item Parent in the FUTURE_COST.ITEM_PARENT field. (This is NOT Correct)
21.Run dtesys to advance the VDATE
22.Create an Item Reclassification for the Style Item for a future date:
23.Run fcthreadexec and fcexec and notice that threads of fcexec fail with a Primary Key constraint on the FUTURE_COST_GTT table.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, error occurs while performing reclassification for parent items

Changes

Cause

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