Search Results qtr_name

Overview

RCI_FS_CERT_V is a reporting view within the Oracle E-Business Suite AMW (Internal Controls Manager) module. It exposes the definition of the Financial Statement Certification dimension, a construct used by Internal Controls Manager to associate certification records with the accounting periods, quarters, and years to which they apply. Rather than storing a flat certification list, the view flattens the relationship between a certification definition, its descriptive name, and the Enterprise Calendar (FII time) hierarchy into a single result set suitable for reporting, list-of-values, and downstream integration.

The view is classified as Obsolete, and the ETRM metadata records that it is not implemented in this database. This means RCI_FS_CERT_V should be treated as a legacy or reference artifact of the 12.1.1 / 12.2.2 code line rather than an active, queryable object. Any documentation, migration, or interface work referencing it must first confirm whether the view physically exists in the target instance; in most modern 12.2.2 environments it will not.

Underlying Base Objects

The view is defined over seven documented base objects. Two belong to the AMW certification model, four belong to the FII time dimension, and one bridges AMW periods to the GL calendar:

• AMW_CERTIFICATION_B — certification definition base table; supplies CERTIFICATION_ID, OBJECT_TYPE, and the certification period name/set name.
• AMW_CERTIFICATION_TL — translation table for certification names; supplies the language-dependent VALUE.
• AMW_GL_PERIODS_V — GL period view used to resolve the certification period's END_DATE.
• FII_TIME_DAY — day-level Enterprise Calendar record; joined via the Julian report date.
• FII_TIME_ENT_PERIOD, FII_TIME_ENT_QTR, FII_TIME_ENT_YEAR — Enterprise Calendar period, quarter, and year levels supplying PERIOD_NAME, QTR_NAME (from FTEQ.NAME), and YEAR_NAME.

The joins chain the certification to the GL period, convert that period's end date to a Julian value, match it to FII_TIME_DAY.REPORT_DATE_JULIAN, and then traverse the time hierarchy foreign keys (ENT_PERIOD_ID, ENT_QTR_ID, ENT_YEAR_ID). Only records with OBJECT_TYPE = 'FIN_STMT' are returned, and translation rows are filtered to the session language via USERENV('LANG'). Note that the top-level metadata documents no additional referenced base objects beyond those appearing in the view text.

Key Columns

• ID — the certification identifier (ACB.CERTIFICATION_ID), the primary key for the dimension.
• VALUE — the language-translated certification name (ACTL.CERTIFICATION_NAME), used as the display label.
• PERIOD_NAME — the Enterprise Calendar accounting period name.
• QTR_NAME — the Enterprise Calendar quarter name (FTEQ.NAME); this is the column most frequently targeted by the search term "qtr_name".
• YEAR_NAME — the Enterprise Calendar fiscal year name.
• ENT_PERIOD_ID, ENT_QTR_ID, ENT_YEAR_ID — numeric foreign keys into the respective FII time entities, enabling hierarchical rollups without further name resolution.

Common Use Cases and Queries

Typical usage centers on period-, quarter-, and year-level certification reporting and on any integration that must map a certification to its Enterprise Calendar placement.

• Retrieve all financial statement certifications for a specific quarter.
• Build a period/quarter/year rollup of certifications for audit or SOX reporting.
• Populate a list of values with ID and VALUE for a certification selector.

Sample SQL:

SELECT ID, VALUE, PERIOD_NAME, QTR_NAME, YEAR_NAME
FROM   RCI_FS_CERT_V
WHERE  QTR_NAME = :quarter;

SELECT YEAR_NAME, QTR_NAME, COUNT(*) AS cert_count
FROM   RCI_FS_CERT_V
GROUP  BY YEAR_NAME, QTR_NAME
ORDER  BY YEAR_NAME, QTR_NAME;

Because the object is documented as obsolete and unimplemented, these statements are illustrative of intended behavior; execution depends on the view's presence in the specific 12.1.1 / 12.2.2 instance.