Tracking Custom Reports and Detecting Folder Changes with GL_FRC_REPORTS_B and GL_FRC_REPORTS_TL
In Oracle Fusion Cloud Applicaitons, managing and auditing your custom BI Publisher reports is critical for maintaining report integrity and user access. Two key tables, GL_FRC_REPORTS_Band GL_FRC_REPORTS_TL, provide valuable metadata about your reports, including report names, descriptions, folder locations, and language information. Leveraging these tables can help you identify custom-developed reports and detect if reports or folders have been inadvertently moved.
Understanding the Tables
GL_FRC_REPORTS_Bstores business-level details about reports, including type codes, folder names, and physical report paths.GL_FRC_REPORTS_TLstores the translation layer details such as the display name and descriptive text for reports in multiple languages.
Together, they form a comprehensive view of your report catalog.
Sample SQL to Identify Custom Reports
The following SQL example queries these tables to list all custom reports located under the /shared/Custom/ folder and retrieves their display names and folder paths:
SELECT ROW_NUMBER() OVER(ORDER BY 1 ASC) AS report_sequence,
gfrb.report_type_code,
gfrt.report_display_name,
gfrt.report_description,
gfrb.report_folder,
gfrb.report_path
FROM gl_frc_reports_b gfrb,
gl_frc_reports_tl gfrt
WHERE gfrb.report_folder LIKE '/shared/Custom/%'
AND gfrb.report_id = gfrt.report_id
AND gfrt.language = USERENV('LANG')
AND gfrt.source_lang = USERENV('LANG')
ORDER BY gfrb.report_type_code ASC,
gfrb.report_path ASC;
This query helps you identify:
Which reports have been custom-developed.
Where exactly these reports reside in your BI Publisher folder structure.
Detecting Accidental Moves or Folder Changes
By regularly running such queries and comparing results with previous output snapshots, you can:
Detect if any report or entire report folders have been accidentally relocated.
Maintain control over your report ecosystem and ensure that users can reliably find and run intended reports.
Flag unexpected changes early for corrective action.
Why This Matters
Report Management: Knowing your custom reports and their locations helps in version control and governance.
User Support: Preventing misplaced reports reduces user confusion and support overhead.
Audit Readiness: Easy traceability of report metadata supports compliance and audit requirements.
Summary
Leveraging the metadata in GL_FRC_REPORTS_B and GL_FRC_REPORTS_TL tables offers a straightforward method to monitor your custom BI Publisher reports and their folder structure. Incorporate this into your regular maintenance tasks to keep your Oracle Fusion Cloud Applications reporting environment organised and reliable.
Need some assistance?
Ready to bring clarity to customer, supplier and employee communications? With BI Publisher, we specialise in customising customer, supplier, and employee-facing documents such as invoices, purchase orders, payslips, and statements to meet your exact branding, compliance, and operational needs. From layout design to data logic enhancements, we help you deliver clear, consistent, and impactful outputs across your organization. Contact us today to discover how our expertise in BI Publisher can streamline your document processes and elevate your business communications.
