This page explains the most common Oracle Data Integrator (ODI) Design Repository Metadata tables and views and how to use them (for debugging and SDK programming).
|all currently available scenarios and their version
|all steps of a scenario
|all tasks of the scenarios, incl. code
|all scenarios (even historic), with versions and snapshots
|all scenarios steps
|all scenarios tasks
|all scenario executions
|all scenario or mapping executions, incl. duration, state, data volume, parent reference, errors, warnings and variables
|runtime information on tasks
|internal parameters for running sessions
|Load Plan instance runs. Every time an attempt is made to re-start a load plan, data is captured here.
These tables are located in schema …_ODI_REPO.
The complete ODI 11g and 12c Repository structure is also available on MOS as DocID 1903225.1 .