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 12.2.1.2.6 to 12.2.1.3.221018 [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.2.1
Information in this document applies to any platform.

Symptoms

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.

Changes

 

Cause

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.