PFT 8.0.2 Installation Issues Which Create Tables in the Atomic Schema Outside the Data Model (Doc ID 2213099.1)

Last updated on APRIL 10, 2017

Applies to:

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

Symptoms

There appears to be issues with the Profitability Application Pack 8.0.2 installation which creates table in the Atomic schema outside the data model.

The Model upload failed stating that Upload process was not able to drop the primary key for the table dim_org_structure as it was referenced through some foreign key which was not deleted by the model upload process as those foreign keys are not available in the database.xml file.  Two tables namely FSI_M_WIF_AVF and FSI_M_WIF_RVF are referenced to Dim_Org_Structure through foreign key FK_T_WIF_AVF_8 and FK_T_RVF_3 respectively, however those foreign keys or the entities are not available in the <INFODOM>_database.xml file. Also many tables were created during PFT 8.0.2 installation including these two tables outside the PFT 8.0.2 data model and therefore their entries are missing in the <INFODOM>_database.xml and this leads to lot of issues as the atomic database is no longer in sync with the <INFODOM>_database.xml.  The following model upload errors are reported:

ERROR in OFSDOM_LOG_XXX files:

Adding Foreign Key for fk_fsi_lrm_instrument_93.sql
fk_fsi_lrm_instrument_93.sql---------Error while executing Update :Failed Executing Query. Reason: ORA-02275: such a referential constraint already exists in the table
Inside the Rollback Segment
Number of Exec Statements = 20
Executed dropfkey r_fk_fsi_lrm_instrument_94.sql successfully on the database
.............................................................
Executed addfkey r_fk_fsi_lrm_instrument_70.sql successfully on the database
----------------------------------------------
MODEL UPLOAD FAILED.
----------------------------------------------
Modelupload status..Altering the Model Failed.ERWINUPLOAD ERROR..Modelupload Failed

Changes

 New installation of PFT 8.0.2.

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