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

Last updated on JUNE 14, 2017

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:

Error

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms