Search Results mtl_txn_rec

Overview

CSI_RMA_RECEIPT_PUB is a public PL/SQL API within the Oracle E-Business Suite (EBS) Customer Service Intelligence (CSI) module, shipped in the APPS schema. Its principal business function is to process and validate Return Material Authorization (RMA) receipts against inventory material transactions, specifically in the context of item instance tracking and installed base management. When a customer returns goods under an RMA, the receiving organization must create the corresponding inventory transaction while simultaneously updating the associated item instance records that CSI maintains for the installed base. This package bridges the Oracle Order Management RMA flow and the CSI repository of customer product instances.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which is consistent with standard EBS public API conventions. It carries the header revision 120.1.12020000.2 dated 2012/12/05, indicating it was certified for the 12.1.1 and 12.2.2 release lines. It defines a public record type, mtl_txn_rec, which encapsulates the attributes of an inventory material transaction — including transaction ID, order line ID, inventory item, organization, revision, subinventory, locator, lot and serial numbers, quantities, UOM, transaction date, transaction type, and party/customer identifiers — initialised to FND_API.G_MISS_* sentinels for change-detection semantics.

Key Procedures and Functions

The documented package exposes five procedures and functions:

• GET_RMA_INFO — Retrieves RMA and inventory material transaction information for a given receipt context, populating the mtl_txn_rec structure and related data used by downstream processing.
• GET_SUB_TYPE_REC — Derives the transaction sub-type record required to classify the RMA receipt, drawing on the configured CSI source transaction type definitions.
• DECODE_MESSAGE — Translates internal message codes or error tokens into user-readable text, following the standard EBS API message-decoding pattern.
• RMA_RECEIPT — The core public entry point. It performs the RMA receipt processing, creating or reconciling the material transaction and updating the associated CSI item instance and transaction line records.
• CHECK_AND_BREAK_RELATION — Validates and, where required, severs the relationship between an item instance and its prior transaction line, ensuring referential integrity in the installed base when goods are returned.

Tables Accessed

The package reads and writes several CSI and inventory tables through APPS synonyms:

• CSI_ITEM_INSTANCES, CSI_T_TRANSACTION_LINES, CSI_T_TXN_LINE_DETAILS — the installed base instance and transaction tracking tables that record the return movement.
• CSI_I_PARTIES, CSI_IP_ACCOUNTS, CSI_SOURCE_IB_TYPES — party, account, and source-type definitions governing instance ownership and classification.
• MTL_MATERIAL_TRANSACTIONS, MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B — inventory transaction creation, organization defaults, subinventory validation, and item attributes.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HR_ALL_ORGANIZATION_UNITS — customer account, site, and organization validation.

Usage Notes

CSI_RMA_RECEIPT_PUB is typically invoked from Oracle Order Management and Inventory receiving flows when an RMA is received, and is referenced by at least one other package within the EBS code base. Custom extensions and integrations that need to register or reconcile returned goods against the installed base should call the RMA_RECEIPT procedure after populating the mtl_txn_rec structure. Callers should observe standard EBS API conventions: initialise attributes to FND_API.G_MISS_*, handle the DECODE_MESSAGE output for error reporting, and invoke the API within a properly managed transaction boundary. Because the package runs under AUTHID CURRENT_USER, appropriate grants must exist for the invoking schema.