Search Results csf_preventive_maintenance_pvt




Overview
Explore in AI Chat

Overview

CSF_PREVENTIVE_MAINTENANCE_PVT is a private PL/SQL package owned by APPS that implements the Preventive Maintenance concurrent program API within Oracle E-Business Suite. Its documented purpose is to serve as the programmatic engine behind preventive maintenance processing, bridging installed base asset records and the service request and task infrastructure of Oracle Service. The package header carries a version identifier of 120.0, and the internal history comment records an initial version created for release 11.5.9, which confirms the object's lineage well before the 12.1.1 and 12.2.2 releases in which it remains available.

The business problem addressed is periodic, usage-driven servicing. Preventive maintenance activities are defined against unit effectivities and routes so that a given item instance becomes due for a maintenance event at defined metering or counter thresholds. The package consumes those definitions and produces service requests and associated tasks, then reconciles completion state back to the maintenance schedule as those requests close. Searches such as "maintennce data 26 27" typically reflect an attempt to locate the maintenance data and validation records this processing chain touches.

Key Procedures and Functions

Three procedures are documented in the package specification.

  • GENERATE_SR_TASKS — Queries AHL_UNIT_EFFECTIVITIES_B and CSI_ITEM_INSTANCES, and generates a Service Request for each UMP record plus a task for each corresponding record in AHL_ROUTES_B. It is declared with an API version number and a period size parameter, and returns the standard concurrent program OUT parameters retcode and errbuf. This is the core generation routine.
  • UPDATE_UMP — Updates UMP records to ACCOMPLISHED status, together with counter values, when the service request generated for that UMP has been closed. It is exposed as a concurrent program and is intended to run before new UMP generation, so that completed maintenance is cleared ahead of the next scheduling cycle.
  • UPDATE_SR_TASKS — Completes the SR and task lifecycle, allowing changes originating in maintenance processing to be reflected against the generated service request and task records.

No documented function returns a value other than the standard concurrent OUT parameters. Parameter lists should be taken from the specification rather than assumed.

Tables Accessed

The package reads and writes a broad cross-section of installed base, service, and party data.

Usage Notes

The package is classified as PVT (private), meaning it is not a supported public API for customer extension. It is referenced by zero other packages in the documented metadata, indicating it is invoked directly by the Preventive Maintenance concurrent program rather than by other application code. In practice, DBAs and technical consultants schedule and monitor the associated concurrent programs, and diagnose failures through FND_CONCURRENT_REQUESTS and the retcode/errbuf outputs. The recommended operational sequence is to run UPDATE_UMP before the UMP generation step so that accomplished maintenance records do not block new request creation. Because the package is private, customizations should call the concurrent programs rather than the procedures directly, and any direct invocation should be treated as unsupported and revalidated across 12.1.1 and 12.2.2 upgrades.