Skip to main content
Solved

string literal does not match format string IFS Cloud DMM Tool

  • May 20, 2025
  • 1 reply
  • 35 views

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.

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings