FCCM 8.0.4: Data Model Upload Failed For FSDF Datamodel
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.
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 .
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