The GL_FRC_REPORTS_B table is a system table that stores metadata about every report created or stored within the Oracle Financial Reporting Center. This includes native Financial Reporting Studio reports, Oracle Transactional Business Intelligence (OTBI) analyses, and custom BI Publisher reports. It is effectively the master index of your cloud reporting environment.
package com.enterprise.finance.gl;
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; glfrcreportsb
cfg = yaml.safe_load(open('config.yaml')) engine = create_engine(f"postgresql://cfg['db']['user']:cfg['db']['password']@cfg['db']['host']:cfg['db']['port']/cfg['db']['name']")
is a critical technical asset for managing the financial reporting landscape in Oracle Fusion Cloud. By understanding its structure—specifically its role in storing report paths and types—organizations can better manage, audit, and optimize their reporting suite. The GL_FRC_REPORTS_B table is a system table that
Do you need to construct a precise linking this table to user access profiles?
The directory path in the catalog where the report is stored. package com
10+ Best Free Blogging Sites in 2026 (Create a Blog for Free) - Themeisle