Search Results jai_rcv_lines

Overview

The JAI_RCV_LINES table is a core localization data object within Oracle E-Business Suite 12.1.1 and 12.2.2. It is owned by the JA (Asia/Pacific Localizations) product module and is designed to store country-specific transactional information related to receipt lines. Its primary role is to extend the standard receiving functionality of Oracle Inventory and Purchasing (RCV_SHIPMENT_LINES, RCV_TRANSACTIONS) to meet unique legal and business reporting requirements mandated in various Asia/Pacific jurisdictions. The table acts as a child to standard EBS transaction tables, ensuring localization data is tightly coupled with the core receipt lifecycle.

Key Information Stored

The table's structure centers on linking localization data to specific receiving transactions and their source documents. Its primary and unique keys highlight this critical relationship. The primary key (JAI_RCV_LINES_PK) is SHIPMENT_LINE_ID, anchoring the data to a specific received line. A unique key (JAI_RCV_LINES_UK1) on TRANSACTION_ID further enforces a one-to-one relationship with individual receipt transactions. Key foreign key columns define its integration points: SHIPMENT_HEADER_ID links to RCV_SHIPMENT_HEADERS, TRANSACTION_ID to RCV_TRANSACTIONS, and LINE_LOCATION_ID to PO_LINE_LOCATIONS_ALL, connecting it to the purchasing document. Additional columns like INVENTORY_ITEM_ID and ORGANIZATION_ID, linked to MTL_SYSTEM_ITEMS_B and HR_ALL_ORGANIZATION_UNITS respectively, provide item and organizational context for the localized data.

Common Use Cases and Queries

This table is essential for generating localized tax reports, statutory filings, and internal audits specific to Asia/Pacific countries. Common operational and reporting queries involve joining this table with standard EBS entities to enrich transaction data. A typical pattern is to retrieve localization details for a specific receipt transaction or a range of transactions for a period. For example, to audit localized data for receipts in a given organization, a query might join JAI_RCV_LINES with RCV_TRANSACTIONS and RCV_SHIPMENT_LINES. Another common use case is tracing localized information back to the original purchase order line by joining via LINE_LOCATION_ID to PO_LINE_LOCATIONS_ALL and the PO_HEADERS_ALL table.

Related Objects

JAI_RCV_LINES has defined dependencies on several fundamental EBS tables, as documented in its foreign keys. Its existence is predicated on data from core receiving and inventory modules. Primary related objects include:

• RCV_SHIPMENT_LINES: The primary parent table for receipt line details.
• RCV_TRANSACTIONS: The transaction-level parent for receipt actions.
• RCV_SHIPMENT_HEADERS: Provides the shipment header context.
• PO_LINE_LOCATIONS_ALL: Links the receipt back to the purchase order shipment line.
• MTL_SYSTEM_ITEMS_B & HR_ALL_ORGANIZATION_UNITS: Provide master data for the item and organization involved.

Development or reporting involving JAI_RCV_LINES must consistently consider these relationships to ensure data integrity and accurate joins.