Search Results misc_issue

Overview

APPS.CSI_INV_TRXS_PKG is the inventory transaction integration package within Oracle E-Business Suite's Enterprise Asset Management (eAM) and Installed Base (CSI) modules. Its primary business function is to bridge Oracle Inventory material transactions with the CSI Item Instances tables that track asset lifecycles, serialized item status, and transaction history. Whenever an inventory transaction affects a tracked or serialized item, this package determines whether an Installed Base record must be created, updated, or transitioned between lifecycle states such as IN_PROCESS, IN_INVENTORY, IN_SERVICE, OUT_OF_SERVICE, IN_TRANSIT, INSTALLED, IN_WIP, COMPLETE, and PENDING.

The package defines the record type MTL_ITEM_REC_TYPE, which mirrors the key columns of a material transaction — inventory item, organization, subinventory, revision, quantities, UOMs, transaction type and action identifiers, locators, and project/task references. This record type is the common payload passed between the transaction-handling procedures and the Installed Base APIs.

Key Procedures and Functions

The package exposes 44 documented procedures and functions. The transaction-processing entry points include RECEIPT_INVENTORY, MISC_RECEIPT, MISC_ISSUE, PHYSICAL_INVENTORY, and CYCLE_COUNT. MISC_RECEIPT handles miscellaneous receipt transactions and is the routine most frequently associated with the misc_receipt search term; it validates the item, determines trackability, and drives the corresponding CSI instance update. MISC_ISSUE performs the symmetric logic for miscellaneous issues.

Retrieval routines GET_TRANSACTION_RECS and GET_RTV_TRANSACTION_RECS assemble transaction record sets, including return-to-vendor flows. Validation helpers include CHECK_ITEM_TRACKABLE, CHECK_DEPRECIABLE, GET_ASSET_CREATION_CODE, GET_NEG_INV_CODE, and GET_DEFAULT_STATUS_ID. Utility routines GET_MASTER_ORGANIZATION, GET_STRING_VALUE, IS_CSI_INSTALLED, and DECODE_MESSAGE support lookup and message translation. The INIT_INSTANCE_QUERY_REC, INIT_INSTANCE_CREATE_REC, and INIT_INSTANCE_UPDATE_REC procedures initialize the instance record structures used by the CSI APIs. BUILD_ERROR_STRING consolidates error output.

Tables Accessed

The package reads and writes CSI_ITEM_INSTANCES and CSI_ITEM_INSTANCES_H to maintain current and historical instance records, and CSI_TRANSACTIONS and CSI_TXN_TYPES to log and classify asset transactions. CSI_INSTANCE_STATUSES and CSI_IPA_RELATION_TYPES supply status and relationship validation. Inventory-side access includes MTL_MATERIAL_TRANSACTIONS, MTL_PARAMETERS, MTL_PHYSICAL_INVENTORIES, MTL_PHYSICAL_ADJUSTMENTS, MTL_CYCLE_COUNT_HEADERS, and MTL_CYCLE_COUNT_ENTRIES, which provide the source transaction context for physical and cycle count flows. FND_APPLICATION, FND_USER, and HR_ALL_ORGANIZATION_UNITS are referenced for application registration, user auditing, and organization validation.

Usage Notes

CSI_INV_TRXS_PKG is invoked primarily from Oracle Inventory transaction processing and from Installed Base transaction APIs when tracked items move through receipt, issue, physical count, or cycle count activities. It is referenced by 52 other packages, confirming its role as a shared integration layer rather than a standalone user-facing program. Custom code extending eAM or Installed Base behavior should call the package's MISC_RECEIPT or RECEIPT_INVENTORY procedures rather than writing directly to CSI_ITEM_INSTANCES, since the package also performs trackability checks, master organization resolution, deprecation checks, and error string construction. Because behavior varies between 12.1.1 and 12.2.2, developers should confirm the effective package version in each environment before relying on specific procedures.