Search Results amw_org_cert_eval_sum_pvt




Overview
Explore in AI Chat

Overview

AMW_ORG_CERT_EVAL_SUM_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Audit Management (formerly Internal Controls Manager) module. Its central purpose is to populate and maintain the organizational certification evaluation summary — a consolidated record of the results of certification evaluations performed across an organization hierarchy. In Oracle EBS 12.1.1 and 12.2.2, this package acts as the private implementation layer behind the public certification-summary functionality, encapsulating the logic that aggregates opinions, findings, and risk assessments into a single evaluation summary per organizational unit.

The private (PVT) designation indicates that the package is not intended for direct invocation by external consumers or custom code; rather, it is called by public wrapper packages, concurrent programs, or internal workflow logic within the Audit Management subsystem. Its status is documented as VALID in the ETRM metadata, confirming it is compiled and operational in the reference environment.

Key Procedures and Functions

The documented package exposes three procedures, each focused on building the organizational certification summary:

  • POPULATE_ORG_CERT_SUMMARY — The primary entry point that drives population of the organizational certification evaluation summary. It consolidates evaluation data for organizational units and writes the results into the summary table.
  • POPULATE_ORG_CERT_SUM_SPEC — Handles summary population for a specific or scoped set of organizational entities, providing a targeted variant of the general summary build.
  • POPULATE_SUMMARY — A general-purpose summary population routine that performs the core aggregation work, likely invoked by the two more specialized procedures above.

No parameter lists are documented in the ETRM metadata; the procedures' signatures are intentionally not reproduced here.

Tables Accessed

The package reads and writes the following documented tables (accessed via APPS synonyms):

  • AMW_ORG_CERT_EVAL_SUM — The primary target table into which the consolidated organizational certification evaluation summaries are written.
  • AMW_OPINIONS — Source of certification opinions that are aggregated into the summary.
  • AMW_CONTROL_ASSOCIATIONS — Defines the relationships between controls and the organizational entities being certified.
  • AMW_RISK_ASSOCIATIONS — Links risk records to the entities under evaluation, informing the summary content.
  • AMW_ENTITY_HIERARCHIES — Supplies the parent-child organizational structure used to roll up evaluation results.
  • AMW_EXECUTION_SCOPE — Determines which organizational units fall within the scope of a given certification execution.

Additional dependencies include lookup views such as AMW_OPINIONS_V, AMW_OPINIONS_LOG_V, AMW_CERTIFICATION_VL, and the helper package AMW_FINDINGS_PKG. Standard EBS utilities FND_API, FND_FILE, FND_GLOBAL, and FND_MSG_PUB provide error handling, file output, session context, and message resolution.

Usage Notes

Because this is a private package body, it is not referenced by any other database object and is not designed for direct invocation. It is typically called indirectly by Audit Management processes — for example, when a certification execution is finalized and the organizational evaluation summary must be recomputed. Users may trigger this path through the relevant certification or opinion forms, or through concurrent programs that refresh summary tables.

Customizations should avoid calling AMW_ORG_CERT_EVAL_SUM_PVT directly, as its interface is subject to change between patch levels. Any integration should target the public API layer instead. In both 12.1.1 and 12.2.2, the package remains owned by APPS and depends on the AMW schema objects listed above.