Search Results eam_rebuildable_return

Overview

CSI_WIP_TRXS_PKG is an Oracle EBS Application Programming Interface package owned by the APPS schema and classified under the OTHER API category. Its central business function is to create and process CSI (Complex Maintenance, Repair and Overhaul / Enterprise Asset Management) transaction records that originate from Work in Process (WIP) activity. Whenever a WIP transaction — a component issue, an assembly completion, a by-product receipt or return, or an EAM-specific maintenance activity — affects a trackable item, asset, or rebuildable component, this package translates the WIP event into the corresponding rows in the CSI transaction and item instance tables so that the asset's genealogy and transaction history remain consistent with manufacturing execution.

The package header (version 120.6.12010000.1) declares two PL/SQL record types that define its data contract. The txn_ref record carries transaction identity and context — transaction ID, transaction date, transaction type, source type, action, inventory item, organization, quantities and UOMs, and the control codes for serial, lot, revision and locator tracking. It also carries the EAM-specific attributes: ib_trackable_flag, eam_item_type, bom_item_type, and a substantial group of WIP attributes including wip_entity_id, wip_entity_name, wip_entity_type, wip_job_type, wip_status_type, and the maintenance source, object type and object ID fields. A second record type, mmt_rec, mirrors the material transaction structure used to stage inventory movements.

Key Procedures and Functions

Ten documented procedures constitute the package API. They fall into three functional groupings.

• WIP_COMP_ISSUE — processes the issue of components to a WIP job, generating the CSI transaction representation of the material issue.
• WIP_COMP_RECEIPT — processes the receipt of components against WIP activity.
• WIP_ASSY_COMPLETION — records completion of a WIP assembly, establishing or updating the resulting item instance.
• WIP_ASSY_RETURN — reverses or returns an assembly completion, adjusting the associated CSI transaction and instance data.
• WIP_BYPRODUCT_COMPLETION — records completion of a by-product produced during WIP execution.
• WIP_BYPRODUCT_RETURN — reverses a by-product completion.
• WIP_NEG_COMP_RETURN — handles the return of negatively issued components, a common correction path in WIP.
• PROCESS_MANUAL_RLTNS — processes manually entered relationships, allowing users to create CSI relationship records outside the standard automated flow.
• EAM_WIP_COMPLETION — the EAM-specific completion path, capturing maintenance work order completion for rebuildable or maintainable assets.
• EAM_REBUILDABLE_RETURN — the procedure most directly associated with the user's search term eam_rebuildable_return. It processes the return of a rebuildable item from EAM maintenance activity, updating the rebuilt asset's CSI transaction and item instance records so the asset returns to a serviceable state with correct genealogy.

Tables Accessed

The package operates across four functional table groups, accessed through APPS synonyms.

• CSI core tables — CSI_TRANSACTIONS, CSI_T_TXN_LINE_DETAILS, CSI_ITEM_INSTANCES, and CSI_II_RELATIONSHIPS. These are the primary write targets: the package inserts transaction headers, line details, item instance updates, and instance-to-instance relationships.
• WIP tables — WIP_DISCRETE_JOBS supplies the job context (entity, name, type, status, assembly, start and completed quantities) that populates the txn_ref WIP attributes.
• Inventory and transaction tables — MTL_MATERIAL_TRANSACTIONS, MTL_UNIT_TRANSACTIONS, MTL_TRANSACTION_LOT_NUMBERS, and MTL_SERIAL_NUMBERS record the material movement and lot/serial detail associated with each CSI transaction; MTL_OBJECT_GENEALOGY captures the parent-child genealogy of tracked objects.
• Setup and reference tables — MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B provide item attributes such as control codes and item type; MTL_PARAMETERS supplies organization-level inventory parameters; MTL_SECONDARY_INVENTORIES supplies subinventory data; and HR_ALL_ORGANIZATION_UNITS supplies organization identity.

Usage Notes

CSI_WIP_TRXS_PKG is an internal integration API rather than an end-user entry point. It is invoked when WIP transactions affecting CSI-tracked items are processed — either through the WIP transaction forms and concurrent material transaction programs, or through other packages in the CSI and WIP integration layer. The ETRM metadata records that three other packages reference it, confirming that it sits below the public API surface and is called by higher-level processing routines.

Because it writes directly to CSI and MTL tables and is governed by the standard EBS API rules, it should not be called in isolation by custom code without supplying a fully populated txn_ref record and ensuring the calling context has already validated the underlying WIP transaction. Custom extensions that need to trigger CSI transaction creation from EAM rebuildable returns should call EAM_REBUILDABLE_RETURN rather than manipulating the CSI tables directly, so that item instance and genealogy records remain consistent with the transaction history.