Specific to BI Publisher, this holds the Enterprise Scheduler Service (ESS) job definition. Managing Custom Reports in GL_FRC_REPORTS_B
By joining these two tables, developers and system administrators can retrieve a complete, human-readable snapshot of the report catalog.
Each type is distinguished by its REPORT_TYPE_CODE value, enabling targeted queries for specific report categories
As one Oracle Community user noted: "I would not trust the accuracy of the data in this table if you are looking for a report on the actual date times the report was created in the OTBI folders" glfrcreportsb
: Specialized reports for traditional financial statements like Balance Sheets or Income Statements. Key Table Columns
A critical nuance about GL_FRC_REPORTS_B is that it does populate immediately after you create a new report and catalog in the Custom folder.
: Ensure that each block of your identifier maps cleanly back to a parent system directory or category. Specific to BI Publisher, this holds the Enterprise
A summary of what the data means and suggested next steps. 🛠 Possible Interpretations
: Pixel-perfect reports typically used for official documents like invoices or checks.
: According to report writing guides , formal reports must include an executive summary and a detailed discussion, which these systems generate automatically. Key Components of a Standardized Report Key Table Columns A critical nuance about GL_FRC_REPORTS_B
Understanding GL_FRC_REPORTS_B in Oracle Fusion Cloud Financials
: The table stores a comprehensive list of all reports available in the BI catalog, including: BIP : BI Publisher reports. OTBI : Oracle Transactional Business Intelligence analysis. FR : Financial Reporting Studio reports.