Results for “certification_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMW_ORG_CERT_EVAL_SUM_V is a reporting view within the Oracle E-Business Suite Internal Controls Manager (ICM) module, identified by the product code AMW. In ETRM 12.1.1 and 12.2.2 this module is documented as obsolete, meaning the object is retained only for historical reference and is not implemented in current database instances. The view presents an organization certification summary, aggregating the certification status of subordinate organizations and their associated business processes into a form suitable for management review and sign-off.

The view's central purpose is to render certification progress in a presentation-ready format driven by a profile option. It exposes counts such as the number of certified sub-organizations and certified processes, and it dynamically reformats these figures as raw numbers, ratios (certified / total), or percentages depending on the value of the AMW_OPINION_NUMBERS_OPTION profile option. This design supports the certification opinion workflow, where executives assess whether the population of sub-entities has completed certification before issuing an overall opinion. Because of its summary nature, the view functions as a reporting convenience rather than a transactional interface.

Underlying Base Objects

The documented source is the organization certification summary table, referenced in the view text by the alias OSUM (conventionally AMW_ORG_CERT_EVAL_SUM or an equivalent summary table). No additional base objects are documented in the ETRM metadata, and the database listing reports the view as "Not implemented in this database." The view text confirms a narrow dependency: it selects columns such as CERTIFICATION_ID, ORGANIZATION_ID, TOTAL_SUB_ORG, SUB_ORG_CERT, TOTAL_PROCESSES, PROCESSES_CERTIFIED, and INEFF_PROCESSES directly from OSUM, wrapping each measure in a DECODE and correlated subquery against DUAL that reads FND_PROFILE.VALUE('AMW_OPINION_NUMBERS_OPTION').

Consequently, the view has two effective dependencies: the underlying certification summary table providing the raw counts, and the FND profile infrastructure supplying the formatting behavior. Because the transformation occurs in SELECT-list scalar subqueries rather than joins, row cardinality is preserved at one row per certification/organization combination.

Key Columns

• CERTIFICATION_ID — Identifier of the certification event or cycle to which the summary row belongs.
• ORGANIZATION_ID — The organization (typically a parent or reviewing entity) whose certification summary is represented.
• SUB_ORG_CERT — Formatted indicator of sub-organization certification. Returns NULL when TOTAL_SUB_ORG is zero; otherwise it yields a raw count, a "certified / total" ratio, or a rounded percentage based on the profile setting.
• PROCESSES_CERTIFIED — Formatted indicator of process certification coverage, constructed identically to SUB_ORG_CERT but based on PROCESSES_CERTIFIED versus TOTAL_PROCESSES.
• Total and ineffective measures — TOTAL_SUB_ORG, TOTAL_PROCESSES, and INEFF_PROCESSES provide the denominators and the count of ineffective ("unmitigated") processes that drive the "INEFF" family of profile options. These are the values most relevant to searches on unmitigated_risks, since ineffective process counts surface control gaps that remain unmitigated.

Common Use Cases and Queries

The primary use case is executive and compliance reporting on certification completeness, particularly where reviewers must quantify unmitigated risk exposure across organizational hierarchies. A representative query follows:

SELECT certification_id, organization_id, sub_org_cert, processes_certified FROM amw_org_cert_eval_sum_v WHERE organization_id = :org_id;

To isolate rows where ineffective processes remain, filtering on the underlying measures (for example, joining the summary table to compare INEFF_PROCESSES against TOTAL_PROCESSES) surfaces unmitigated risk items awaiting remediation. Because formatting depends on AMW_OPINION_NUMBERS_OPTION, administrators should verify the profile value at the site or responsibility level before relying on the displayed figures, as the same row may appear as "12 / 20", "60%", or "12" depending on configuration. Given the module's obsolete status in both 12.1.1 and 12.2.2, these queries should be treated as legacy reporting references rather than supported integration points.