You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Disable Oracle Data Integrator Scenario Reporting

edited Dec 15, 2019 8:41PM in Idea Lab – Integration Cloud

Description

Oracle Data Integrator (12c or later)

Currently Oracle Data Integrator creates a scenario execution report for every scenario it runs. There is no way to disable that.

Passing time table SNP_SCEN_REPORT and SNP_STEP_REPORT will be populated with lots of rows. Purging data is a way to clean up that put I noticed that in some situations the Purge is not cleaning the tables (even when instructed to do so).

There is another workaround which involves disabling a FK and then cleaning the tables which I believe is quite dangerous when talking about ODI Repository.

Also, if we instruct a Load Plan to Never save Sessions (clean the sessions after finished) it looks like the scenario report remains there.

Tagged:
1
Up Down
1 votes

Submitted · Last Updated

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!