My Oracle Support Banner

Data Model Upload Failed with ORA-02273 on N_PROD_SKEY for the DIM_PRODUCT table (Doc ID 2568226.1)

Last updated on AUGUST 02, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.7 version, Install and Upgrade Issues

When performing an upgrade to Profitability Management 8.0.7 using setup.sh SILENT, model upload failed with below error.


Error

Model Upload Log:
Dropped the Primary Key stg_forex_txns.sql
adding primary key to execution orderAlter table stg_forex_txns add CONSTRAINT PK_690 PRIMARY KEY (FIC_MIS_DATE,V_TXN_REF_NO)Dropping the Primary Key dim_product.sql
dim_product.sql---------ORA-02273: this unique/primary key is referenced by some foreign key                                                                                                                                          

ETLService.log shows
[ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column PRODUCT_CODE in the table dim_products_b

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column N_PROD_SKEY in the table dim_product

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column N_PRODUCT_ID in the table dim_product

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column N_ORG_UNIT_SKEY in the table dim_org_unit

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column N_ORG_UNIT_ID in the table dim_org_unit

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column V_ORG_UNIT_NAME in the table dim_org_unit

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column N_GL_ACCOUNT_SKEY in the table dim_gl_account

[DEBUG] [APP]  [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::
Data exists for the column N_GL_ACCOUNT_ID in the table dim_gl_account
..etc


Steps To Replicate:
1. Merge current model with custom model and include the custom model in the upgrade.
2. Perform incremental model upload and found the above error.

 

Changes

 

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