Search Results amw_fin_item_acc_ctrl_n2

Overview

AMW.AMW_FIN_ITEM_ACC_CTRL is a transactional table in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the AMW schema. It holds financial item and account information related to Risk, functioning as the association layer that maps financial certification records to the underlying financial statement, item, account group, and natural account structures. The table also carries control and opinion references, allowing the compliance and risk framework to link certified financial data to specific internal controls and audit opinion logs.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are stored separately in APPS_TS_TX_IDX. The metadata heuristic for Data Vault classification identifies this object as standalone, meaning it does not exhibit the saturated foreign-key pattern of a pure hub, link, or satellite. As a modeling suggestion, it is best treated as a link-style association entity rather than a canonical Data Vault hub, because it joins multiple business entities (certification, statement, account, control, and opinion) while also carrying descriptive WHO columns.

Key Information Stored

The table contains 18 documented columns. The most operationally significant include:

• OBJECT_TYPE (VARCHAR2 30) — Classifies the row as ITEM, ACCOUNT, or STATEMENT, driving how downstream joins and reporting interpret the record. It is indexed by AMW_FIN_ITEM_ACC_CTRL_N1.
• FIN_CERTIFICATION_ID — The financial certification identifier for the process; indexed by AMW_FIN_ITEM_ACC_CTRL_N2.
• STATEMENT_GROUP_ID and FINANCIAL_STATEMENT_ID — Scope the certification to a statement group and financial statement respectively.
• FINANCIAL_ITEM_ID — The certified financial item; part of the composite index AMW_FIN_ITEM_ACC_CTRL_N9.
• ACCOUNT_GROUP_ID and NATURAL_ACCOUNT_ID — Account-level attribution, indexed together by AMW_FIN_ITEM_ACC_CTRL_N8.
• ORGANIZATION_ID — The operating unit or organization context; indexed by AMW_FIN_ITEM_ACC_CTRL_N3.
• CONTROL_ID and CONTROL_REV_ID — Link to the control and its revision; indexed by N6 and N7 respectively.
• OPINION_LOG_ID — The audit opinion log reference that connects this association to an opinion record; indexed by AMW_FIN_ITEM_ACC_CTRL_N5, which is the index most directly relevant to searches on this column.
• OBJECT_VERSION_NUMBER — Optimistic locking column used to prevent lost updates during concurrent edits.
• SECURITY_GROUP_ID — Applied in hosted environments to enforce data segregation.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.

No single documented unique index defines a surrogate primary key in the excerpt; the indexes are non-unique, so business-key candidates are composite combinations such as (FIN_CERTIFICATION_ID, OBJECT_TYPE) or (FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID).

Common Use Cases and Queries

Typical usage centers on reconciliation reporting and certification audit trails. A frequently used pattern retrieves all rows tied to a given opinion log:

• SELECT fin_certification_id, object_type, financial_item_id, control_id FROM amw.amw_fin_item_acc_ctrl WHERE opinion_log_id = :opinion_log_id;
• Join to AMW_CONTROLS_B via CONTROL_REV_ID to display control names alongside certified items.
• Filter by OBJECT_TYPE = 'ACCOUNT' to produce account-level certification extracts for the general ledger.
• Aggregate counts by ORGANIZATION_ID to monitor certification coverage across operating units.

Because OPINION_LOG_ID is indexed (AMW_FIN_ITEM_ACC_CTRL_N5), the first query performs efficiently even in large transaction volumes.

Related Objects

The documented foreign keys define the strongest relationships:

• AMW_CONTROLS_B — joined via CONTROL_REV_ID; supplies control descriptions and revision context.
• CST_REVENUE_COGS_CONTROL — joined via CONTROL_ID for revenue/COGS control linkage.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID in hosted deployments.
• Financial statement and item structures — referenced logically through FINANCIAL_STATEMENT_ID and FINANCIAL_ITEM_ID.
• Opinion log entity — referenced through OPINION_LOG_ID, the column that triggered the user's search.
• Financial certification process — anchored by FIN_CERTIFICATION_ID and STATEMENT_GROUP_ID.

These joins make AMW_FIN_ITEM_ACC_CTRL the connective tissue between Oracle's risk, control, and financial certification reporting.