[123] Error in Upload Operation and 'The foreign key has no base columns' Errors During OFSAA Data Model Upload

(Doc ID 1454875.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.3 version, when attempting to perform data model upload from Client for ALM_Datamodel.xml the following error occurs:

ERROR
[Tue 01/5/2012 07:29:57] [OFSALM] [ INFO] - Model upload status message : [123] Error in Upload Operation
[Tue 01/5/2012 07:29:57] [OFSALM] [ INFO] - Model upload log : /tusers/pstrain03/ftpshare/INFODOM/logs/INFODOM_LOG_1_05.01.2012-07.29.08.log
[Tue 01/5/2012 07:29:57] [OFSALM] [ERROR] - Error in Model upload. So aborting installation

The following errors can also be found in the model upload log:

Creating Script for table FSI_ACCRUAL_BASIS_MLS

The foreign key has no base columns
Create table statement is :()*alter table fsi_accrual_basis_mls add constraint FK_fsi_accrual_basis_mls_1 FOREIGN KEY ----------------------------------------------

...

----------------------------------------------
MODEL UPLOAD FAILED.
----------------------------------------------
DELETING THE DATABASE MODEL
Did not go into the rename block

Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Installed 7.3 from edelivery part number ,download V31370-01.zip
2. Performed model upload ALM_Datamodel.xls 6.0 from the client interface.
3. Received error both on client and model upload log.

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