Search Results number_of_sub_procs_certified

Overview

AMW.AMW_FIN_PROCESS_EVAL_SUM is a summary table in the Oracle E-Business Suite Applications (AMW) schema that stores aggregated audit evaluation and certification information for business processes affecting financial items and natural accounts within a Financial Certification. The table resides in the APPS_TS_SUMMARY tablespace with a PCT Free of 10, reflecting its role as a reporting and analytics aggregation layer rather than a high-volume transactional store. Records are scoped to a financial certification, a process, and a process organization revision, allowing multiple certifications and revisions of the same process to coexist.

Within the context of Oracle EBS 12.1.1 and 12.2.2, the object supports the Financial Certification and audit evaluation workflows used by internal controls and compliance reporting. Because the metadata identifies only a single foreign key (SECURITY_GROUP_ID to FND_SECURITY_GROUPS), the heuristic Data Vault classification is standalone. As a modeling suggestion, this suggests the table functions as an independent summary or snapshot rather than as a strict hub, link, or satellite within a normalized Data Vault design. Its purpose is denormalized aggregation, not relational reference.

Key Information Stored

The table contains 32 documented columns. The most consequential of these are outlined below:

• FIN_CERTIFICATION_ID — Identifier of the Financial Certification to which the summarized evaluation belongs.
• PROCESS_ID — The process being evaluated.
• PROCESS_ORG_REV_ID — The process organization revision reference, a key search term for this object and a component of the U1 unique index.
• ORGANIZATION_ID — The operating unit or organization context, also part of the U1 unique index.
• CERT_OPINION_ID / CERT_OPINION_LOG_ID — The certification opinion and its log reference for the process record.
• EVAL_OPINION_ID / EVAL_OPINION_LOG_ID — The audit evaluation opinion and its log reference.
• UNMITIGATED_RISKS — Count of risks whose latest audit evaluation was "Not Effective" during the certification period.
• INEFFECTIVE_CONTROLS — Count of controls whose latest audit evaluation was "Not Effective" during the certification period.
• UNMITIGATED_RISKS_PRCNT / INEFFECTIVE_CONTROLS_PRCNT — Ratio-based percentages relative to risks verified and controls verified respectively.
• RISKS_VERIFIED / CONTROLS_VERIFIED — Verified counts used as denominators in the percentage calculations.
• TOTAL_NUMBER_OF_SUB_PROCS / NUMBER_OF_SUB_PROCS_CERTIFIED / SUB_PROCS_CERTIFIED_PRCNT — Child process volumes and certification coverage percentages.
• TOTAL_NUMBER_OF_ORG_PROCS / NUMBER_OF_ORG_PROCS_CERTIFIED / ORG_PROCS_CERTIFIED_PRCNT — Organization-level process counts and certification coverage.
• OPEN_FINDINGS — Count of open audit findings associated with the summarized record.

The U1 unique index (FIN_CERTIFICATION_ID, ORGANIZATION_ID, PROCESS_ORG_REV_ID) establishes the business-key candidate, while the N2–N6 non-unique indexes on ORGANIZATION_ID, PROCESS_ID, PROCESS_ORG_REV_ID, CERT_OPINION_LOG_ID, and EVAL_OPINION_LOG_ID support common filter and join paths. No single surrogate primary key column is documented; the unique index columns together serve as the logical identifier.

Common Use Cases and Queries

Typical uses include financial certification dashboards, control effectiveness reporting, and audit remediation tracking. A representative query filtered by the searched term follows:

SELECT organization_id, process_id, cert_opinion_id,
       unmitigated_risks, ineffective_controls,
       unmitigated_risks_prcnt, ineffective_controls_prcnt
FROM   amw.amw_fin_process_eval_sum
WHERE  process_org_rev_id = :p_process_org_rev_id
AND    fin_certification_id = :p_cert_id;

Aggregate reporting by certification is equally common, summing risk and control counts across processes and joining to organization-level tables for coverage analysis. Because records are revision-aware through PROCESS_ORG_REV_ID, queries should constrain certification and revision to avoid double counting.

Related Objects

• FND_SECURITY_GROUPS — Referenced by AMW_FIN_PROCESS_EVAL_SUM.SECURITY_GROUP_ID; join to enforce row-level security filtering.
• APPS.AMW_FIN_CERTIFICATIONS (Fin Certification) — Parent certification entity joined on FIN_CERTIFICATION_ID.
• AMW_FIN_PROCESS_EVAL_DETAIL — Detailed evaluation records typically summarized into this table, joined by PROCESS_ID and PROCESS_ORG_REV_ID.
• AMW_PROCESSES / Process definition views — Provide descriptive process attributes joined on PROCESS_ID.
• HR_OPERATING_UNITS / ORG organization views — Join on ORGANIZATION_ID to resolve operating unit names.
• AMW_CERT_OPINION_LOGS — Opinion log source joined on CERT_OPINION_LOG_ID.
• AMW_EVAL_OPINION_LOGS — Evaluation log source joined on EVAL_OPINION_LOG_ID.