My Oracle Support Banner

ODI Studio Operator: All ODI Load Plan Executions Are Shown for Each of the Users, Regardless of Which User Executed the Load Plan (Doc ID 2903430.1)

Last updated on MAY 23, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 2.1.0 and later
Data Integration Platform Cloud Classic - Version 17.3.5 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.


The following issue is observed in Oracle Data integrator (ODI) 12c Studio > Operator UI,  when attempting to consult the Load Plans executed by an user:

The behavior can be replicated at will using the following steps:

  1. Start the ODI Agent.
  2. Start ODI Studio, and connect as SUPERVISOR (or another user, having supervisor role).
  3. In ODI Studio > Security, create two non-supervisor users:   User1, and User2.

    Grant CONNECT and DESIGNER profiles to both the users.
  4. Create two Load Plans:   LP_User1, and LP_User2.
  5. Disconnect from ODI Studio, and connect as user User1.

    Execute the Load Plan "LP_User1", once.
  6. Disconnect from ODI Studio, and connect as user User2

    Execute the Load Plan "LP_User2", twice.
  7. Connected to ODI Studio as any user (SUPERVISOR, User1 or User2)

    Navigate to the Operator view > Load Plan Executions.

    Expand the "User" tree-view.

    Observe there are actually 2 entries, showing a number of executions right to the user name:

       User1 - 1
       User2 - 2

    This is correct.
  8. Expand the view for any of the users, and observe that all the LP executions show for each of them:

       User1:  Shows 3 LP executions: one that belongs to himself and should be shown... but also the 2 executions of User2.
       User2:  Shows 3 LP executions: two that belong to himself and should be shown... but also one execution of User1

    This is incorrect.
  9. Edit the execution of -- for example -- Load Plan "LP_User1", and observe that the "Started By" shows the correct user.

    This is correct.




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.