Search Results pa_sch_except_hist_pkg




Overview
Explore in AI Chat

Overview

The APPS.PA_SCH_EXCEPT_HIST_PKG package is a PL/SQL database object within the Oracle E-Business Suite Projects (PA) module. Its principal business function is to manage the persistence and historical tracking of scheduling exceptions generated during project scheduling and resource assignment processes. In Oracle Projects, scheduling engines evaluate project structures, resource assignments, and calendar constraints against defined scheduling rules. When a rule cannot be satisfied—for example, when a resource is unavailable during the requested period, a dependency cannot be honored, or a calendar conflict arises—the system records an exception. The PA_SCH_EXCEPT_HIST_PKG package provides the mechanism for capturing these exceptions into a history repository so that users can review, diagnose, and act upon scheduling conflicts after the scheduling process concludes.

The package is classified as an "OTHER" API in the ETRM metadata, indicating it is an internal utility package rather than a formally published public API. It is maintained by Oracle and its status is VALID across both the 12.1.1 and 12.2.2 release streams.

Key Procedures and Functions

The documented package metadata exposes one named program unit, identified as INSERT_ROWS. This procedure is responsible for inserting scheduling exception records—typically held in PL/SQL memory as the scheduling process evaluates the project—into the persistent exception history table. It serves as the write path through which transient scheduling diagnostics become durable, queryable history entries. The metadata lists the total documented procedures and functions at two, though only INSERT_ROWS is individually catalogued; parameter lists are not published in the ETRM excerpt and must not be assumed.

Tables Accessed

The package operates against the following database objects:

  • PA_SCHEDULE_EXCEPT_HISTORY — the primary target table, holding the captured scheduling exception records. INSERT_ROWS writes to this table.
  • PA_SCHEDULE_GLOB — a global/package-level data structure or configuration table referenced by the package, likely supplying scheduling context or default values used during exception recording.
  • PLITBLM — a standard Oracle-supplied PL/SQL table type (part of the STANDARD package infrastructure) used for passing collections of rows into the package for bulk processing.

Usage Notes

PA_SCH_EXCEPT_HIST_PKG is an internal dependency of the scheduling engine rather than an interface intended for direct customer invocation. The ETRM metadata shows it is referenced by APPS.PA_SCHEDULE_PUB, the public scheduling API, which indicates that INSERT_ROWS is called as part of the broader scheduling workflow orchestrated by that public package. In practice, the insertion of exception history occurs when project scheduling or resource scheduling is executed—whether through Oracle Projects forms, concurrent programs such as the scheduling processes, or programmatic calls to PA_SCHEDULE_PUB. Because the package sits beneath a public API, customizations should invoke the documented public layer rather than calling PA_SCH_EXCEPT_HIST_PKG directly, preserving upgrade safety. Administrators reviewing scheduling exceptions typically access the results through standard Projects inquiry forms that query PA_SCHEDULE_EXCEPT_HISTORY. Given its status as an unpublished utility, its signature and internal behavior are subject to change across patch levels, so any extension code should treat it as a private implementation detail.