Search Results amw_fin_cert_scope_n6

Overview

AMW_FIN_CERT_SCOPE is a transactional table in the AMW schema that holds the scope definition for financial certification within the Oracle E-Business Suite environment. It defines which financial statements, financial items, account groups, and natural accounts fall under a given financial certification, and ties that scope to specific organizations, processes, and revision numbers. The table resides in the APPS_TS_TX_DATA tablespace and is fully registered with FND Design Data as AMW.AMW_FIN_CERT_SCOPE, confirming it as a supported, VALID object in both the 12.1.1 and 12.2.2 releases.

From a modeling perspective, heuristic Data Vault classification identifies this object as standalone. This is a suggestion rather than a definitive design: the table has no outgoing foreign keys to other AMW transactional tables in the documented dependency data, apart from a reference from SECURITY_GROUP_ID to FND_SECURITY_GROUPS. It is therefore best treated as a self-contained scope or bridge record rather than a strict hub, link, or satellite.

Key Information Stored

The table contains 34 documented columns. The most significant are:

• FIN_CERT_SCOPE_ID — the numeric scope identifier and surrogate primary key. This column is the single documented unique business-key candidate, enforced by the unique index AMW_FIN_CERT_SCOPE_U1.
• FIN_CERTIFICATION_ID — identifies the parent financial certification to which the scope row belongs.
• STATEMENT_GROUP_ID — the statement group context for the scope entry.
• FINANCIAL_STATEMENT_ID and FINANCIAL_ITEM_ID — define the financial statement and line item included in the certification scope; these are jointly indexed by AMW_FIN_CERT_SCOPE_N6.
• ACCOUNT_GROUP_ID and NATURAL_ACCOUNT_ID — the accounting range included in scope; indexed by AMW_FIN_CERT_SCOPE_N5.
• ORGANIZATION_ID — the operating unit or organization covered, indexed by AMW_FIN_CERT_SCOPE_N2.
• PROCESS_ID, REVISION_NUMBER, and PROCESS_ORG_REV_ID — process and revision context, indexed by AMW_FIN_CERT_SCOPE_N3 and AMW_FIN_CERT_SCOPE_N4 respectively.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS to enforce row-level access control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER — standard WHO and concurrency columns managed automatically by the EBS framework.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments available for customer-specific scope extensions.

Common Use Cases and Queries

Typical scenarios include verifying which accounts and statements are in scope for a certification, generating audit evidence of scope definition, and joining scope rows to certification, organization, and financial statement reference data for reporting.

Sample query patterns:

• List all scope rows for a certification: SELECT * FROM AMW.AMW_FIN_CERT_SCOPE WHERE FIN_CERTIFICATION_ID = :cert_id;
• Retrieve scope by organization: SELECT FIN_CERT_SCOPE_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID FROM AMW.AMW_FIN_CERT_SCOPE WHERE ORGANIZATION_ID = :org_id;
• Filter by process and revision: SELECT * FROM AMW.AMW_FIN_CERT_SCOPE WHERE PROCESS_ID = :proc AND REVISION_NUMBER = :rev;
• Join to FND_SECURITY_GROUPS to validate access restrictions for a reporting user.

The available indexes support these access paths efficiently: unique lookups by FIN_CERT_SCOPE_ID, and nonunique access by certification, organization, process/revision, process-org-revision, account grouping, and statement/item combinations.

Related Objects

The documented foreign key (SECURITY_GROUP_ID to FND_SECURITY_GROUPS) and the indexed reference columns imply the following significant related objects:

• FND_SECURITY_GROUPS — direct FK target used for row-level security.
• AMW_FIN_CERTIFICATION — parent certification referenced by FIN_CERTIFICATION_ID.
• AMW_FINANCIAL_STATEMENTS — referenced by FINANCIAL_STATEMENT_ID.
• AMW_FINANCIAL_ITEMS — referenced by FINANCIAL_ITEM_ID.
• AMW_ACCOUNT_GROUPS — referenced by ACCOUNT_GROUP_ID.
• HR_ALL_ORGANIZATION_UNITS / ORG_ORGANIZATION_DEFINITIONS — resolve ORGANIZATION_ID to a named operating unit.
• FND_FLEX_VALUES_VL — used to resolve ATTRIBUTE flexfield segments when populated.
• AMW process and revision tables referenced by PROCESS_ID, REVISION_NUMBER, and PROCESS_ORG_REV_ID.