Search Results amw_fin_item_acc_ctrl

Overview

AMW_FIN_ITEM_ACC_CTRL is a table owned by the AMW schema within Oracle E-Business Suite, belonging to the Internal Controls Manager (ICM) product family. The object description states that it "holds financial item and account information related to Risk," indicating that it functions as a mapping or association store linking financial statement line items, natural accounts, and organizational units to the controls and risk records defined elsewhere in the ICM data model. In Oracle EBS 12.1.1 and 12.2.2, this table supports the certification and sign-off workflow for financial statements, providing the granular linkage between a control definition and the specific accounts or financial items it governs.

A heuristic Data Vault classification mined from the foreign key structure suggests this object behaves as a link table. This is a modeling suggestion rather than a documented fact: the table carries multiple foreign keys pointing to independent parent entities (controls, revenue/COGS controls, and security groups), which is the characteristic pattern of an associative link recording relationships between business keys rather than a pure descriptive satellite.

Key Information Stored

The documented physical schema for 12.1.1 lists 18 columns. The most significant columns for functional understanding and querying are:

• FIN_CERTIFICATION_ID – Identifier tying the row to a financial certification record.
• FINANCIAL_STATEMENT_ID and FINANCIAL_ITEM_ID – Identify the financial statement and the specific line item within it.
• STATEMENT_GROUP_ID and ACCOUNT_GROUP_ID – Group the item or accounts into logical reporting sets.
• NATURAL_ACCOUNT_ID – References the natural account segment, linking ICM controls to the chart of accounts.
• ORGANIZATION_ID – Scopes the record to an operating unit or organization.
• CONTROL_ID – Foreign key to CST_REVENUE_COGS_CONTROL, tying the item to a revenue/COGS control.
• CONTROL_REV_ID – Foreign key to AMW_CONTROLS_B, the base controls table.
• OPINION_LOG_ID – Links to an opinion or conclusion log entry.
• OBJECT_TYPE – Discriminator describing the type of financial object referenced.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, enforcing row-level access control.

The table includes standard EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER, the last supporting optimistic locking. The metadata does not document an explicit single-column surrogate primary key or unique index; the identifying business key is effectively the combination of the certification, statement, item, and control references. No documented surrogate key column is present in the listed columns.

Common Use Cases and Queries

Typical scenarios involve reporting which controls apply to which financial items or accounts, and validating certification coverage. A representative join pattern links this table to the base controls table and to the security groups:

• Joining AMW_FIN_ITEM_ACC_CTRL.CONTROL_REV_ID to AMW_CONTROLS_B to retrieve control names and descriptions for a given certification.
• Joining CONTROL_ID to CST_REVENUE_COGS_CONTROL to reconcile revenue and COGS control assignments.
• Filtering by NATURAL_ACCOUNT_ID or ORGANIZATION_ID to produce account-level control coverage reports.
• Joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS to respect data access for the querying responsibility.

A practical query selects certification, financial item, and control details while restricting rows by the current security group, ordered by FINANCIAL_STATEMENT_ID and FINANCIAL_ITEM_ID.

Related Objects

• AMW_CONTROLS_B – Referenced via CONTROL_REV_ID; the primary control definition table.
• CST_REVENUE_COGS_CONTROL – Referenced via CONTROL_ID; revenue/COGS control source.
• FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID; governs row-level security.
• Financial statement and item tables – Implied by FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, and STATEMENT_GROUP_ID.
• Account group and natural account references – Implied by ACCOUNT_GROUP_ID and NATURAL_ACCOUNT_ID.
• Opinion log – Implied by OPINION_LOG_ID, recording conclusions associated with the item.

These relationships position AMW_FIN_ITEM_ACC_CTRL as a central associative object within the Internal Controls Manager certification and risk-assessment model.