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 JANUARY 24, 2020

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.3.190415 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 12.2.1.4.0, 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 12.2.1.3.190415 BP, and observe the same behavior is observed.

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!


In this Document
Symptoms
Cause
Solution
References


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