Search Results fin_stmt

Overview

APPS.RCI_FS_CERT_V is a reporting view in the Oracle E-Business Suite Financial Services / Regulatory Compliance Intelligence (RCI) module. Its name derives from "FS CERT" — Financial Statement Certification. The view exposes certification records that have been created against financial statements, joining them to the general ledger period definitions and the Enterprise Performance Foundation (FII) time dimension tables. In Oracle EBS 12.1.1 and 12.2.2, this view is used primarily by the Financial Statement Certification workflow, where sign-off records, certification names, and the associated accounting periods are retrieved for display in forms, reports, and integration extracts.

The view is significant because it filters the certification base table strictly to records where OBJECT_TYPE = 'FIN_STMT', and it also enforces language-specific retrieval through USERENV('LANG'), making it session-dependent for translated certification names.

Underlying Base Objects

The view is defined over seven objects, all owned by the APPS schema:

• AMW_CERTIFICATION_B — the base certification table, storing certification identifiers, period name, period set name, and object type.
• AMW_CERTIFICATION_TL — the translation table holding the language-specific certification name.
• AMW_GL_PERIODS_V — a view over GL period definitions, supplying the end date against which the Julian date is derived.
• FII_TIME_DAY — the FII time day dimension, providing the Julian report date and the period, quarter, and year keys.
• FII_TIME_ENT_PERIOD, FII_TIME_ENT_QTR, FII_TIME_ENT_YEAR — the FII enterprise time dimensions supplying the human-readable period, quarter, and year names.

Joins are driven by the certification ID between the base and translation tables, by period name and period set name to the GL periods view, and by the Julian date and the three enterprise time IDs to link the FII dimensions. The ETRM metadata documents no additional base objects beyond those appearing in the view text.

Key Columns

• ID — the certification identifier (ACB.CERTIFICATION_ID), used as the lookup value.
• VALUE — the translated certification name (ACTL.CERTIFICATION_NAME), matching the user's language.
• PERIOD_NAME — the FII enterprise period name.
• QTR_NAME — the FII enterprise quarter name.
• YEAR_NAME — the FII enterprise year name.
• ENT_PERIOD_ID, ENT_QTR_ID, ENT_YEAR_ID — surrogate keys for the period, quarter, and year enterprise dimensions, typically used for downstream analytical joins.

Common Use Cases and Queries

A typical lookup lists certifications for a given period; because the view already filters to financial statement certifications, no additional object-type predicate is required:

• Populating a certification selection LOV in the Financial Statement Certification form.
• Driving regulatory or management reporting that must resolve certifications to their GL periods and FII time keys.
• Feeding downstream extracts where period, quarter, and year IDs are needed alongside the certification identifier.

A representative query follows:

SELECT id, value, period_name, qtr_name, year_name FROM apps.rci_fs_cert_v WHERE period_name = :p_period ORDER BY value;

Because the translation join depends on USERENV('LANG'), results reflect the language of the executing session; reports intended for multilingual audiences should either set the language explicitly or query the base translation table directly.