My Oracle Support Banner

History Variable Values Are Not Getting Stored (Doc ID 2219160.1)

Last updated on DECEMBER 05, 2023

Applies to:

Oracle Data Integrator - Version to Beta [Release 10gR3 to 12c]
Information in this document applies to any platform.


The history values of a variable with Action Historize or Latest value are not getting stored in the repository.
Due to this starting a scenario by picking up the latest value of the Variable feature is not working.

Reproduced the issue in 12c. Same issue is there in 10g and 11g as well.


For example:

1. Create a variable with DataType say alphanumeric and Action Historize.

2. Create a package with some step which uses a variable e.g PurgeLog and use the above variable for setting the Session_Name filter parameter.
3. Generate a scenario from the package and select the variable as startup parameter.
4. Create some sessions using say Beep tool.
5. Run the purge session log scenario by providing a value for the variable.


6. Run the purge session log again and this time do not pass the value explicitly. Instead use the Latest Value checkbox.It does not work.It purges all the sessions from the repository.
7. When you look at the variable editor in the History tab. It shows a record but there is no value for it.

NOTE: The example above represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.


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

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

In this Document

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