My Oracle Support Banner

FCCM 8.0.4: Data Model Upload Failed For FSDF Datamodel (Doc ID 2330608.1)

Last updated on JUNE 28, 2021

Applies to:

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


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 .


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.