Usage tracking Stopped working after Jan 2016

Today morning when logged into OBIEE to verify the Usage of OBIEE by Users and suddenly noticed that Usage tracking reports are not showing correct data, when checked all the underline tables found that S_ETL_DAY table has data only till Jan 2^nd 2016

To get the complete Usage after Jan 2^nd 2016 we have update the table

SQL to Update the S_ETL_DAY Table with Data until 2020

Download updated_Oracle_nQ_Calendar SQL Script from Oracle support site Or Check the Oracle Doc ID 2073512.1

         1)    Down load the SQL Script

        2)    Login to Schema where Usage tracking tables are available

        3)    Truncate S_ETL_DAY Table

       4)    Execute the Script this will insert the data till 2020

   Note: If S_ETL_DAY table is not truncated before executing the script then the data will be duplicated and it might lead to report errors