You execute a query against GL_FRC_REPORTS_B , but the result set is blank. Solution: Oracle does not populate this table instantly upon report creation. Reports are written to the GL_FRC_REPORTS_B table only when certain triggers occur. To force the table to update, navigate to the Financial Reporting Center (FRC) page. Simply accessing the FRC home page in the application triggers a background process that synchronizes the catalog metadata with the database tables, inserting the new records.
The complete location path of the report within the BI catalog. REPORT_TYPE_CODE Identifies the format (e.g., BIP_REPORT_JOB_DEFINITION glfrcreportsb
The table contains both "content dates" ( LAST_MODIFIED_DATE ) and "system transaction dates" ( LAST_UPDATE_DATE ). The LAST_MODIFIED_DATE reflects changes to the report within the BI catalog (e.g., the report design). The LAST_UPDATE_DATE reflects when the table row itself was last updated by a system process. These can differ. You execute a query against GL_FRC_REPORTS_B , but
package com.enterprise.finance.gl;
: Ensure that each block of your identifier maps cleanly back to a parent system directory or category. To force the table to update, navigate to
@Test void testGenerateReportB_FiltersZeroBalances() { // Arrange GLReportRepository mockRepo = Mockito.mock(GLReportRepository.class); GLFinancialReportService service = new GLFinancialReportService(mockRepo);