Ability to cast varchar columns in BICC as strings

Rajita Ganti

Hi team,

We are setting up an automation of data from Fusion via BICC to Another Database.

In the due process we have set up some offerings on the BICC end. Data types of some columns of below tables like

1.attribute23,ordernumber,transactionsourceamountcurr from cn_tp_transactions_app

2.lastupdatedby,transactionsourceamountcurr from cn_tp_participant_pay_all

3.trasctionsourceamtcurr,creditamtcalccurr,creditamtsourcecurr from cn_tp_credits_all

are getting intermittently changed. A lambda function is globally run to make the data types compatible to globus but these column types are changing intermittently . So we have to run the lambda function over the .manifest file from BICC every time and it is a time consuming process.

For this we have an existing functionality at BICC end to convert numeric characters to strings but we cannot cast the VARCHAR characters as strings.

Please include VARCHAR cast as strings in BICC.

Reference SR : SR 3-32464781021 : Output format for certain fields in BICC load is changing intermittently

Thanks,

Rajita