Search Results rcv_shipment_lines
The RCV_SHIPMENT_LINES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for receiving transaction data, capturing detailed information about items received against purchase orders, requisitions, or other sourcing documents. As part of the Oracle Purchasing and Inventory modules, this table serves as a transactional backbone for receiving operations, interfacing with key supply chain processes such as procurement, inventory management, and accounts payable.
Table Structure and Key Columns
The RCV_SHIPMENT_LINES table contains columns that track receipt line details, including:- SHIPMENT_LINE_ID: Primary key identifier for each receipt line.
- SHIPMENT_HEADER_ID: Foreign key linking to RCV_SHIPMENT_HEADERS, associating lines with their parent receipt document.
- PO_HEADER_ID and PO_LINE_ID: References to the purchase order and line being received.
- ITEM_ID: Links to MTL_SYSTEM_ITEMS_B for item master data.
- QUANTITY_SHIPPED, QUANTITY_RECEIVED, and QUANTITY_ACCEPTED: Tracks receipt progress against ordered quantities.
- UOM_CODE: Unit of measure for the received item.
- DESTINATION_TYPE_CODE: Determines whether items are received into inventory ('INVENTORY'), expense accounts ('EXPENSE'), or other destinations.
- TO_ORGANIZATION_ID: Target inventory organization for stock items.
Integration Points
The table integrates with multiple EBS modules:- Purchasing: Validates receipts against purchase order terms via PO_DISTRIBUTIONS_ALL.
- Inventory: Generates material transactions through MTL_MATERIAL_TRANSACTIONS when items are delivered to stock.
- Accounts Payable: Provides matched receipt data for invoice validation via AP_INVOICE_LINES.
- General Ledger: Posts accounting entries through GL_INTERFACE for expense destinations.
Business Process Flow
- Receipt Creation: Records are inserted into RCV_SHIPMENT_LINES when users initiate receipts in the "Receiving Transactions" form or via automated interfaces.
- Quantity Updates: As goods move through inspection (accept/reject), the QUANTITY_ACCEPTED field is updated, triggering potential quality holds.
- Delivery: For inventory destinations, delivery creates on-hand balances and cost distributions.
- Interface to AP: The RCV_TRANSACTIONS table (child of RCV_SHIPMENT_LINES) provides three-way matching data.
Technical Considerations
- Indexing: Critical for performance on columns like SHIPMENT_HEADER_ID, PO_LINE_ID, and ITEM_ID.
- Purge Requirements: Data grows rapidly; Oracle provides the PURGE_RECEIVING_DATA API for archiving.
- Custom Extensions: Common extension points include custom validations via database triggers or workflow integrations.
Version-Specific Notes
In EBS 12.2.2, enhancements include:- Improved LOB storage for attachment data.
- Integration with Oracle Fusion Procurement cloud services via SOAP APIs.
- Additional columns for landed cost management in advanced procurement deployments.
-
Table: RCV_SHIPMENT_LINES
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_LINES, object_name:RCV_SHIPMENT_LINES, status:VALID, product: PO - Purchasing , description: Receiving shipment line information , implementation_dba_data: PO.RCV_SHIPMENT_LINES ,
-
Table: RCV_SHIPMENT_LINES
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_LINES, object_name:RCV_SHIPMENT_LINES, status:VALID, product: PO - Purchasing , description: Receiving shipment line information , implementation_dba_data: PO.RCV_SHIPMENT_LINES ,
-
APPS.POA_EDW_RCV_TXNS_F_C dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.AP_ETAX_SERVICES_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.GML_RCV_TXN_INTERFACE dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_QUANTITIES_S dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_ASN_TRX_INSERT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_RCV_INTEGRATION_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.GMD_QA_RCV_PUB dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.MRP_SOURCING_API_PK dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.CTO_WORKBENCH_UTIL_PK dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_824_SV dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.GML_RCV_DIR_RCPT_APIS dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_MGD_MVT_DATA_STR dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.PO_ADVANCED_PRICE_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_DEFAULT_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.POS_CANCEL_ASN dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.PO_GML_DB_COMMON dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.POS_ASN_NOTIF dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INL_CHARGE_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_MGD_MVT_STATS_PROC dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.WMS_PLAN_TASKS_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.AP_MATCHING_UTILS_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.CSP_PICK_UTILS dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_AP_PURGE_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.WSH_IB_UI_RECON_GRP dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_COST_GROUP_PVT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_DIAG_RCV_IOT dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.GMD_QC_ERES_UTILS dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.CHV_INQ_SV2 dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.INV_UI_ITEM_LOVS dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.CHV_CUM_PERIODS_S1 dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.JAI_MTL_TRXS_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_CORE_S dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.AP_AUTO_DM_CREATION_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.RCV_TRANSACTION_PROCESSOR dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.JAI_AP_UTILS_PKG dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.RCV_QUANTITIES_S dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.CSP_PICK_UTILS dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.RCV_RECEIPT_CONFIRMATION dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.POS_WC_CREATE_UPDATE_PVT dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.INV_UI_RCV_LOVS dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.CSTPACDP dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.JAI_AP_MATCH_TAX_PKG dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.JAI_PO_OSP_PKG dependencies on RCV_SHIPMENT_LINES
12.2.2