ORA-12899: value too large for column "atomic"."OFSA_M_OBJECT_DEFINITION_TL"."LONG_DESC" Error Running OFSA 4.5 to OFSAA 6.0 migratePFTrules Procedure (Doc ID 1567568.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 to 7.3 [Release 7]
Oracle Financial Data Manager - Version 4.5.39 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) - Version 6.0
Oracle Financial Services Applications (OFSA) - Version 4.5

Symptoms

When attempting to migrate from PFT rules from OFSA 4.5 to OFSAAI 7.3/6.0 by running the migratePFTrule procedure, the following error occurs:

ERROR

The Procedure FSI_SOURCE_TO_STAGING.migrate_PFTRule_tables has successfully executed till the checkpoint :7

ERROR while Inserting into FSI_M_OBJECT_DEFINITION_B

The Procedure FSI_SOURCE_TO_STAGING.migrate_PFTRule_tables has failed in the checkpoint Block :7

Please check the code below checkpoint: 7 for error

The query that is being executed:

INSERT INTO OFSA_M_OBJECT_DEFINITION_TL
  (OBJECT_DEFINITION_ID,
   SHORT_DESC,
   LONG_DESC,
   LANG_CD,
   CREATED_BY,
   '|| ' CREATION_DATE,
   MODIFIED_BY,
   LAST_MODIFIED_DATE) '||
'
  SELECT '|| v_max_num_up || ',
         RTRIM(SHORT_DESC) ' || ' || ' || ''' _ ''' || ' || ' ||
' TO_CHAR(' ||v_seq_num || ') ' || ',
         RTRIM(LONG_DESC) '|| ' || ' || ''' _ ''' ||' || ' ||
' TO_CHAR(' || v_seq_num || ') ' ||',
         ' || ' LANG_CD,
         CREATED_BY,
         CREATION_DATE,
         MODIFIED_BY,
         LAST_MODIFIED_DATE
    FROM FSI_M_OBJECT_DEFINITION_TL '|| '
   WHERE OBJECT_DEFINITION_ID = ' || i.ALLOCATION_SYS_ID;

The issue can be reproduced at will with the following steps:

1. Run the 4.5 to 6.0 upgrade kit

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