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).
|snp_scen||all currently available scenarios and their version|
|snp_scen_step||all steps of a scenario|
|snp_scen_task||all tasks of the scenarios, incl. code|
|snp_sb||all scenarios (even historic), with versions and snapshots|
|snp_sb_step||all scenarios steps|
|snp_sb_task||all scenarios tasks|
|snp_scen_report||all scenario executions|
|SNP_SESSION||all scenario or mapping executions, incl. duration, state, data volume, parent reference, errors, warnings and variables|
|SNP_SESS_TASK_LOG||runtime information on tasks|
|snp_param_sess||internal parameters for running sessions|
|SNP_LPI_RUN||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 .