Search Results rcv_transactions
The RCV_TRANSACTIONS
table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for receiving transaction data, capturing all activities related to the receipt of goods and services. It serves as the backbone for the Receiving module, interfacing with Purchasing, Inventory, and Payables to ensure accurate tracking of material inflows. Below is a detailed breakdown of its structure, functionality, and integration within Oracle EBS.
1. Purpose and Key Functionality
The RCV_TRANSACTIONS
table stores records for every receiving transaction, including:
- Standard Receipts: Records of goods received against purchase orders.
- Returns to Vendor: Transactions for rejected or excess materials sent back.
- Corrections: Adjustments to quantities or attributes post-receipt.
- Miscellaneous Receipts: Non-PO-based receipts (e.g., free samples).
Each transaction is tied to a PO_HEADER_ID
, PO_LINE_ID
, and SHIPMENT_HEADER_ID
, ensuring traceability to the source document.
2. Table Structure and Key Columns
The table's schema includes columns critical for processing and auditing:
- TRANSACTION_ID: Primary key, uniquely identifying each transaction.
- TRANSACTION_TYPE: Values like 'RECEIVE', 'RETURN TO VENDOR', or 'CORRECT'.
- QUANTITY: Received/returned quantity, with UOM (
UNIT_OF_MEASURE
). - ITEM_ID: Links to
MTL_SYSTEM_ITEMS
for item details. - DESTINATION_TYPE_CODE: Determines routing (e.g., 'INVENTORY', 'EXPENSE').
- CREATION_DATE/LAST_UPDATE_DATE: Timestamps for audit trails.
- STATUS: Current state (e.g., 'PENDING', 'PROCESSED', 'ERROR').
3. Integration with Other Modules
The table interacts with multiple Oracle EBS modules:
- Purchasing: References
PO_HEADERS_ALL
andPO_LINES_ALL
for PO validation. - Inventory: Updates
MTL_ONHAND_QUANTITIES
upon receipt into stock. - Payables: Feeds matched receipts to
AP_INVOICE_LINES
for invoice validation. - General Ledger: Posts accounting entries via
RCV_ACCOUNTING_EVENTS
.
4. Workflow and Processing Logic
Transactions follow a lifecycle:
- Creation: Entered via Receiving screens or APIs (e.g.,
RCV_TRX_API
). - Validation: Checks against PO terms, item master, and receiving controls.
- Processing: Updates inventory (if applicable) and triggers accounting events.
- Interface to Payables: Matches receipts to invoices for three-way matching.
5. Customization and Extensions
Common enhancements include:
- Triggers/APEX: Adding validations or notifications via database triggers.
- API Extensions: Custom integrations using
RCV_TRANSACTION_INTERFACE
. - Reporting: Joining with
RCV_SHIPMENT_HEADERS/LINES
for analytics.
6. Performance Considerations
Large transaction volumes may necessitate:
- Indexing on
PO_HEADER_ID
,SHIPMENT_HEADER_ID
, andITEM_ID
. - Partitioning by
CREATION_DATE
for archival. - Optimizing queries with hints in custom reports.
Conclusion
The RCV_TRANSACTIONS
table is pivotal in Oracle EBS's procure-to-pay cycle, ensuring accurate receipt recording and downstream integration. Its design supports scalability, auditability, and compliance, making it indispensable for inventory and financial controls. Understanding its structure and relationships is essential for troubleshooting, customization, and performance tuning in implementations.
-
Table: RCV_TRANSACTIONS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS, object_name:RCV_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving transactions , implementation_dba_data: PO.RCV_TRANSACTIONS ,
-
Table: RCV_TRANSACTIONS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS, object_name:RCV_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving transactions , implementation_dba_data: PO.RCV_TRANSACTIONS ,
-
APPS.JAI_JRG_23AC2_TRIGGER_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.OE_INVOICE_PUB dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INV_LABEL_PVT4 dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_SLA_MRC_UPDATE_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.PA_WORK_TYPE_UPGRADE dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.WMS_ATF_UTIL_APIS dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.PO_ACTIONS dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.BOM_CSTRACCR_XMLP_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INV_LPN_TRX_PUB dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INL_SHIPMENT_PVT dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INV_COST_GROUP_PVT dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INV_LOT_API_PUB dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.AP_MATCHING_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INV_RCV_STD_TRANSFER_APIS dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.OE_LINE_UTIL dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSTPALPC dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_RND_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSTPAPPR dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.PO_LOCATIONS_S dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_UTILS_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_ROI_TRANSACTION dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_ROI_RETURN dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.WMS_CROSS_DOCK_PVT dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_FTE_CALL_PVT dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CST_INVENTORY_PVT dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_TRANSACTION_PROCESSOR dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_PERSON dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_AP_RPT_PRRG_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_TAX_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_JOURNAL_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_JRG_PLA_TRIGGER_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.INV_INVSTMVT_XMLP_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.RCV_EXPRESS_SV dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.OE_UPG_SO dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSE_RCVTXN_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JA_JAINVATR_XMLP_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_AP_RPT_APCR_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.FV_SLA_PROCESSING_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.AP_MATCHING_UTILS_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSTPPINV dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSI_UTILITY_GRP dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.GMF_RCV_ACCOUNTING_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.CSTPACDP dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_AP_MATCH_TAX_PKG dependencies on RCV_TRANSACTIONS
12.1.1