Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

EPM-Date format not getting loaded correctly as a data in EPBCS using Data Management

Nikhil_Sondkar-OracleNov 6 2023 — edited Nov 22 2023

Hello Everyone,

We are trying to load date as a data using (multi column - All Data Type) import format in EPBCS application using csv file. But, When we save excel to csv date formats getting saved in 3 different date formats as shown in below screenshot.

Also, when loaded the file as it is, only DD-MM-YYYY format getting loaded correctly. so every time we need to correct the format in source file manually before loading.

Is there any way to make the date format to ‘DD-MM-YYYY’ for entire column in EPM Data Management script/mapping ?

Smart view retrieval after load:

Added on Nov 6 2023

#alldatatype, #data, #dataintegration, #datamanagement, #date, #dm, #epbcs, #epmintegration, #fdmee, #groovy

0 comments

565 views