Search Results gcs_fin_stmts_v

Overview

GCS_FIN_STMTS_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the GCS – Financial Consolidation Hub product. Its documented purpose is to expose financial statement information used by the Financial Consolidation Hub module during the consolidation, certification, and reporting cycle. In EBS 12.1.1 and 12.2.2 the object is listed with a status of VALID and is classified as a VIEW, meaning it stores no data of its own and is resolved at runtime from its underlying definition. The view functions as a filtered access layer: rather than presenting the full hierarchy definition, it restricts the result set to hierarchies whose certification flag indicates that the financial statement has been certified. Applications, concurrent programs, and custom reports that require only certified financial statement hierarchies can therefore query this view instead of applying the certification predicate themselves, ensuring consistent behavior across the Financial Consolidation Hub reporting and integration surfaces.

Underlying Base Objects

The documented view text defines GCS_FIN_STMTS_V over a single base object, GCS_HIERARCHIES_B, which is the base table holding hierarchy definitions in the Financial Consolidation Hub schema. The view definition is:

SELECT HIERARCHY_ID FROM GCS_HIERARCHIES_B WHERE CERTIFICATION_FLAG = 'Y'

Because the view is defined with a restrictive WHERE clause rather than a join, it inherits column availability only from the projected expression. Only rows in GCS_HIERARCHIES_B carrying a CERTIFICATION_FLAG value of 'Y' qualify for inclusion. No additional base objects, joins, or synonyms beyond this single table are documented in the ETRM metadata. This narrow projection is significant: the view is not a general-purpose hierarchy listing but a certification-aware filter over the hierarchy base table.

Key Columns

ETRM documents the column FINANCIAL_STATEMENT_ID for this object. In practice the view text projects HIERARCHY_ID from GCS_HIERARCHIES_B, so the visible column carries the hierarchy identifier that corresponds to a certified financial statement. Users should be aware of this naming distinction: the documented column label references the financial statement concept, while the projected expression is the hierarchy key. The CERTIFICATION_FLAG column used in the predicate is consumed internally by the view and is not itself exposed in the projected column list. Consequently, consumers of the view receive a compact result set of certified hierarchy identifiers suitable for joining back to GCS_HIERARCHIES_B, GCS_HIERARCHIES_TL, or related consolidation tables to retrieve descriptive attributes such as hierarchy name and description.

Common Use Cases and Queries

The primary use case is identifying the set of certified financial statement hierarchies for consolidation reporting, validation routines, and downstream integration extracts. A typical query joins the view back to the hierarchy base and translation tables to obtain names:

• List certified hierarchies: SELECT HIERARCHY_ID FROM APPS.GCS_FIN_STMTS_V;
• Join to base table for attributes: SELECT h.hierarchy_id, h.certification_flag FROM ap6s.gcs_hierarchies_b h, apps.gcs_fin_stmts_v v WHERE h.hierarchy_id = v.hierarchy_id;
• Resolve names: SELECT v.hierarchy_id, t.hierarchy_name FROM apps.gcs_fin_stmts_v v, apps.gcs_hierarchies_tl t WHERE v.hierarchy_id = t.hierarchy_id AND t.language = USERENV('LANG');

Because the view encapsulates the certification predicate, it is also appropriate for data extraction and interface programs that must reconcile only certified statements, reducing the risk of processing uncertified hierarchies in consolidation output.