Change Maximum Length For Column TRXN_TYPE1_CD, TRXN_TYPE2_CD, TRXN_TYPE3_CD, TRXN_TYPE4_CD in transaction table FOT and FOTP (Doc ID 2994537.1)

Last updated on DECEMBER 27, 2023

Applies to:

Goal

Change maximum length for column TRXN_TYPE1_CD, TRXN_TYPE2_CD, TRXN_TYPE3_CD, TRXN_TYPE4_CD to 100, presently it is 20
If change is don eonly in BDF.xml and not in DB then it will give below error

2023-11-21 09:58:54,140 [main] WARN : 20101FrontOfficeTransaction - Message 20101: Database column TRXN_TYPE3_CD does not match the maximum length in the DIS
2023-11-21 09:58:54,140 [main] WARN : 20101FrontOfficeTransaction - Message 20101: Database column TRXN_TYPE4_CD does not match the maximum length in the DIS
<<>>Need to increase the column length to same as that of BDF datamap in the DB as well. Once you do it this warning should go away.

Solution

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