My Oracle Support Banner

ODI 12c Package Executed in Simulation Mode does not Show the Code of its Procedure Steps (Doc ID 2626940.1)

Last updated on MAY 28, 2021

Applies to:

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


In Oracle Data Integrator (ODI) and later, when executing a Package in simulation mode, the code of Procedure steps it contains is not generated.

Also, when executing in simulation mode the Procedure itself, its code is shown, as expected.

The issue can be reproduced at will with the following steps:

  1. Create a Procedure in ODI, and Implement the following code:

    select '<%=odiRef.getSession ("SESS_GUID" )%>' from dual
  2. Run the Procedure in simulation mode, and observe the Session GUID is shown, as expected.
  3. Create a Package, and drag & drop the above Procedure to one of Package steps.
  4. Run the Package in simulation mode, and observe that there is no code whatsoever shown for the Procedure step.
    It should have shown the Session GUID, exactly as it does at step #2 above.
  5. Implement the same in ODI BP, and observe the same behavior is observed.


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.