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:

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

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