My Oracle Support Banner

ODI Scenarios are Missing from Work Repository Export of "Execution" type (Doc ID 2288592.1)

Last updated on OCTOBER 30, 2020

Applies to:

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


In ODI 12c, even though <Patch 25518681> has been installed, scenarios which were imported from a Development (DEV) type Work Repository (WR) into an Execution type WR are excluded from the Work Repository export of the Execution WR. The WR export only contains scenarios which were duplicated or created in the execution repository.

To reproduce:

  1. In DEV type environment, create a mapping and generate scenario
    ie:"TEST" and "TEST Version 001"
  2. Smart export the scenario "TEST Version 001"
  3. Smart import the scenario into execution type of WR
  4. Make sure that the scenario appears on the Operator tab under the Load Plans and Scenarios section
  5. Duplicate the scenario
  6. Export the WR
  7. Examine the export file. It only contains scenarios that were duplicated in the execution WR




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.