Search Results csi_inv_trxs_pkg




Overview
Explore in AI Chat

Overview

CSI_INV_TRXS_PKG is a core PL/SQL package body in the APPS schema of Oracle E-Business Suite, deployed in releases 12.1.1 and 12.2.2. It belongs to the Enterprise Trading and Asset Management family of modules (the CSI, or Complex Maintenance, Repair and Overhaul / Installed Base schema) and provides the inventory-facing transaction layer that connects Oracle Inventory and Oracle Purchasing movements to Installed Base asset and instance records. In practical terms, the package captures material transactions — receipts, miscellaneous issues, physical inventory counts, cycle counts and return-to-vendor activity — and drives the corresponding creation, update or validation of CSI item instances and CSI transactions.

Because it is an OTHER-classified API package rather than a public published API, it is primarily an internal engine invoked by other EBS components rather than by end users or customer code. It is referenced by 52 other database objects, confirming its role as a shared utility for the Installed Base transaction pipeline.

Key Procedures and Functions

The package exposes 44 documented procedures and functions. The principal business entry points are:

  • RECEIPT_INVENTORY — processes receiving activity and creates or updates the associated CSI instance records.
  • MISC_RECEIPT and MISC_ISSUE — handle miscellaneous inventory receipts and issues, driving corresponding CSI transactions.
  • PHYSICAL_INVENTORY and CYCLE_COUNT — process physical inventory and cycle count outcomes so that instance-level records stay aligned with inventory adjustments.
  • GET_RTV_TRANSACTION_RECS and GET_TRANSACTION_RECS — retrieval helpers that return transaction record sets for return-to-vendor and general CSI transaction processing.

Supporting utilities include CHECK_ITEM_TRACKABLE (determines whether an item is tracked in the installed base), GET_ASSET_CREATION_CODE and CHECK_DEPRECIABLE (asset-related attribute derivation), GET_MASTER_ORGANIZATION and GET_NEG_INV_CODE, GET_DEFAULT_STATUS_ID, IS_CSI_INSTALLED, DECODE_MESSAGE, BUILD_ERROR_STRING and GET_STRING_VALUE (message and error handling), plus a set of record initializers: INIT_INSTANCE_QUERY_REC, INIT_INSTANCE_CREATE_REC and INIT_INSTANCE_UPDATE_REC.

Tables Accessed

Through APPS synonyms the package reads and writes inventory and receiving tables — MTL_MATERIAL_TRANSACTIONS, MTL_UNIT_TRANSACTIONS, MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ENTRIES, MTL_PHYSICAL_INVENTORIES, MTL_PHYSICAL_ADJUSTMENTS, MTL_PHYSICAL_INVENTORY_TAGS, MTL_SECONDARY_INVENTORIES, MTL_PARAMETERS, MTL_SERIAL_NUMBERS, MTL_SYSTEM_ITEMS(_B), MTL_TRANSACTION_LOT_NUMBERS, and RCV_TRANSACTIONS — these supply the source movement data. It consults purchasing tables (PO_HEADERS_ALL, PO_LINES_ALL, PO_DISTRIBUTIONS_ALL) for receipt context and writes CSI-owned tables (CSI_ITEM_INSTANCES, CSI_ITEM_INSTANCES_H, CSI_TRANSACTIONS, CSI_INSTANCE_STATUSES, CSI_TXN_TYPES, CSI_IPA_RELATION_TYPES) plus organizational lookups (HR_ALL_ORGANIZATION_UNITS, FND_USER, FND_APPLICATION). Internal CSI and FND public packages (CSI_ITEM_INSTANCE_PUB, CSI_PROCESS_TXN_PVT, FND_MSG_PUB) are also called.

Usage Notes

CSI_INV_TRXS_PKG is invoked indirectly: Installed Base transaction processing, Oracle Inventory receiving, and asset-creation flows call it when trackable items move. Custom extensions should generally use documented public CSI APIs rather than this package, because its signatures and validation logic are not published and can change between 12.1.1 and 12.2.2. Use it only via supported calling components, and always route errors through the packaged FND message and error-string utilities.