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)
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
Million Knowledge Articles and hundreds of Community platforms