ODI 12c Date Conversion with OBIApps OOTB Mappings

User_4JDFR

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.

SteveF-Oracle

If you already have a service request open, then it is best to continue working with Support.

This question is more specific to Data Integration (ODI), than it is with OBIEE/OAS OBIA

You may want to ask in a more applicable community.

https://community.oracle.com/customerconnect/categories/oci-data-integration?utm_source=community-search&utm_medium=organic-search&utm_term=data+integration

User_4JDFR

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

Oracle SR Details

User_4JDFR

Hi ,

Thanks for the feedback.

Regards,

Shiva