Search Results amw_proc_cert_eval_sum

Overview

AMW_PROC_CERT_EVAL_SUM is a denormalized summary table within the Oracle E-Business Suite Internal Controls Manager (AMW) module, a component that is now classified as obsolete in the ETRM documentation. The table stores certification and evaluation information for each process that falls within certification scope, aggregating evaluation outcomes, risk and control counts, and certification percentages into a single consolidated row per process. Its purpose is to accelerate reporting on certification status without repeatedly recalculating underlying detail data across the AMW certification and evaluation hierarchy.

Under the heuristic Data Vault classification derived from foreign key structure, this object is identified as satellite-leaning. In modeling terms, this suggests the table behaves primarily as a descriptive attribute carrier attached to a parent business key, rather than as a hub (which would hold unique business entities) or a link (which would resolve many-to-many relationships). The composite primary key of CERTIFICATION_ID, ORGANIZATION_ID, and PROCESS_ID, mirrored by unique index AMW_PROC_CERT_EVAL_SUM_U1, confirms that each row is uniquely identified by the combination of a certification, an organization, and a process.

Key Information Stored

The table contains 34 documented columns. The most significant are summarized below.

• CERTIFICATION_ID — Identifier of the parent certification record; part of the composite primary key and the foreign key to AMW_CERTIFICATION_B.
• ORGANIZATION_ID — The operating unit or organization context for the process evaluation; part of the composite primary key.
• PROCESS_ID — The process being certified or evaluated; part of the composite primary key.
• SUB_PROCESS_CERT / TOTAL_SUB_PROCESS_CERT — Count of sub-processes certified against total sub-processes in scope.
• ORG_PROCESS_CERT / TOTAL_ORG_PROCESS_CERT — Organization-level process certification counts against totals.
• SUB_PROCS_CERTIFIED_PRCNT / ORG_PROCS_CERTIFIED_PRCNT — Derived percentage completion metrics for sub-process and organization process certification.
• UNMITIGATED_RISKS / UNMITIGATED_RISKS_PRCNT — Count and percentage of risks lacking mitigation.
• INEFFECTIVE_CONTROLS / INEFFECTIVE_CONTROLS_PRCNT — Count and percentage of controls assessed as ineffective.
• OPEN_FINDINGS / OPEN_ISSUES — Outstanding findings and issues associated with the process.
• EVALUATED_RISKS / TOTAL_RISKS and EVALUATED_CONTROLS / TOTAL_CONTROLS — Coverage metrics for risk and control evaluation.
• CERTIFICATION_OPINION_ID / EVALUATION_OPINION_ID — References to the certification and evaluation opinions rendered.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing row-level security.

The columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER provide standard audit and concurrency-control attributes.

Common Use Cases and Queries

This table is primary designed for certification status dashboards and period-end compliance reporting. A typical query retrieves process-level certification coverage for a given certification and organization:

• Filter by CERTIFICATION_ID and ORGANIZATION_ID to obtain all processes in scope and their certification percentages.
• Rank processes by UNMITIGATED_RISKS_PRCNT or INEFFECTIVE_CONTROLS_PRCNT to surface high-exposure areas.
• Aggregate SUB_PROCS_CERTIFIED_PRCNT and ORG_PROCS_CERTIFIED_PRCNT to compute overall certification readiness.
• Join to AMW_CERTIFICATION_B on CERTIFICATION_ID to resolve certification name, period, and status.
• Apply SECURITY_GROUP_ID filtering through FND_SECURITY_GROUPS for multi-org access control.

A representative pattern is: SELECT PROCESS_ID, SUB_PROCS_CERTIFIED_PRCNT, UNMITIGATED_RISKS FROM AMW_PROC_CERT_EVAL_SUM WHERE CERTIFICATION_ID = :p_cert AND ORGANIZATION_ID = :p_org ORDER BY UNMITIGATED_RISKS DESC.

Related Objects

• AMW_CERTIFICATION_B — Parent certification entity; joined via AMW_PROC_CERT_EVAL_SUM.CERTIFICATION_ID = AMW_CERTIFICATION_B.CERTIFICATION_ID.
• FND_SECURITY_GROUPS — Security group master; joined via SECURITY_GROUP_ID for row-level access control.
• AMW_CERTIFICATION_TL — Certification translations providing descriptive names for reporting.
• AMW_PROCESS_B — Process definition master supplying PROCESS_ID context.
• AMW_RISKS / AMW_CONTROLS — Underlying risk and control detail tables that feed the summary counts.
• AMW_EVALUATIONS — Evaluation detail records supporting EVALUATION_OPINION_ID values.