Search Results fin_certification_id

Overview

AMW_FIN_CERT_CTRL_SUM_V is a database view belonging to the AMW (Internal Controls Manager) product family in Oracle E-Business Suite. It is documented as obsolete in both the 12.1.1 and 12.2.2 releases. The view exists to expose the control-level summary information associated with a financial certification. Its documented purpose is to surface all control-related information captured within a financial certification by projecting the columns of the underlying summary table into a queryable, read-only form.

Functionally, the view presents a denormalised picture of a financial certification broken down by financial statement, financial item, account group, and natural account. For each such combination it carries an object type, a control attribute type, and a large set of repeating attribute triplets (CTRL_ATTR_CODE_n, INEFF_CTRL_ATTR_n, TOTAL_CTRL_ATTR_n), each capturing a control attribute code alongside the corresponding ineffective-control and total-control counts or values. Because it is a thin wrapper rather than a table, it holds no storage of its own and serves purely as a reporting and integration access point. It should be treated as a legacy or dormant object: the ETRM metadata explicitly notes that it is not implemented in the reference database, so it must not be assumed to exist in every EBS instance.

Underlying Base Objects

The view is defined over a single documented base object: AMW_FIN_CERT_CTRL_SUM. The view text shows a straight projection, with every column selected from alias A, which resolves to AMW_FIN_CERT_CTRL_SUM. There are no joins, filters, unions, or derived expressions documented. The view therefore inherits the row grain of the base table exactly: one row per combination of financial certification, financial statement, financial item, account group, natural account, object type, and control attribute type.

The ETRM metadata lists the owner as blank and the referenced base objects as none documented, which is consistent with a view whose definition is simply a SELECT over its namesake summary table. When the view is not present in an instance, the correct assumption is that the corresponding summary table and the AMW financial certification feature set were never deployed or were removed. Any custom reporting should first confirm object existence before relying on it.

Key Columns

• FIN_CERTIFICATION_ID — the primary identifier linking the row to a financial certification. This is the column most commonly used as the driving search key; it is the identifier users reference when they search for "fin_certification_id".
• FINANCIAL_STATEMENT_ID — identifies the financial statement within the certification to which the control summary applies.
• FINANCIAL_ITEM_ID — identifies the specific financial item or line being assessed.
• ACCOUNT_GROUP_ID and NATURAL_ACCOUNT_ID — the account grouping and natural account associated with the control summary, supporting account-level reporting.
• OBJECT_TYPE — classifies the type of object to which the control attributes relate.
• CTRL_ATTRIBUTE_TYPE — defines the control attribute category being summarised for the row.
• CTRL_ATTR_CODE_n / INEFF_CTRL_ATTR_n / TOTAL_CTRL_ATTR_n — a repeating triplet per attribute slot (n ranging across the documented set). CTRL_ATTR_CODE_n holds the attribute code, INEFF_CTRL_ATTR_n holds the ineffective control value, and TOTAL_CTRL_ATTR_n holds the total control value. Slots without data typically return NULL, so consumers must tolerate sparse rows.

Common Use Cases and Queries

Because the view is obsolete and not implemented in the reference database, its realistic uses are historical reporting, data migration verification, and troubleshooting legacy AMW certifications. A typical access pattern retrieves all control summary rows for a given certification:

• Certification lookup — SELECT * FROM AMW_FIN_CERT_CTRL_SUM_V WHERE FIN_CERTIFICATION_ID = :p_cert_id;
• Account-level review — SELECT FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, NATURAL_ACCOUNT_ID, CTRL_ATTR_CODE_1, INEFF_CTRL_ATTR_1, TOTAL_CTRL_ATTR_1 FROM AMW_FIN_CERT_CTRL_SUM_V WHERE FIN_CERTIFICATION_ID = :p_cert_id;
• Control attribute type analysis — SELECT CTRL_ATTRIBUTE_TYPE, OBJECT_TYPE, COUNT(*) FROM AMW_FIN_CERT_CTRL_SUM_V GROUP BY CTRL_ATTRIBUTE_TYPE, OBJECT_TYPE;

Before adopting this view in any integration, confirm that AMW_FIN_CERT_CTRL_SUM and AMW_FIN_CERT_CTRL_SUM_V both exist in the target instance, and treat the results as read-only. For current implementations, Oracle's supported certification and control reporting should be used in preference to this obsolete AMW object.