Search Results eam_material_validate_pvt




Overview
Explore in AI Chat

Overview

APPS.EAM_MATERIAL_VALIDATE_PVT is a private (PVT) PL/SQL package within the Oracle Enterprise Asset Management (EAM) module of Oracle E-Business Suite. As indicated by the _PVT suffix, it is an internal validation package not intended for direct customer invocation. The package header bears the source file reference EAMVMSCS.pls and was originally created on 02-FEB-2005 by Girish Rajan, with the primary purpose of supporting material shortage analysis for maintenance work orders.

The business function of this package centers on identifying and reporting material shortages associated with EAM work orders. Maintenance planners and supervisors require visibility into whether required materials are available to complete scheduled maintenance activities. This package provides the validation and reporting logic that underpins that material availability analysis.

Key Procedures and Functions

The package contains one documented procedure:

  • MATERIAL_SHORTAGE_CP — This procedure drives the material shortage analysis process. It is uniquely identifiable by its _CP suffix, which in Oracle EBS convention denotes a concurrent program entry point, indicating that this procedure serves as the executable logic for a concurrent program. It accepts standard concurrent program OUT parameters (errbuf, retcode) and a substantial set of IN parameters that define the report scope and filtering criteria. These parameters collectively allow the caller to constrain the analysis by organizational context, asset identification, department ownership and assignment, scheduled start date ranges, work order number ranges, status type, planning horizons, and project/task references.

The procedure is designed to return information via the standard concurrent program output mechanism, populating the report with material shortage results based on the supplied selection criteria.

Tables Accessed

The package references three tables through APPS synonyms:

  • CSI_ITEM_INSTANCES — The Core Services Instance item instances table, which stores asset instance records. In the EAM context, this table identifies the specific asset or equipment instances against which maintenance work orders are executed, allowing the shortage analysis to relate material requirements to specific maintained assets.
  • WIP_ENTITIES — The Work in Process entities table, which holds work order and job header information. EAM work orders are represented in WIP_ENTITIES, so this table supplies the work order population that is evaluated for material shortages.
  • PLITBLM — This table is associated with the concurrent program request/parameter infrastructure in Oracle EBS. Its presence reflects the package's role as a concurrent program driver, where runtime parameters and reporting scope are derived from the submitted concurrent request definition.

Usage Notes

Because this is a private package, direct invocation by customers or custom code is neither expected nor supported. The package is invoked through the EAM concurrent program framework, where MATERIAL_SHORTAGE_CP functions as the program's execution logic. The inclusion of the p_project and p_task parameters demonstrates that the material shortage concurrent program can be scoped to project and task references, supporting project-driven maintenance environments.

Typical invocation flows involve a maintenance planner or supervisor submitting the material shortage concurrent program from an EAM responsibility, specifying organization, asset, department, work order range, date range, and horizon parameters. The procedure then queries the relevant asset, work order, and material data to report shortages.

Developers should treat this package as an internal implementation artifact. Customizations requiring material shortage validation logic should call supported public APIs or replicate the underlying query against the documented tables (CSI_ITEM_INSTANCES, WIP_ENTITIES), rather than depending on this PVT package whose signature may change between EBS releases, including 12.1.1 and 12.2.2.