Search Results jai_cmn_rg_round_lines




Overview
Explore in AI Chat

Overview

The RCV_SHIPMENT_LINES table is a core transactional entity within the Oracle E-Business Suite Purchasing (PO) module, specifically for versions 12.1.1 and 12.2.2. It stores detailed line-level information for every receipt against a purchase order, blanket release, or requisition. This table is fundamental to the receiving process, recording the quantity, location, and accounting details for each received item or service. It serves as the primary link between the purchasing documents and subsequent inventory transactions, cost accounting, and invoice matching processes in Payables (AP).

Key Information Stored

The table's primary key is SHIPMENT_LINE_ID, with a unique key also defined on the combination of SHIPMENT_HEADER_ID and LINE_NUM. Its columns capture the complete lifecycle of a received line. Key data points include quantities (QUANTITY, QUANTITY_SHIPPED, QUANTITY_RECEIVED, QUANTITY_DELIVERED), unit of measure, and destination details (TO_ORGANIZATION_ID, TO_SUBINVENTORY, LOCATOR_ID). Critical foreign key columns link the receipt line to its source document, such as PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, and PO_DISTRIBUTION_ID for standard orders, or PO_RELEASE_ID for blanket releases. For accounting, columns like CHARGE_ACCOUNT_ID and TRANSPORTATION_ACCOUNT_ID reference GL_CODE_COMBINATIONS. The table also tracks the receiving routing (ROUTING_HEADER_ID) and categorization (CATEGORY_ID) of the received item.

Common Use Cases and Queries

This table is central to reporting on receipt history, reconciling received quantities to invoiced amounts, and troubleshooting receiving transactions. A common query retrieves all receipt lines for a specific purchase order to analyze receipt performance. Another frequent use case is identifying receipts pending delivery to inventory or those that have been received but not yet invoiced, which is crucial for period-end accruals. Developers often join this table with RCV_SHIPMENT_HEADERS for header data and PO_HEADERS_ALL or PO_LINES_ALL for purchasing document details. Sample SQL to find receipt details for a PO line would involve filtering on PO_HEADER_ID and PO_LINE_ID.

Related Objects

As indicated by the foreign key relationships, RCV_SHIPMENT_LINES has extensive integration across EBS. It is a child of RCV_SHIPMENT_HEADERS. Its primary relationships are with Purchasing tables: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_RELEASES_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL. For accounting, it links to GL_CODE_COMBINATIONS. It is referenced by AP_INVOICE_LINES_ALL for invoice matching. The table is also integral to several inventory and tax-related objects in localized solutions, such as JAI_MTL_MATCH_RECEIPTS and JAI_AP_MATCH_INV_TAXES, highlighting its role in cost and tax settlement.