Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ODI 12c Date Conversion with OBIApps OOTB Mappings
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.
Best Answer
-
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.0
Answers
-
SR 3-36502267721 : ODI Upgrade to 12c apply TO_CHAR(DATE) results in DD/MMM/YY instead of DD-MMM-YY
Oracle SR Details
0 -
Hi ,
Thanks for the feedback.
Regards,
Shiva
0