Results for “parent_transaction_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
RCV_UNPROCESSED_LOT_ISSUES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, first introduced in release 8.0 and still valid in EBS 12.1.1 and 12.2.2. It belongs to the PO - Purchasing product family and is catalogued in the E-Business Suite Technical Reference Manual (ETRM) with the status VALID. As its name implies, the view exists to surface receiving lot records that remain in the open interface tables and therefore represent unprocessed lot issues. It is not a master data entity; rather it is a diagnostic and reconciliation reporting construct that aggregates pending lot-level receiving activity before the Receiving Transaction Processor (RTP) or the Receiving Open Interface has consumed those rows into permanent inventory and receiving transaction tables.
The view is registered against the RCV_LOTS_INTERFACE and RCV_TRANSACTIONS_INTERFACE interface tables, which are the staging ground for the Receiving Open Interface (ROI). By reporting on data that has not yet been processed, RCV_UNPROCESSED_LOT_ISSUES_V gives supply chain and technical users a window into stuck, failed, or pending receiving transactions at lot granularity. In integration scenarios, particularly where third-party systems or external feeders insert rows into the receiving interface tables, this view is frequently used to monitor queue depth and identify rows that did not reach the processor.
Underlying Base Objects
The ETRM metadata documents two referenced base objects, both exposed to the view as synonyms:
- RCV_LOTS_INTERFACE (SYNONYM) — alias RLI in the view text; holds lot-level detail for receiving interface transactions.
- RCV_TRANSACTIONS_INTERFACE (SYNONYM) — alias RTI in the view text; holds the header/transaction-type context for each interface transaction.
The two are joined on the shared INTERFACE_TRANSACTION_ID column, which is the logical key linking a lot record to its parent receiving transaction. Because the definition joins the lot interface to the transaction interface, the view can derive net quantities from the transaction type recorded on RTI. The output is grouped by LOT_NUM, ITEM_ID, SHIPMENT_LINE_ID, and PARENT_TRANSACTION_ID, producing one aggregated row per lot-item-shipment-parent combination. This makes the view a consolidated, transaction-flattened representation of otherwise row-level interface data.
Key Columns
The ETRM lists six columns for this view:
- LOT_NUM — the lot number carried on the interface lot record; the primary identifying attribute for the unprocessed issue.
- ITEM_ID — inventory item identifier for the lot being received or returned.
- SHIPMENT_LINE_ID — the shipment line on which the lot is being received; links the issue to the originating purchase order line or shipment.
- PARENT_TRANSACTION_ID — reference to the parent receiving transaction, used to group related interface rows back to a single logical transaction.
- PRIMARY_QUANTITY — aggregated primary-unit quantity, computed with DECODE logic so that DELIVER, CORRECT, and RECEIVE add quantity, while RETURN TO RECEIVING and RETURN TO VENDOR subtract it. CORRECT uses SIGN(PRIMARY_QUANTITY) to honour the direction of the correction.
- QUANTITY — the aggregated secondary-unit quantity, computed with the same DECODE and SIGN logic applied to the QUANTITY column instead of PRIMARY_QUANTITY.
Common Use Cases and Queries
Typical uses include monitoring the Receiving Open Interface for lot receipts that have not yet been processed, investigating why a particular lot is not available in inventory, and validating data feeds from external systems. A basic query listing pending lot issues is:
SELECT lot_num, item_id, shipment_line_id, parent_transaction_id, primary_quantity, quantity FROM apps.rcv_unprocessed_lot_issues_v ORDER BY lot_num;
To focus on a single item, constrain by ITEM_ID; to investigate a specific receipt, constrain by SHIPMENT_LINE_ID or PARENT_TRANSACTION_ID. Because the view aggregates across transaction types, rows with a net zero PRIMARY_QUANTITY indicate that receipts and returns have cancelled out at lot level, a useful signal when reconciling interface exceptions. Users should remember that the view reads only the interface tables; once the Receiving Transaction Processor clears those rows, the records disappear from this view and become visible through standard receiving and inventory inquiry screens instead.
-
New in version 8.0
APPS.RCV_UNPROCESSED_LOT_ISSUES_V·↳ RCV_LOTS_INTERFACE·↳ RCV_TRANSACTIONS_INTERFACE·Explore PO module →
-
Table: CST_LC_RCV_TXN_GT 12.1.1
-
Table: CST_LC_RCV_TXN_GT 12.2.2
-
Stores the parent transaction identifier for the return to vendor transaction
-
Contains information regarding bond transactions like bond amount etc.
-
RTV Batch Transactions
-
Child table to MSC_SUPPLIES storing pre-allocated supplies. Used during ATP post plan processing
-
Child table to MSC_SUPPLIES storing pre-allocated supplies. Used during ATP post plan processing
-
View: PQH_TRANSACTIONS_V 12.1.1
APPS.PQH_TRANSACTIONS_V·↳ HR_GENERAL·↳ PQH_POSITION_TRANSACTIONS·↳ PQH_TRANSACTION_CATEGORIES·Explore PQH module →
-
New in version 8.0
APPS.RCV_UNPROCESSED_LOT_ISSUES_V·↳ RCV_LOTS_INTERFACE·↳ RCV_TRANSACTIONS_INTERFACE·Explore PO module →
-
View: RCV_FTE_TRANSACTIONS_V 12.1.1
Rolled up transactions for logistics
APPS.RCV_FTE_TRANSACTIONS_V·↳ MTL_UNITS_OF_MEASURE·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: PQH_TRANSACTIONS_V 12.2.2
APPS.PQH_TRANSACTIONS_V·↳ HR_GENERAL·↳ PQH_POSITION_TRANSACTIONS·↳ PQH_TRANSACTION_CATEGORIES·Explore PQH module →
-
Table: MSC_ALLOC_SUPPLIES 12.2.2
-
Stores the parent transaction identifier for the return to vendor transaction
-
MTL_CONSUMPTION_TRANSACTIONS contains information related to the change of ownership transactions that have occurred to your consigned inventory. The table is used by the "Create Consumption Advice" concurrent program. Each consumption adv
-
This table stores transactions with TCS type of Tax. This is a TCS repository
-
View: JAI_RCV_RTV_LINES_V 12.2.2
APPS.JAI_RCV_RTV_LINES_V·↳ JAI_RCV_TRANSACTIONS·↳ RCV_SHIPMENT_LINES·↳ RCV_TRANSACTIONS·Explore JA module →
-
Kiosk processes in progress
-
MTL_CONSUMPTION_TRANSACTIONS contains information related to the change of ownership transactions that have occurred to your consigned inventory. The table is used by the "Create Consumption Advice" concurrent program. Each consumption adv
-
APPS.RCV_RECEIPT_CONFIRMATION_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HR_EMPLOYEES·Explore INV module →
-
electronic record view for receiving transaction integration
APPS.QA_ERES_RCV_TRANS_INTERFACE_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CUSTOMER_ITEMS·Explore QA module →
-
RTV Batch Transactions
-
Contains information regarding bond transactions like bond amount etc.
-
View: CST_INV_DISTRIBUTION_V 12.1.1
Material transaction distribution information : SINGLE-ORG view
APPS.CST_INV_DISTRIBUTION_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore BOM module →
-
View: ICX_RCV_TRANSACTIONS_V 12.2.2
Receipt Lines View
APPS.ICX_RCV_TRANSACTIONS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
View: CST_XLA_RCV_REF_V 12.2.2
APPS.CST_XLA_RCV_REF_V·↳ PO_HEADERS_ALL·↳ RCV_ACCOUNTING_EVENTS·↳ RCV_RECEIVING_SUB_LEDGER·Explore BOM module →
-
- Retrofitted
APPS.POBV_RECEIVING_TRANSACTIONS·↳ MTL_TRANSACTION_REASONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: POS_RCV_RETURNS_V 12.2.2
Displays Returns for Shipments
APPS.POS_RCV_RETURNS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore POS module →
-
Holds receiving transaction records information.
-
View: RCV_MUR_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_MUR_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
View: RCV_FTE_TRANSACTIONS_V 12.2.2
Rolled up transactions for logistics
APPS.RCV_FTE_TRANSACTIONS_V·↳ MTL_UNITS_OF_MEASURE·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: JAI_RCV_RTV_LINES_V 12.1.1
APPS.JAI_RCV_RTV_LINES_V·↳ JAI_RCV_TRANSACTIONS·↳ RCV_SHIPMENT_LINES·↳ RCV_TRANSACTIONS·Explore JA module →
-
View: POS_RCV_TRANSACTIONS_V 12.2.2
APPS.POS_RCV_TRANSACTIONS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: POS_RCV_RETURNS_V 12.1.1
APPS.POS_RCV_RETURNS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PO module →
-
History Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed
-
Archive Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed
-
Archive Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed
-
View: ICX_RCV_RETURNS_V 12.1.1
Returned Item Receipts View
APPS.ICX_RCV_RETURNS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_PROFILE·↳ HR_EMPLOYEES·Explore ICX module →
-
Table: MSC_ALLOC_SUPPLIES 12.1.1
-
View: RCV_MUR_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_MUR_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
View: CST_XLA_INV_REF_V 12.2.2
APPS.CST_XLA_INV_REF_V·↳ CST_COGS_EVENTS·↳ MTL_MATERIAL_TRANSACTIONS·↳ MTL_TRANSACTION_ACCOUNTS·Explore BOM module →
-
APPS.POS_RCV_EARLY_LATE_RECEIPTS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
View: POS_RCV_TRANSACTIONS_V 12.2.2
Displays Receiving Transactions
APPS.POS_RCV_TRANSACTIONS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore POS module →
-
This table stores transactions with TCS type of Tax. This is a TCS repository
-
Kiosk processes in progress
-
- Retrofitted
APPS.POFV_RECEIVING_TRANSACTIONS·↳ AP_INVOICES_ALL·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·Explore PO module →
-
View: RCV_OPSM_LINE_V 12.2.2
APPS.RCV_OPSM_LINE_V·↳ FND_LANGUAGES·↳ MTL_CROSS_REFERENCES_VL·↳ MTL_PARAMETERS·Explore PO module →
-
Obsolete
APPS.ICX_RCV_ACCEPTED_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
APPS.POS_RCV_REJECTED_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_GENERAL·Explore PO module →