Search Results eam_workorderrep_pvt




Overview
Explore in AI Chat

Overview

APPS.EAM_WORKORDERREP_PVT is an internal, private PL/SQL package in Oracle E-Business Suite that supports the Enterprise Asset Management (EAM) work order reporting infrastructure. Its role is to assemble and return the structured report data required by the EAM Work Order Report, converting base records into the XML and formatted output consumed by the reporting layer. The package is classified as PVT, indicating it is not a public API and is intended strictly for internal consumption by the EAM reporting framework, most notably the public package APPS.EAM_WOREP_PUB, which references it directly.

In the Oracle EBS 12.1.1 and 12.2.2 release streams this package is a supporting dependency of the work order report generation flow rather than a standalone transaction processor. The ETRM metadata records its status as VALID and confirms dependencies on the STANDARD SQL library within the SYS schema, the EAM_WIPID_TAB_TYPE collection type, and the internal recursive reference to itself.

Key Procedures and Functions

The documented package exposes three procedures or functions, each serving a distinct stage of report preparation:

  • GETWOREPORTXML — The principal entry point that constructs the XML payload representing the work order report. It gathers work order and asset details and returns them in a structured XML format suitable for downstream reporting tools and templates.
  • GETLONG — A utility routine that retrieves long or extended text values required during report assembly, addressing data types that cannot be returned through standard SQL scalar handling.
  • CONVERT_TO_CLIENT_TIME — A conversion helper that adjusts stored database timestamps into the client time zone, ensuring that dates and times displayed on the report reflect the user's local context rather than server time.

The documented metadata does not publish parameter signatures for these units; consumers should therefore treat them as internal calls and rely on EAM_WOREP_PUB rather than invoking them directly.

Tables Accessed

The package reads from a broad set of EAM master and transactional tables through APPS synonyms. Work order and asset context is drawn from CSI_ITEM_INSTANCES, EAM_ASSET_FAILURES, EAM_ASSET_FAILURE_CODES, EAM_FAILURE_SETS, and EAM_FAILURE_SET_ASSOCIATIONS, supporting failure history on the report. Counter and meter data is sourced from CSI_COUNTERS_B, CSI_COUNTERS_TL, CSI_COUNTER_ASSOCIATIONS, CSI_COUNTER_READINGS, and CSI_COUNTER_RELATIONSHIPS, enabling readings and associated counters to appear. Resource and routing detail is retrieved from BOM_DEPARTMENTS, BOM_RESOURCES, BOM_RESOURCE_EMPLOYEES, and BOM_STANDARD_OPERATIONS, while cost activity information is taken from CST_ACTIVITIES. All access is read-oriented for reporting purposes.

Usage Notes

EAM_WORKORDERREP_PVT is invoked indirectly in the Oracle EBS environment. The public package APPS.EAM_WOREP_PUB calls into this private package, and EAM_WORKORDERREP_PVT also references itself, reflecting an internal recursive or shared-call pattern. Typical invocation is through the EAM Work Order Report concurrent program or the corresponding reporting pages, which rely on EAM_WOREP_PUB and therefore propagate the call. Custom development should not reference EAM_WORKORDERREP_PVT directly; the supported entry point is the published API layer, and any direct call risks breakage across patches. Because the object is documented as VALID in 12.2.2, it remains a stable internal dependency of the standard EAM work order reporting chain.