My Oracle Support Banner

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 later
Information 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


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