FCCM 8.0.4: Data Model Upload Failed For FSDF Datamodel

(Doc ID 2330608.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Information in this document applies to any platform.

Goal

Here the Data Model Upload failed mentioning
stg_party_party_relationship.sql stating ----- Error while executing Update: Failed Executing Query. Reason : ORA - 01451 : column to be modified to NULL cannot be modified to NULL . Inside the Rollback Segment .

When check the scripts inside the folder ftpshare/FCCMINFO/erwin/scripts/table/altercolumn it is found that the for many of the stg tables it is providing the values lilke this .Basically it is providing a wrong Syntax.

alter table stg_txn_conduction_master add (V_TXN_CNDTR_TYPE_CD VARCHAR2(1 CHAR) DEFAUL NULL Null)

This is there in many of the scripts where the extra Null is coming . this files are generated at runtime and many of the files are like this.
Due to this , the Data model upload is failing .

Solution

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