Search Results api_log

Overview

APPS.CSI_WIP_TRXS_PKG is a server-side PL/SQL package in Oracle E-Business Suite that belongs to the eTRM (Enterprise Transaction Recording and Management) module of Oracle Manufacturing. Its principal business function is to record and validate Work in Process (WIP) inventory transactions against Oracle's transactional item instance model — that is, the CSI (Customer and Supplier Items / item instance) layer that tracks serialized, lot-controlled, and genealogy-linked on-hand objects. By intercepting standard WIP transaction events such as component issues, assembly completions, byproduct handling, and returns, the package creates and maintains the corresponding CSI_ITEM_INSTANCES and CSI_TRANSACTIONS records and their relationships, ensuring item instance tracking remains consistent with the underlying MTL and WIP transaction streams.

The package is classified in ETRM metadata with an API classification of OTHER and is referenced by three other packages, indicating it acts as a shared internal utility in the eTRM transaction recording stack rather than a standalone public API.

Key Procedures and Functions

The documented procedures cover the full lifecycle of WIP material movement:

• WIP_COMP_ISSUE — records the issue of components from inventory into a discrete job, generating CSI transactions for the issued instances.
• WIP_COMP_RECEIPT — reverses or receives components back, synchronizing CSI instance state with the MTL transaction.
• WIP_ASSY_COMPLETION — creates the item instance record for a completed assembly, establishing assembly/component genealogy.
• WIP_BYPRODUCT_COMPLETION — handles item instance creation for byproducts produced during a job.
• WIP_BYPRODUCT_RETURN — processes return of byproduct instances back into inventory.
• WIP_ASSY_RETURN — returns a completed assembly instance to WIP, reversing completion effects.
• WIP_NEG_COMP_RETURN — manages return of negatively issued components.
• PROCESS_MANUAL_RLTNS — processes manually defined instance relationships (component-to-assembly links) outside the standard flow.
• EAM_WIP_COMPLETION — performs the equivalent completion logic for Enterprise Asset Management (maintenance) work orders.
• EAM_REBUILDABLE_RETURN — handles return of rebuildable items within EAM work order processing.

Tables Accessed

The package reads and writes several core tables, all through APPS synonyms. CSI_ITEM_INSTANCES stores the master item instance records; CSI_TRANSACTIONS and CSI_T_TXN_LINE_DETAILS capture the transactional history and line-level detail; CSI_II_RELATIONSHIPS stores genealogy relationships between assemblies and components. MTL_MATERIAL_TRANSACTIONS, MTL_UNIT_TRANSACTIONS, MTL_TRANSACTION_LOT_NUMBERS, MTL_SERIAL_NUMBERS, and MTL_SECONDARY_INVENTORIES supply the underlying inventory transaction, serial, lot, and subinventory data. MTL_SYSTEM_ITEMS / MTL_SYSTEM_ITEMS_B and MTL_PARAMETERS provide item and organization setup validation. WIP_DISCRETE_JOBS links transactions to the discrete job, while MTL_OBJECT_GENEALOGY and HR_ALL_ORGANIZATION_UNITS support genealogy and organization context.

Usage Notes

Because CSI_WIP_TRXS_PKG is invoked automatically from the WIP transaction recording flow (typically through transaction processor and eTRM hooks rather than direct end-user invocation), it is rarely called manually. The internal api_log and debug procedures write diagnostic messages to csi_t_gen_utility_pvt only when the profile option CSI_DEBUG_LEVEL is greater than zero, making that profile the standard mechanism for enabling trace output during troubleshooting. Custom code extending WIP completion or issue processing should route item instance changes through this package rather than writing to CSI tables directly, to preserve genealogy integrity.