Retrieving the cost scenario that was accidentally deleted
Hi All,
''ORA-00001 Unique Constraint Violation (FUSION_CST_OH_RATES_U 1) After Deleting and recreating the cost scenario''
We accidentally deleted a cost scenario that contained multiple lines, including the following:
Standard costs
Overhead rates
Rolled-up item costs
Other related cost and rate details
We are now attempting to recreate the same cost scenario using the original effective date. However, the system treats some of the data as duplicate records and displays the following error:?
ORA-00001: unique constraint (FUSION_CST_OH_RATES_U1) violated
It appears that some cost or overhead-rate records associated with the deleted scenario may still exist in the underlying tables, even though the cost scenario was deleted from the application.