Search Results proc_cert

Overview

AMW_ORG_CERT_EVAL_SUM_V is a public view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered as a public view intended for custom reporting and other data requirements, and its FND Design Data reference is AMW.AMW_ORG_CERT_EVAL_SUM_V. The view presents an organization certification summary, exposing evaluation results for each certification performed against an organization. It surfaces counts and visual indicator columns used by ETRM (Enterprise Track and Risk Management) pages to communicate certification outcomes.

The view is read-only and its status is VALID. Because it is a public view rather than a base table, it serves as a stable reporting interface over the underlying certification summary data. The user query term "open_issues" corresponds directly to a column exposed by this view: OPEN_ISSUES, which reports the total number of open issues associated with an organization certification evaluation. The companion column OPEN_FINDINGS reports the total number of open findings, and both support ETRM dashboards and custom extracts that track unresolved risks and issues.

Underlying Base Objects

According to the documented dependency information, AMW_ORG_CERT_EVAL_SUM_V references the following objects:

• APPS.AMW_ORG_CERT_EVAL_SUM — the base organization certification summary table that supplies the core evaluation data.
• APPS.AMW_THRESHOLD_VALUES — provides threshold values used to derive status, count, or indicator output.
• APPS.FND_PROFILE — supplies profile option values used in view logic, typically for formatting or threshold behavior.
• PUBLIC.DUAL — the standard single-row pseudo-table used for scalar expressions.

The view is not referenced by any other database object, confirming it is a leaf-level reporting construct. It depends on the summary table for certification identifiers, organization identifiers, and evaluation metrics, while the threshold and profile objects influence how counts and status indicators are computed or rendered.

Key Columns

The view exposes the following columns, as documented:

• CERTIFICATION_ID (NUMBER) — organization certification identifier.
• ORGANIZATION_ID (NUMBER) — organization identifier.
• SUB_ORG_CERT (VARCHAR2) — number of sub-organizations that are certified.
• PROC_CERT (VARCHAR2) — number of processes that are certified.
• INEFF_PROCESSES (VARCHAR2) — number of processes evaluated as ineffective.
• UNMITIGATED_RISKS (VARCHAR2) — number of risks evaluated as unmitigated.
• INEFF_CONTROLS (VARCHAR2) — number of controls evaluated as ineffective.
• INEFF_PROCESSES_IMAGE, UNMITIGATED_RISKS_IMAGE, INEFF_CONTROLS_IMAGE (VARCHAR2) — image icon indicators for the corresponding ineffective or unmitigated counts.
• OPEN_FINDINGS (NUMBER) — total number of open findings.
• OPEN_ISSUES (NUMBER) — total number of open issues.
• EVALUATION_OPINION_LOG_ID (NUMBER) — opinion log identifier for the evaluation.

Common Use Cases and Queries

This view is typically used to produce certification status reports, dashboards, and extracts that summarize organization-wide evaluation results. A common query filters by organization or certification and returns open findings and issues:

• SELECT certification_id, organization_id, open_findings, open_issues FROM apps.amw_org_cert_eval_sum_v WHERE organization_id = :org_id;
• SELECT certification_id, sub_org_cert, proc_cert, ineff_processes, unmitigated_risks, ineff_controls FROM apps.amw_org_cert_eval_sum_v WHERE certification_id = :cert_id;
• SELECT organization_id, SUM(open_issues) total_open_issues FROM apps.amw_org_cert_eval_sum_v GROUP BY organization_id ORDER BY total_open_issues DESC;

These patterns support remediation tracking, certification sign-off reporting, and KPI feeds that monitor open issues and findings across organizations.