ODI Upgrade to 12c for OBIApps

User_4JDFR

Hi Good Morning.

ODI Upgrade to 12c apply TO_CHAR(DATE) results in DD/MMM/YY instead of DD-MMM-YY

TO_CHAR(SQ_KK_ACTIVITY_LOG.KK_TRAN_DT)||'~'||


Problem Description (ODI/OBIapps) on premise for peoplesoft
---------------------------------------------------
When executing a Scenario in ODI 12.2.1.4 , the TO_CHAR(DATE). results in 'DD/MMM/YY' instead of 'DD-MMM-YY'
In 11g TO_CHAR(DATE) resulted in 'DD-MMM-YY'

In SDE_PSFT_92_ADAPTOR_SDE_PSFT_GLJOURNALSFACT_BUDGETARYCONTROL is an OBIA OOTB scenario

A specific example is Scenario SDE_PSFT_92_ADAPTOR_SDE_PSFT_GLJOURNALSFACT_BUDGETARYCONTROL 001
It creates the Integration_ID with / instead of -
'0006706988~1~18/APR/24~N~CC_EXP~CC_EXP_BUD~2024~1~0~~N' instead of '0006706988~1~18-APR-24~N~CC_EXP~CC_EXP_BUD~2024~1~0~~N'

Please advise if any workarounds or solutions.

Thanks,

Shiva

SteveF-Oracle

Duplicate?

https://community.oracle.com/products/oracleanalytics/discussion/22958/odi-12c-date-conversion-with-obiapps-ootb-mappings