Search Results financial_statement_id

Overview

The view GCS_FIN_STMT_DTLS_V belongs to the GCS – Financial Consolidation Hub product family within Oracle E-Business Suite. Its documented description is "Financial statement translatable information." The view is classified as obsolete in both Oracle EBS 12.1.1 and 12.2.2 documentation sets, and the ETRM metadata explicitly states "Not implemented in this database," indicating that the underlying object is not created in the delivered schema for the referenced release and should not be relied upon for new development or reporting work.

Conceptually, the view exposes translatable text attributes associated with financial statement hierarchies used in Financial Consolidation Hub. It represents the language-aware layer of a multilingual (TL) entity joined to its base (B) table, restricting output to hierarchies that have been certified. The view therefore reflects the standard Oracle EBS MLS pattern, where language-independent attributes reside in a base table and language-specific attributes reside in a translation table.

Underlying Base Objects

According to the documented view text, GCS_FIN_STMT_DTLS_V is defined over two GCS base tables:

• GCS_HIERARCHIES_TL – the translation table holding language-dependent columns such as hierarchy name and description, aliased as T.
• GCS_HIERARCHIES_B – the base table holding language-independent data, including the certification flag, aliased as B.

The two tables are joined on B.HIERARCHY_ID = T.HIERARCHY_ID, and the result set is filtered with B.CERTIFICATION_FLAG = 'Y'. The ETRM metadata for 12.2.2 lists no further referenced base objects, and the owner is not documented. No other GCS tables or external synonyms are part of the view definition.

Key Columns

The documented columns exposed by the view are:

• FINANCIAL_STATEMENT_ID – the identifier by which consumers locate a financial statement hierarchy. This is the column most commonly referenced in user searches. It corresponds to the hierarchy identifier selected in the view text (documented as HIERARCHY_ID in the underlying query) and represents the join key to related consolidation objects.
• NAME – the translatable name of the hierarchy, sourced from GCS_HIERARCHIES_TL.HIERARCHY_NAME.
• DESCRIPTION – the translatable long description of the hierarchy.
• LANGUAGE – the language code of the returned translated row.
• SOURCE_LANGUAGE – the source (base) language of the translation, used to identify the original text from which translations were derived.

Consumers should note the discrepancy between the documented select list (HIERARCHY_ID, HIERARCHY_NAME, DESCRIPTION, LANGUAGE, SOURCE_LANG) and the presented column names (FINANCIAL_STATEMENT_ID, NAME, DESCRIPTION, LANGUAGE, SOURCE_LANGUAGE), which reflects standard aliasing applied by the view.

Common Use Cases and Queries

Because the object is obsolete and not implemented in the documented database, it is typically encountered only in legacy Oracle Financial Consolidation Hub implementations, migration assessments, or historical documentation review. Analytical or integration queries historically associated with this view include retrieving certified hierarchy names in a specific language, and building language-joined extracts for consolidation reporting. A representative query is shown below; it should be treated as illustrative, since the view will not resolve in a standard 12.1.1 or 12.2.2 instance unless custom-created:

• SELECT financial_statement_id, name, description, language, source_language FROM gcs_fin_stmt_dtls_v WHERE language = 'US';
• SELECT fs.financial_statement_id, fs.name FROM gcs_fin_stmt_dtls_v fs WHERE fs.source_language <> fs.language;
• SELECT COUNT(*) FROM gcs_fin_stmt_dtls_v;

Customers maintaining such code should confirm object existence in their instance and plan to replace dependencies on this obsolete view with currently supported GCS or GL consolidation objects.