Demantra Solutions - EBS (MOSC)

MOSC Banner

Can clean_log_tables be used for weekly bucket system

edited Jan 18, 2018 4:00AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

Clean_log_tables is used to clean log tables like audit_trail and audit_values. The code seems to be only used for monthly bucket system. The example code is as follows:

vd_start_time := DBMS_UTILITY.get_time;

   get_param('sys_params','audit_history_length',vi_months_to_keep);

   vs_msg := 'is_method => '|| NVL( is_method ,'NULL') ||', audit_history_length => '|| NVL(TO_CHAR( vi_months_to_keep ),'NULL');
   DBEX(vs_msg, vs_proc, 'C');


   IF vi_months_to_keep > 0 THEN

      vi_months_to_keep := -1 * TO_NUMBER (TRIM( vi_months_to_keep ));
      vd_end_date       := add_months (CAST(SYSTIMESTAMP AS DATE), vi_months_to_keep);

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center