Search Results amw_fin_process_eval_sum

Overview

The AMW_FIN_PROCESS_EVAL_SUM table resides in the AMW schema and is a core data object within the Oracle Internal Controls Manager (ICM) module, delivered as part of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores summarized data on audit evaluation and certification information for business processes that materially affect the financial items and natural accounts included in a Financial Certification. In practice, this table acts as a pre-aggregated snapshot supporting the financial certification and Sarbanes-Oxley (SOX) compliance workflow, allowing auditors, compliance officers, and process owners to review the evaluation status and certification progress of financial-relevant processes without traversing granular transactional detail.

From a data modeling perspective, the heuristic Data Vault classification provided in the metadata indicates this object behaves as a standalone construct — neither a strict hub, link, nor satellite — because its foreign key surface is narrow (only a single reference to FND_SECURITY_GROUPS) and its row identity is anchored to a composite business context (financial certification and process) rather than a single natural key hub. This classification should be treated as a modeling suggestion, useful when mapping the table into an enterprise data warehouse, but it does not constrain its operational behavior within EBS.

Key Information Stored

The table contains 32 documented columns in the 12.1.1 release. The most significant columns and their roles are:

• FIN_CERTIFICATION_ID — Identifies the parent financial certification to which the summarized evaluation belongs; a primary business-key component.
• PROCESS_ID — The business process being summarized; combined with FIN_CERTIFICATION_ID, forms the principal business-key candidate for record uniqueness.
• CERT_OPINION_ID and EVAL_OPINION_ID — Reference the certification and evaluation opinions rendered for the process, capturing the compliance conclusion.
• UNMITIGATED_RISKS, INEFFECTIVE_CONTROLS, RISKS_VERIFIED, CONTROLS_VERIFIED — Counts of risks and controls flagged during evaluation, forming the quantitative backbone of the summary.
• UNMITIGATED_RISKS_PRCNT, INEFFECTIVE_CONTROLS_PRCNT — Percentage roll-ups derived from the underlying risk and control populations.
• TOTAL_NUMBER_OF_SUB_PROCS, NUMBER_OF_SUB_PROCS_CERTIFIED, SUB_PROCS_CERTIFIED_PRCNT — Sub-process coverage metrics.
• TOTAL_NUMBER_OF_ORG_PROCS, NUMBER_OF_ORG_PROCS_CERTIFIED, ORG_PROCS_CERTIFIED_PRCNT — Organizational process certification coverage.
• OPEN_FINDINGS — Count of unresolved audit findings tied to the process.
• TOTAL_NUMBER_OF_RISKS and TOTAL_NUMBER_OF_CTRLS — Denominator values used to compute the percentage columns.
• PROCESS_ORG_REV_ID, REVISION_NUMBER, ACCOUNT_PROCESS_FLAG — Revision and account-impact context for the summarized process.
• OBJECT_VERSION_NUMBER — Optimistic locking column.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data segregation.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ORGANIZATION_ID for multi-org filtering.

The table does not expose a documented single-column surrogate primary key; row identity is defined by the composite of FIN_CERTIFICATION_ID and PROCESS_ID along with revision context.

Common Use Cases and Queries

Typical reporting scenarios include certification dashboards showing how many processes are fully certified, exception reports highlighting processes with unmitigated risks or ineffective controls, and trend analysis comparing revision-to-revision certification percentages.

A representative query surfaces processes with a high unmitigated-risk ratio for a given certification:

• SELECT FIN_CERTIFICATION_ID, PROCESS_ID, UNMITIGATED_RISKS, TOTAL_NUMBER_OF_RISKS, UNMITIGATED_RISKS_PRCNT FROM AMW.AMW_FIN_PROCESS_EVAL_SUM WHERE UNMITIGATED_RISKS_PRCNT > 25 ORDER BY UNMITIGATED_RISKS_PRCNT DESC;

For certification progress tracking, aggregate the sub-process and organizational process coverage columns, filtering on ORGANIZATION_ID and SECURITY_GROUP_ID to respect multi-org and security profile boundaries. Finding-driven queries join OPEN_FINDINGS to downstream audit detail tables. Because the table is pre-summarized, it is well suited to concurrent-program extracts that feed enterprise GRC and BI reporting layers.

Related Objects

The metadata documents one explicit foreign key: SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS. In practice, the table participates in a broader relational network within the ICM module:

• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for data segregation.
• AMW_FIN_CERTIFICATIONS (or equivalent financial certification parent) — joined on FIN_CERTIFICATION_ID.
• AMW_PROCESSES — joined on PROCESS_ID to obtain process name and attributes.
• AMW_CERT_OPINIONS and AMW_EVAL_OPINIONS — joined on CERT_OPINION_ID and EVAL_OPINION_ID respectively for opinion text.
• AMW_PROCESS_ORG_REVISIONS — joined on PROCESS_ORG_REV_ID for revision detail.
• HR_ALL_ORGANIZATION_UNITS — linked via ORGANIZATION_ID for multi-org display.
• AMW_FIN_PROC_EVAL_SUM_LOG (audit/log counterpart) — holds change history parallel to CERT_OPINION_LOG_ID and EVAL_OPINION_LOG_ID.

These relationships should be confirmed against the current 12.1.1 or 12.2.2 instance, as internal ICM table names follow the AMW prefix and remain consistent across both releases.