Search Results amw_fin_cert_scope




Overview
Explore in AI Chat

Overview

The AMW_FIN_CERT_SCOPE table resides in the AMW schema and belongs to the Internal Controls Manager (ICM) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. As its name implies, the table records the scope of a financial certification — that is, the specific financial structures (statements, statement groups, financial items, accounts, organizations, and processes) that fall within the boundary of a given certification exercise. ICM uses this scope definition to determine which balances, accounts, and organizational units must be reviewed, approved, and signed off by certifying officers during the financial close and attestation cycle.

From a modeling perspective, the metadata's heuristic Data Vault classification flags this object as standalone, meaning it does not behave as a classic hub, link, or satellite. It functions instead as a transactional scope/assignment table that binds certifications to their covered financial entities. It carries a foreign key to FND_SECURITY_GROUPS (via SECURITY_GROUP_ID), which reinforces its role as a secured, multi-tenant-aware definition table rather than a pure reference entity.

Key Information Stored

With 34 documented columns, the table captures both the identity of the certification and the multiple dimensions of the scope it covers. The most significant columns include:

Common Use Cases and Queries

Typical usage centers on determining what is covered by a certification, reporting on scope coverage, and enforcing access. A representative query to list the scope for a given certification is:

  • SELECT fin_cert_scope_id, financial_statement_id, financial_item_id, organization_id FROM amw_fin_cert_scope WHERE fin_certification_id = :cert_id;
  • Joining to FND_SECURITY_GROUPS on security_group_id to enforce row-level security in custom reports.
  • Aggregating scope rows by STATEMENT_GROUP_ID or ORGANIZATION_ID to produce coverage summaries for audit committees.

These patterns support certification dashboards, completeness checks (ensuring every required statement/item is scoped), and reconciliation between the declared scope and the balances being certified.

Related Objects

The most significant related objects, based on the documented FK relationship and the ICM data model, include:

  • FND_SECURITY_GROUPS — Joined on AMW_FIN_CERT_SCOPE.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID; governs security-group segmentation.
  • AMW_FIN_CERTIFICATIONS — The parent certification entity referenced by FIN_CERTIFICATION_ID.
  • AMW_FIN_STATEMENT_GROUPS and AMW_FIN_STATEMENTS — Define the statement structures referenced by STATEMENT_GROUP_ID and FINANCIAL_STATEMENT_ID.
  • AMW_FIN_ITEMS — Financial line items referenced by FINANCIAL_ITEM_ID.
  • AMW_PROCESSES and organization-related AMW tables — Referenced via PROCESS_ID and PROCESS_ORG_REV_ID.

Because the table is classified as standalone and only one explicit FK is documented, integrators should treat these relationships as logical joins keyed on the ID columns rather than enforced database constraints.