DIH 8.1.x: Parameters In Extract Connector Derived Column Express
(Doc ID 2916442.1)
Last updated on DECEMBER 26, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.0.1.0 and laterInformation in this document applies to any platform.
Goal
Post upgrade from 803 to 81 we see that when parameters are used in extract connector derived column expressions are not working as expected.
For ex:
Connector:CAPA_CCD_SAPPTAUX_CTL
Derived Column : "File Name"
Derived column expression : 'xxxx_capa_proj_qrm_ccd_sapptaux_#DIH_DEV.MIS_DATE.csv'
Parameter passed in ICC batch-task : MIS_DATE=$MISDATE
When you run this connector in 803 :
Output:
xxxxx_capa_proj_qrm_ccd_sapptaux_20210430.csv
When you run the same connector with the same code in 81:
Output :
xxxxx_capa_proj_qrm_ccd_sapptaux_#{}.csv
Solution
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
Goal |
Solution |
References |