RM: When Schedule Report Manager REPOSITORY_MAINTENANCE Repository Maintenance Program, FSG Reports Are Not Archived (Doc ID 1927126.1)

Last updated on OCTOBER 13, 2014

Applies to:

Oracle Report Manager - Version 12.1.2 and later
Information in this document applies to any platform.
REPOSITORY_MAINTENANCE module: Repository Maintenance Program

Symptoms

To archive older reports from the repository automatically after a month, the profile option "FRM: Set Auto Archive" is set to "1" at the site level and the concurrent program REPOSITORY_MAINTENANCE Repository Maintenance Program is scheduled to run every day.

The concurrent program runs fine with no errors, but when "view reports", the older periods (FEB-13, APR-13, MAY-13) still display in the list of values.

Repository maintenance from Repository Management archives the report fine.
If you run the maintenance process manually, the process does archive other reports.

The issue appears to be only when the REPOSITORY_MAINTENANCE program is scheduled.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms