My Oracle Support Banner

[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 JANUARY 05, 2018

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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.