Model Upload Fails During Foreign Key Creation With ORA-00972: identifier is too long or ORA-00001 Errors (Doc ID 2159979.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

In OFSAAI, while uploading the data model upload for the PFT 802 PACK the model upload is failing with the bellow error message as per the the data model log:

ERROR

Adding Foreign Key for fk_t_common_account_summary_103.sql
fk_t_common_account_summary_103.sql---------Error while executing Update :Failed Executing Query. Reason: ORA-00972: identifier is too long
Inside the Rollback Segment
Number of Exec Statements = 1111
Executed dropfkey r_fk_fct_limits_summary_9.sql successfully on the database
Executed dropfkey r_fk__reg_cap_account_summary_23.sql successfully on the database
Executed dropfkey r_fk_fct_fund_cis_composition_7.sql successfully on the database

The following error message may also occur during object registration:

MODEL UPLOAD COMPLETED AT Wed Mar 08 12:01:51 CST 2017
----------------------------------------------
----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Wed Mar 08 12:01:51 CST 2017
----------------------------------------------
Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00001: unique constraint (OFSAA.PK_REV_TAB_REF_CONSTRAINTS) violated

Object Registration Failed.
Object Registration Failed.
java.lang.Exception: Error while Executing queries for Object Registration

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