My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Oracle Financial Services Enterprise Financial Performance 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)


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.