Skip to main content
Solved

string literal does not match format string IFS Cloud DMM Tool

  • May 20, 2025
  • 1 reply
  • 61 views
R
Do Gooder (Partner)
Forum|alt.badge.img+2

Hi Community,

I am facing an issue when i am trying to transfer legacy data to input container with the date field. other date field mapping like valid_until and acquisition date are working just fine. The error i am getting is for the VALID_UNTIL column which has a value as 30.12.2049. the value for other column are also in the same format. The error is am getting is “Unable to start IC_ADD_AND_META_VALID - ORA20110: DatInputContainerUtil.EXEERR: Error while selecting data from legacy file(s). ORA01861: literal does not match format string”. Can anyone please explain me why this is happening.

I even checked the training video but there is not much information on handling date column when transferring data to input container.

I would Appreciate your input on solving this.

 

Tank you

Best answer by rshetty1

HI I was able to fix this mhy changing the date format from YYYY:MM:DD to DD:MM:YYYY on the legacy data page. and it works just fine.

1 reply

R
Do Gooder (Partner)
Forum|alt.badge.img+2
  • rshetty1
  • Author
  • Do Gooder (Partner)
  • 1 reply
  • Answer
  • May 20, 2025

HI I was able to fix this mhy changing the date format from YYYY:MM:DD to DD:MM:YYYY on the legacy data page. and it works just fine.


Terms & ConditionsCookie settingsAccessibility statement