My Oracle Support Banner

Wrong Date Format Passed in Parameter in ODI Console (Doc ID 2579310.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.2.1
Information in this document applies to any platform.


When attempting to run a scenario that uses a date variable in ODI Console, the below error occurs:


The issue can be reproduced at will with the following steps:
1. Create a package that uses a date variable and generate a scenario from it.
2. Run the scenario in ODI Studio.
3. Run the scenario in ODI Console.

There appears to be a difference in the date format passed to the variable in ODI Console and ODI Studio.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.