How To Increase Rule Log Data Purge Time

(Doc ID 1404816.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Adaptive Access Manager - Version 10.1.4.5 to 10.1.4.5.0 [Release 10g]
Information in this document applies to any platform.

Goal

Requirement :
OAAM has weekly maintenance job that runs every week through
The Scripts that it executes are as below
Add_Weekly_Partition_tables.sql
drop_weekly_Partition_tables.sql
exec_sp_purge_rule_log.sql
exec_sp_purge_workflow_data.sql

Requirement is that the rule log shouldn't be purged for at least next 2 months so that Admin can view the rule log from the OARM admin console for their risk analysis.

exec_sp_purge_rule_log.sql defines p_days1 = 30.

Questions:

1) Will just increasing the <p_days1> parameter value to 90 will make sure that the rule logs are not purged or are there any other parameters that also needs to be changed.

Solution

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