Search Results process_rma_transaction

Overview

INV_MGD_MVT_STATS_PROC is an APPS-owned PL/SQL package in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that supports the Oracle Inventory Movement Statistics feature, an optional capability used to capture and report detailed physical movement of material for statistical, regulatory, and customs reporting purposes. In inventory organizations where movement statistics are enabled, every relevant material transaction — issues, receipts, transfers, and returns — must be recorded not only in the core transaction tables but also in the movement statistics interface and staging structures. This package encapsulates the business logic that transforms raw transaction records into movement statistics entries.

The package operates on data staged in INV_MGD_MVT_DATA_STR, a transient data structure populated by the movement statistics concurrent processing framework. Because the package is referenced by INV_MGD_MVT_CONC_PGM (the concurrent program) and INV_MGD_MVT_STATS_PUB (the public API wrapper), it functions as the internal processing engine of the movement statistics subsystem. Its status is VALID, confirming it is a supported, compiled database object rather than a deprecated or invalid artifact.

Key Procedures and Functions

The documented package interface exposes twelve procedures and functions, classified generically as OTHER. Their responsibilities are organized around transaction processing and reconciliation:

• PROCESS_TRANSACTION — the primary driver routine; evaluates a staged transaction record and dispatches it to the appropriate type-specific handler.
• PROCESS_INV_TRANSACTION — handles inventory-originated movements such as subinventory transfers and miscellaneous issues and receipts.
• PROCESS_SO_TRANSACTION — processes sales order shipments and related outbound movements.
• PROCESS_PO_TRANSACTION — processes purchase order receipts and corrections affecting inbound statistics.
• PROCESS_RMA_TRANSACTION and PROCESS_RMA_TRIANGULATION — govern customer return flows, with the triangulation routines resolving multi-leg movements to the correct statistical destination.
• PROCESS_TRIANGULATION_TXN — general triangulation logic for indirect or multi-hop movement chains.
• PROCESS_IO_ARRIVAL_TXN — records arrival events for internal order (IO) movements between organizations.
• PROCESS_PENDING_TRANSACTION — re-evaluates transactions staged but not yet fully processable, so they are not lost.
• UPDATE_INVOICE_INFO — enriches movement statistics records with invoice or customs-relevant information.
• UPDATE_PO_WITH_CORRECTION — applies corrections to purchase order movement statistics when original receipts are adjusted.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• MTL_MATERIAL_TRANSACTIONS and MTL_MOVEMENT_STATISTICS — the source transaction detail and the target statistics records respectively; these are the core of the processing logic.
• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and OE_DROP_SHIP_SOURCES — supply sales order and drop-ship context for outbound statistics.
• PO_HEADERS_ALL and PO_REQUISITION_HEADERS_ALL — provide purchasing document context for inbound movements.
• RCV_SHIPMENT_LINES and RCV_TRANSACTIONS — supply receiving details used to derive receipt-based movements.
• HZ_CUST_SITE_USES_ALL — resolves ship-to and customer site information for outbound statistics.

Usage Notes

This package is not intended for direct ad hoc invocation. It is called internally by the Movement Statistics concurrent program (INV_MGD_MVT_CONC_PGM) and by INV_MGD_MVT_STATS_PUB, which serves as the public entry point. The package also references itself recursively, reflecting its routine-by-routine dispatch design. Customers extending movement statistics should call INV_MGD_MVT_STATS_PUB rather than this package directly, since the public package isolates callers from internal restructuring and holds the supported API contract. Custom code that bypasses the public wrapper risks incompatibility during patching or upgrades between 12.1.1 and 12.2.2.