Search Results rcv_shipment_headers
The RCV_SHIPMENT_HEADERS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 serves as a critical repository for recording and managing receipt-related transactions within the Purchasing and Inventory modules. This table stores high-level information about inbound shipments, acting as the parent entity for detailed receipt lines stored in RCV_SHIPMENT_LINES. Below is a detailed technical and functional analysis of this table's structure, purpose, and integration within Oracle EBS.
Table Overview
RCV_SHIPMENT_HEADERS is part of the Receiving (RCV) application tablespace in Oracle EBS. It captures metadata about shipments received from suppliers, including shipment dates, receipt methods, and associated purchase orders. The table is fundamental to the three-way matching process (PO, receipt, and invoice) in procurement workflows.Key Columns and Descriptions
- SHIPMENT_HEADER_ID: Primary key, uniquely identifying each shipment record.
- RECEIPT_NUM: User-friendly identifier for the shipment, often displayed in Receiving screens.
- VENDOR_ID: References PO_VENDORS, linking to the supplier.
- SHIP_TO_ORG_ID: Indicates the inventory organization receiving the shipment (references HR_ORGANIZATION_UNITS).
- SHIPMENT_TYPE: Classifies shipments (e.g., "STANDARD", "RETURN TO VENDOR").
- RECEIVE_DATE: Timestamp of receipt creation.
- EMPLOYEE_ID: Identifies the receiver (references PER_ALL_PEOPLE_F).
- STATUS: Tracks workflow state (e.g., "PENDING", "RECEIVED", "DELIVERED").
- WAYBILL_AIRBILL_NUM: Carrier tracking number for logistics.
- ASN_TYPE: Indicates Advance Shipment Notice (ASN) integration status.
Functional Significance
The table supports core procurement processes:- Receipt Creation: Acts as the header for receipt transactions, whether manual or via ASN.
- Three-Way Matching: Provides data for validating PO-receipt-invoice consistency.
- Inventory Integration: Shipments transition to inventory via MTL_TRANSACTIONS_INTERFACE upon delivery.
- Supplier Performance: Timestamps and statuses enable supplier lead time analysis.
Integration Points
- Purchasing: Linked to PO_HEADERS_ALL via PO_HEADER_ID.
- Inventory: SHIP_TO_ORG_ID ties to MTL_PARAMETERS.
- Payables: Receipts referenced in AP_INVOICE_LINES for matching.
- Costing: Receipt dates impact material cost calculations in CST_ITEM_COSTS.
Technical Considerations
- Indexes: Key indexes include RCV_SHIPMENT_HEADERS_U1 (on SHIPMENT_HEADER_ID) and RCV_SHIPMENT_HEADERS_N1 (on RECEIPT_NUM).
- Partitioning: In high-volume environments, partitioning by RECEIVE_DATE improves query performance.
- API Interactions: The RCV_TRANSACTIONS_PUB API manipulates this table during receipt processing.
Version-Specific Notes
Differences between 12.1.1 and 12.2.2 are minimal for this table, but 12.2.2 may include:- Enhanced ASN columns for EDI integrations.
- Additional status values for new workflow states.
- Optimized foreign key constraints for performance.
Customization Impact
Extensions often include:- Custom statuses via lookup codes (FND_LOOKUP_VALUES).
- DFFs (Descriptive Flexfields) for industry-specific attributes.
- Triggers to enforce business rules during receipt approval.
Conclusion
The RCV_SHIPMENT_HEADERS table is a linchpin in Oracle EBS' procure-to-pay cycle, ensuring accurate receipt recording and downstream processing. Its design reflects Oracle's commitment to auditability (via timestamps and status tracking) and integration across financial and supply chain modules. Proper understanding of this table is essential for troubleshooting receipt issues, designing custom reports, or extending receiving functionality.-
Table: RCV_SHIPMENT_HEADERS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_HEADERS, object_name:RCV_SHIPMENT_HEADERS, status:VALID, product: PO - Purchasing , description: Shipment and receipt header information , implementation_dba_data: PO.RCV_SHIPMENT_HEADERS ,
-
Table: RCV_SHIPMENT_HEADERS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_HEADERS, object_name:RCV_SHIPMENT_HEADERS, status:VALID, product: PO - Purchasing , description: Shipment and receipt header information , implementation_dba_data: PO.RCV_SHIPMENT_HEADERS ,
-
APPS.PO_CREATE_ASBN_INVOICE dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.PO_DELREC_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.RCV_INSPECTION_GRP dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JAI_RCV_RND_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JA_JAINMCEN_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.GMF_GMFLCHST_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JAI_AP_RPT_APCR_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.INV_MWB_QUERY_MANAGER dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.INV_RCV_RESERVATION_UTIL dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.BOM_CSTRACCR_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.INV_MGD_MVT_DATA_STR dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.FV_CROSS_DOC_REF dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.GMD_QC_LABELS_UTIL dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.RCV_FTE_CALL_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.WMS_XDOCK_PEGGING_PUB dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JA_JAIN23C1_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.INV_DIAG_RCV_PO_COMMON dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.RCV_INT_ORDER_PP_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.POS_WC_VIEW_CANCEL_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.INV_LABEL_PVT4 dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.PO_ADVANCED_PRICE_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.CLN_UPDTDLVY_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.WMS_PACKING_WORKBENCH_PVT dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.GMD_QA_RCV_PUB dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.INV_INV_LOVS dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.GMD_QA_RCV_PUB dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.POS_CANCEL_ASN dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.INV_MWB_QUERY_MANAGER dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.RCV_RMA_HEADERS dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.JA_JAIN23P2_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.CST_INVENTORY_PVT dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.RCV_TRANSACTION_PROCESSOR dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.PO_CHARGES_GRP dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.INV_DIAG_RCV_IPROC dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.GMD_OUTBOUND_APIS_PUB dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.RMA_DIAGNOSTICS dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.INV_RCV_STD_DELIVER_APIS dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.RCV_RECEIPT_CONFIRMATION dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.AP_IMPORT_UTILITIES_PKG dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.RCV_VALIDATE_PO dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.INV_RCV_STD_TRANSFER_APIS dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on RCV_SHIPMENT_HEADERS
12.2.2