Search Results inv_rcv_txn_interface
Overview
INV_RCV_TXN_INTERFACE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the receiving transaction interface and matching logic used during the inbound receipt and delivery cycle. In Oracle EBS 12.1.1 and 12.2.2, receipt processing flows through the RCV open interface before records are validated and transferred into the base receiving tables. INV_RCV_TXN_INTERFACE provides a shared entry point for that validation and matching activity, enabling standard receiving APIs and concurrent processes to apply consistent business rules when interpreting receipt transactions that arrive through the interface.
Based on associated metadata, the package is classified as an OTHER-type API and exposes a single documented procedure, MATCHING_LOGIC. It is also referenced by several other packages, including INV_RCV_DIR_RCPT_APIS (direct receipt), INV_RCV_STD_DELIVER_APIS (standard delivery), INV_RCV_STD_RCPT_APIS (standard receipt), INV_RCV_TXN_MATCH, and, recursively, INV_RCV_TXN_INTERFACE itself. This dependency pattern confirms its role as a common utility underpinning the receiving API stack rather than a standalone user-facing program.
Key Procedures and Functions
- MATCHING_LOGIC — The sole documented program unit in this package. Its purpose is to perform the matching and validation logic required when processing receiving transactions at the interface stage, so that receipt lines can be reconciled against expected supply and downstream processing can proceed. The metadata does not expose parameter lists for this procedure, and no parameter detail is asserted here.
No additional procedures or functions are documented for this object. The package depends on INV_RCV_COMMON_APIS and the SYS.STANDARD package, indicating that it leverages shared receiving utilities and standard PL/SQL constructs.
Tables Accessed
Documented table references (accessed through APPS synonyms) include:
- RCV_TRANSACTIONS_INTERFACE and RCV_TRANSACTIONS — the interface and base receiving transaction tables central to inbound receipt processing.
- RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES — shipment-level receipt context.
- RCV_SUPPLY, RCV_LOTS_SUPPLY and MTL_LOT_NUMBERS — supply and lot information matched during validation, including lot-controlled receipts.
- PO_LINE_LOCATIONS and PO_LINE_LOCATIONS_ALL — purchasing document schedule detail used to match receipt lines to expected supply.
- RCV_PARAMETERS and MTL_PARAMETERS — organization-level receiving and inventory control settings that drive logic branching.
- MTL_CLIENT_PARAMETERS — client-level configuration affecting processing behavior.
- WMS_LPN_CONTENTS — license plate number contents relevant to warehouse-managed receipts.
- PLITBLM — a PL/SQL table used internally, typically for in-memory processing or bulk collection.
Usage Notes
INV_RCV_TXN_INTERFACE is typically invoked indirectly rather than called directly by end users. Standard receiving packages such as INV_RCV_STD_RCPT_APIS, INV_RCV_STD_DELIVER_APIS, and INV_RCV_DIR_RCPT_APIS reference it while processing transactions, meaning it is exercised whenever receipts are entered through the Receiving forms, processed by the Receiving Transaction Processor concurrent program, or submitted through standard APIs. Custom extensions that call these receiving APIs may therefore trigger INV_RCV_TXN_INTERFACE transitively. Direct invocation should be avoided; developers should instead rely on the documented parent APIs. Customizations should be validated against both 12.1.1 and 12.2.2, as online patching and code line differences in 12.2.2 may alter the package body even though the object name and ownership remain APPS.
-
PACKAGE: APPS.INV_RCV_TXN_INTERFACE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_TXN_INTERFACE, status:VALID,
-
PACKAGE: APPS.INV_RCV_TXN_INTERFACE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_TXN_INTERFACE, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_TXN_INTERFACE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_TXN_INTERFACE, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_TXN_INTERFACE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_TXN_INTERFACE, status:VALID,
-
PACKAGE: APPS.INV_RCV_TXN_INTERFACE
12.1.1
-
PACKAGE: APPS.INV_RCV_TXN_INTERFACE
12.2.2
-
PACKAGE: APPS.INV_RCV_COMMON_APIS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_COMMON_APIS, status:VALID,
-
PACKAGE: APPS.INV_RCV_COMMON_APIS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_COMMON_APIS, status:VALID,
-
PACKAGE: APPS.RCV_TRANSACTIONS_INTERFACE_SV
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_TRANSACTIONS_INTERFACE_SV, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_TXN_MATCH
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_TXN_MATCH, status:VALID,
-
SYNONYM: APPS.RCV_LOTS_SUPPLY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_LOTS_SUPPLY, status:VALID,
-
SYNONYM: APPS.MTL_CLIENT_PARAMETERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:MTL_CLIENT_PARAMETERS, status:VALID,
-
PACKAGE: APPS.RCV_TRANSACTIONS_INTERFACE_SV
12.1.1
owner:APPS, object_type:PACKAGE, object_name:RCV_TRANSACTIONS_INTERFACE_SV, status:VALID,
-
SYNONYM: APPS.RCV_LOTS_SUPPLY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_LOTS_SUPPLY, status:VALID,
-
SYNONYM: APPS.RCV_SUPPLY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SUPPLY, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_TXN_MATCH
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_TXN_MATCH, status:VALID,
-
PACKAGE: APPS.RCV_QUANTITIES_S
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_QUANTITIES_S, status:VALID,
-
PACKAGE: APPS.RCV_QUANTITIES_S
12.1.1
owner:APPS, object_type:PACKAGE, object_name:RCV_QUANTITIES_S, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_DIR_RCPT_APIS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_DIR_RCPT_APIS, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_DIR_RCPT_APIS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_DIR_RCPT_APIS, status:VALID,
-
PACKAGE: APPS.PO_CLM_INTG_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CLM_INTG_GRP, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_STD_DELIVER_APIS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_STD_DELIVER_APIS, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_STD_DELIVER_APIS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_STD_DELIVER_APIS, status:VALID,
-
SYNONYM: APPS.RCV_SUPPLY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SUPPLY, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_STD_RCPT_APIS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_STD_RCPT_APIS, status:VALID,
-
PACKAGE BODY: APPS.INV_RCV_STD_RCPT_APIS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_STD_RCPT_APIS, status:VALID,
-
SYNONYM: APPS.WMS_LPN_CONTENTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:WMS_LPN_CONTENTS, status:VALID,
-
PACKAGE: APPS.WMS_DEPLOY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_DEPLOY, status:VALID,
-
SYNONYM: APPS.RCV_PARAMETERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_PARAMETERS, status:VALID,
-
SYNONYM: APPS.WMS_LPN_CONTENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:WMS_LPN_CONTENTS, status:VALID,
-
SYNONYM: APPS.RCV_PARAMETERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_PARAMETERS, status:VALID,
-
PACKAGE: APPS.INV_MOBILE_HELPER_FUNCTIONS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_MOBILE_HELPER_FUNCTIONS, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.INV_MOBILE_HELPER_FUNCTIONS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_MOBILE_HELPER_FUNCTIONS, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
SYNONYM: APPS.PO_DISTRIBUTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_DISTRIBUTIONS, status:VALID,
-
SYNONYM: APPS.PO_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_LINES, status:VALID,
-
VIEW: APPS.PO_DISTRIBUTIONS_TRX_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_DISTRIBUTIONS_TRX_V, object_name:PO_DISTRIBUTIONS_TRX_V, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS_INTERFACE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS_INTERFACE
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID,
-
SYNONYM: APPS.PO_LINE_LOCATIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_LINE_LOCATIONS, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_HEADERS, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_HEADERS, status:VALID,
-
VIEW: APPS.PO_LINE_LOCATIONS_TRX_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINE_LOCATIONS_TRX_V, object_name:PO_LINE_LOCATIONS_TRX_V, status:VALID,
-
SYNONYM: APPS.PO_LINE_LOCATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_LINE_LOCATIONS, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_LINES, status:VALID,
-
SYNONYM: APPS.MTL_LOT_NUMBERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:MTL_LOT_NUMBERS, status:VALID,
-
VIEW: APPS.PO_LINES_TRX_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINES_TRX_V, object_name:PO_LINES_TRX_V, status:VALID,