Model Upload Fails with 'Error While Executing' & ORA-02273 on Dim_org_structure.sql on Merge with FSDW 7.3 (Doc ID 1580702.1)

Last updated on SEPTEMBER 06, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Oracle Financial Services Profitability Analytics - Version 6.1 and later
Oracle Financial Services Data Foundation - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, after merging the Profitability Analytics (PFTBI) 6.1 data model into an existing Financial Services Data Warehouse (FSDW) 7.3 data model, the data model upload fails.  The following error is reported in the model upload log in /<ftpshare>/<Infodom>/logs:

dim_org_structure.sql---------Error while executing Update :Failed Executing Query. Reason: ORA-02273: this unique/primary key is referenced by some foreign keys
Inside the Rollback Segment
Number of Exec Statements = 125

The dim_org_structure.sql, located in /<ftpshare>/<Infodom>/erwin/scripts/table contains the following:

Alter table dim_org_structure drop CONSTRAINT PK_dim_org_structure drop INDEX

The model upload process is trying to drop the required primary key on DIM_ORG_STRUCTURE.

Steps to Reproduce:

  1. Log into OFSAA Infrastructure
  2. Go to Unified Metadata Manager > Import Model
  3. Select the merged XML file and upload

The model upload ends in an error.

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