Search Results per_opl_orgh




Overview
Explore in AI Chat

Overview

PER_OPL_ORGH is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM "OTHER" API classification. Its name and procedure structure indicate that it belongs to the Oracle Learning Management (OLM) family of organization-hierarchy utilities within Oracle Human Resources (PER product family). The package's principal business purpose is to build and maintain the cached organization hierarchy data used by OLM and related HR modules, ensuring that organization structures are flattened and summarized for efficient runtime access. The "OPL" prefix denotes Oracle Provisioning/Learning context, while "ORGH" denotes organization hierarchy processing.

The package header carries the identifier perporgh.pkh, with an original RCS revision of 115.0 dated 24-June-2003. It is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the invoking user rather than with the definer's rights. This is significant because callers must possess the necessary privileges on the underlying PER tables and APPS synonyms to invoke the package successfully.

Key Procedures and Functions

  • LOAD — Accepts a chunk size parameter and performs the organization hierarchy load in incremental batches. This is the internal or programmatic entry point used when a controlled volume of hierarchy records is processed at a time, allowing the caller to bound transaction size and resource consumption.
  • LOAD_ALL_ORGANIZATIONS — The procedure surfaced to the user's search query "load_all_organizations". It is the concurrent-program entry point: it exposes the standard concurrent manager error buffer and return code parameters in addition to the chunk size. This signature confirms that the procedure is registered as a concurrent program and is intended for scheduled or on-demand execution that processes all organizations in a single run.

No other procedures or functions are documented in the ETRM metadata; the specification consists solely of these two entry points. No private package body routines are exposed for reference.

Tables Accessed

The package operates on four documented PER tables, accessed through APPS synonyms:

  • PER_ORGANIZATION_STRUCTURES — Stores the definition of each organization hierarchy, including its business group context and structure type. This is the primary driver from which organizations to be processed are selected.
  • PER_ORG_STRUCTURE_VERSIONS — Holds dated versions of each organization structure. The package must resolve the correct active version before flattening the hierarchy.
  • PER_ORG_STRUCTURE_ELEMENTS — Contains the individual parent-child organization assignments that make up a structure version. This is the detail table read to walk the tree.
  • PER_ORG_HRCHY_SUMMARY — The denormalized summary table populated by the load process. It supplies the pre-computed hierarchy paths consumed by OLM and other HR reporting components.

Usage Notes

The package is most commonly invoked through the LOAD_ALL_ORGANIZATIONS concurrent program, scheduled after changes to organization structures or versions to refresh the summary data. The errbuf and retcode parameters conform to the standard concurrent program interface, so administrators can submit it from the Submit Requests form, the System Administrator responsibility, or via FND_REQUEST.SUBMIT_REQUEST in custom code. Direct calls to LOAD are appropriate only in custom PL/SQL or scripts where a bounded chunk size is desired and the concurrent manager interface is not required. Because the package is AUTHID CURRENT_USER and referenced by no other packages, it is safe to consider it a leaf utility: changes to it do not propagate through the PL/SQL dependency chain. Structured verification of the summary table after execution is recommended to confirm that all organizations were loaded without truncation.