My Oracle Support Banner

R12: Error When Generating Forecast: ORA-00001: unique constraint (PA.PA_RBS_ELEMENTS_U1) (Doc ID 2225315.1)

Last updated on AUGUST 18, 2022

Applies to:

Oracle Project Planning and Control - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When trying to generate a revenue/cost forecast for a project the following errors occur:

1. ORA-00001: unique constraint (PA.PA_RBS_ELEMENTS_U1) violated in Package PA_RBS_MAPPING Procedure create_rbs_element
2. ORA-00001: unique constraint (PA.PA_RBS_ELEMENTS_U1) violated in Package PA_RBS_MAPPING Procedure map_rbs_txn
3. ORA-00001: unique constraint (PA.PA_RBS_ELEMENTS_U1) violated in Package PA_RBS_MAPPING Procedure map_rbs_plans
4. ORA-00001: unique constraint (PA.PA_RBS_ELEMENTS_U1) violated in Package PA_RLMI_RBS_MAP_PUB Procedure Map_Rlmi_Rbs
5. ORA-00001: unique constraint (PA.PA_RBS_ELEMENTS_U1) violated in Package PA_FP_MAP_BV_PUB Procedure MAINTAIN_RBS_DTLS
6. User-Defined Exception in Package PA_FP_GEN_FCST_AMT_PUB1 Procedure MAINTAIN_BUDGET_VERSION
7. User-Defined Exception in Package PA_FP_GEN_FCST_AMT_PUB Procedure GENERATE_FCST_AMT_WRP
8. User-Defined Exception in Package PA_FP_GEN_FCST_PG_PKG Procedure UPD_VER_DTLS_AND_GEN_AMT

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.