Search Results certification_flag

Overview

APPS.GCS_FIN_STMTS_V is a database view within the Oracle E-Business Suite Financial Consolidation Hub (FCH) module, part of the broader Global Consolidation System (GCS) application. The view serves as a filtered access point to financial statement hierarchy definitions, exposing only those hierarchy records that have been formally certified. Its primary role is to present a controlled, certification-aware subset of hierarchy data for consumption by consolidation reporting, financial statement generation, and downstream integration processes.

The view is significant because it encapsulates a business rule directly in its definition: only hierarchies with a certification flag of 'Y' are returned. This means that any report, concurrent program, or external interface querying this view automatically observes the certification governance applied to consolidation hierarchies, without needing to re-implement that filter logic independently.

Underlying Base Objects

According to the documented metadata, GCS_FIN_STMTS_V is defined over a single base object: GCS_HIERARCHIES_B, the base table that stores consolidation hierarchy definitions. The view text is a straightforward projection with a predicate:

• SELECT hierarchy_id FROM gcs_hierarchies_b WHERE certification_flag = 'Y'

Notably, the view exposes only the HIERARCHY_ID column in its documented form. The ETRM metadata lists no other referenced base objects, confirming a simple, single-table definition. GCS_HIERARCHIES_B is the transactional (base) table in a typical EBS _B/_TL pair, holding the primary hierarchy attributes, while the certification_flag column on that table acts as the governance control that determines whether a hierarchy is eligible for financial statement use.

Key Columns

• HIERARCHY_ID — The sole documented column projected by the view. It is the unique identifier (primary key) of a consolidation hierarchy record in GCS_HIERARCHIES_B. This value is the join key used throughout FCH to associate hierarchies with their detail structures, assignments, and financial statement output.
• certification_flag (predicate column) — Although not projected in the SELECT list, this column from GCS_HIERARCHIES_B drives the view's filtering behavior. A value of 'Y' indicates the hierarchy has been certified and is therefore considered authoritative for financial statement purposes. Records with 'N' or null are excluded.

Common Use Cases and Queries

This view is most often used when an application or report must operate strictly on certified hierarchies. Typical scenarios include financial statement generation, consolidation roll-ups, and validation programs that should ignore uncertified or draft hierarchies.

A simple retrieval of all certified hierarchies:

• SELECT hierarchy_id FROM apps.gcs_fin_stmts_v;

Joining to the base table to obtain descriptive attributes for certified hierarchies only:

• SELECT h.hierarchy_id, h.name, h.certification_flag FROM apps.gcs_hierarchies_b h, apps.gcs_fin_stmts_v v WHERE h.hierarchy_id = v.hierarchy_id;

The view also functions effectively as an inline filter in larger consolidation queries, for example when restricting a join of hierarchy detail tables to certified parents. Because the view is defined with only the necessary predicate and a single projected key, it is lightweight and suitable for embedding in concurrent program logic, BI Publisher data models, and custom reports where certification governance must be enforced at the data-access layer.

In EBS 12.1.1 and 12.2.2 environments, the view behavior is consistent: it returns the set of hierarchy identifiers whose records are flagged as certified, providing a stable and reusable mechanism for certification-aware financial reporting.