SOX Audit Report : Oracle EBS Financial Statement Generator (FSG) Report Details

Oracle EBS Financial Statement Generator (FSG) Report Details for SOX Audit

You may want to be able to audit FSG Report Details.

If you want to query information related to FSG reports

Query:

SELECT DISTINCT r.NAME "REPORT_NAME"
      , r.report_title
      , r.description
      , (SELECT fu.user_name
              FROM fnd_user fu
             WHERE fu.user_id = (r.created_by)) created_by
      , r.creation_date
      , (SELECT fu.user_name
              FROM fnd_user fu
             WHERE fu.user_id = (r.last_updated_by)) last_updated_by
      , r.last_update_date
FROM rg_reports_v r, fnd_id_flex_structures_v fst, fnd_user u, rg_report_axis_sets_v rw, rg_report_axis_sets_v rw2
 WHERE r.structure_id = fst.id_flex_num
   AND r.row_set_id = rw.axis_set_id
   AND r.column_set_id = rw2.axis_set_id
   AND r.created_by = u.user_id
   --AND r.NAME IN ('FSG Report Name')   -- Enter FSG Report Name Here
   AND r.last_update_date >= TO_DATE ('01-JUN-2016 00:00:00', 'DD-MON-YYYY HH24:MI:SS')
   AND r.last_update_date <= TO_DATE ('30-JUN-2016 23:59:59', 'DD-MON-YYYY HH24:MI:SS') 
ORDER BY 1, 2;

This query will give the output with FSG Report details for the period of 01-JUN-2016 to 30-JUN-2016.