Reporting - EBS (MOSC)

MOSC Banner

Report Manager Repository Maintenance-Archived Reports Removed?

edited Jul 4, 2019 9:28AM in Reporting - EBS (MOSC) 4 commentsAnswered

I want to purge the Oracle Report Manager Repository of old reports. When I run the query below, there are a large number of reports that have the 'ARCHIVED_FLAG' = Y and the END_DATE in the past. So, if I run the ORM Repository Maintenance program, will these reports be completely removed from the repository to free up space?  I need to understand how to automatically purge reports from the repository.

Thank you,

Nancy

Here is the query I used:

SELECT RLOB.FILE_ID,

    DOC.USER_NAME "DOC_NAME",

    doc2.directory_id,

    RLOB.CREATION_DATE,

    DBMS_LOB.GetLength("FILE_DATA")/1024 AS FILE_DATA_KB,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center