Model Upload Fails with 'Error While Executing' & ORA-02273 on Dim_org_structure.sql on Merge with FSDW 7.3
Last updated on FEBRUARY 12, 2018
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)
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:
- Log into OFSAA Infrastructure
- Go to Unified Metadata Manager > Import Model
- Select the merged XML file and upload
The model upload ends in an error.
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