Purging Report Definition Output

Oracle recommends that you periodically purge report definition output. The Job Master Deletion By Days Old report (R9861101) includes processing options that enable you to specify whether to delete UBE records, report definition records, or both UBE and report definition records. Running the UBE in Proof Mode generates a report that shows the records that will be deleted if you run the UBE in Final Mode. Running the UBE in Final Mode deletes the selected records.

This table shows the output that will be purged for UBE and Report Definition records that are selected for deletion.

Record Type	Output Deleted
UBE records	Job Record, UBE Logs, UBE XML Data Output
Report Definition records	RD Job Record, RD Output, RD Delivery details