Search Results create_rebuild_job

Overview

APPS.EAM_REBUILD is an Oracle Enterprise Asset Management (eAM) utility package that supports the asset rebuild business process. In Oracle EBS, a rebuild is a discrete maintenance activity in which a repairable or serialized asset is restored to a serviceable condition and returned to inventory, typically as a distinct item instance. The package encapsulates the logic required to create a rebuild work order and to establish or update the asset genealogy that links the resulting rebuilt asset to its predecessor components or originating asset.

As documented in the ETRM metadata for release 12.2.2, the package is owned by APPS and classified as OTHER, indicating that it is an internal, non-public API rather than a supported open interface. The source header identifies it as EAMRBLDS.pls, version 115.0, originally created in April 2004, and it is declared with AUTHID CURRENT_USER so that privileges are evaluated against the invoking schema. The package body is minimal, exposing a single documented procedure, and is referenced by one other package within the eAM module.

Key Procedures and Functions

The package exposes one documented procedure:

• CREATE_REBUILD_JOB — Creates a rebuild work order and updates asset genealogy. As the comment in the package specification states, this procedure is responsible for generating the rebuild job and maintaining the parent-child relationships that record the asset's rebuild history. Its parameter signature follows the EAM convention of an input identifier accompanied by two output parameters: a return value and an error message, allowing the caller to determine success or failure without raising an unhandled exception. No public functions are documented for this package.

Tables Accessed

The documented tables referenced through APPS synonyms reflect the data required to create a rebuild work order and preserve genealogy:

• CSI_ITEM_INSTANCES — the core eAM instance table, used to identify and update the asset instance being rebuilt and to link the resulting instance to its origin.
• EAM_ORG_MAINT_DEFAULTS — supplies organization-level maintenance defaults, such as the default work order type and statuses applied to the new rebuild job.
• MTL_EAM_ASSET_ACTIVITIES — records the asset activity entries that document the rebuild operation against the instance.
• MTL_MATERIAL_TRANSACTIONS_TEMP — the interface table used to stage material transactions associated with the rebuild work order.
• MTL_PARAMETERS — provides organization parameters, including the default inventory organization context for the transaction.
• MTL_SERIAL_NUMBERS — supports serial number handling for the rebuilt asset and any associated components.
• MTL_SYSTEM_ITEMS — validates and resolves the item definition of the asset being rebuilt.

Usage Notes

Because EAM_REBUILD is classified as OTHER and is not a published open API, it is intended for internal consumption by Oracle eAM application code rather than by customer extensions. It is referenced by one other package, indicating that it is invoked from within the eAM rebuild flow — most commonly from the eAM work order or rebuild user interface, or from a related internal package that orchestrates the rebuild process. Direct invocation from custom PL/SQL is possible in principle, since the procedure accepts a temporary identifier and returns status and error outputs, but such calls are unsupported and risk incompatibility during patching or upgrades. Developers who require rebuild functionality should use the supported eAM work order APIs and forms instead of calling EAM_REBUILD directly. The AUTHID CURRENT_USER declaration means callers must have appropriate privileges on the underlying tables and on any objects accessed by the package body.