Search Results jai_rcv_rgm_lines




Overview
Explore in AI Chat

Overview

The JAI_RCV_RGM_LINES table is a core data repository within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module (product code JA). It is designed to store detailed line-level information for receipt claims, which are formal requests or adjustments related to goods received. This table functions as a transactional ledger for claim lines, linking them to the foundational EBS receiving and inventory structures. Its primary role is to support localized business processes, such as regional tax or regulatory compliance for goods receipt, that extend beyond the standard Oracle Receiving functionality in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on the unique identifier RCV_RGM_LINE_ID, which serves as the primary key (JAI_RCV_RGM_LINES_PK). Key columns establish critical relationships with other EBS entities. The SHIPMENT_HEADER_ID and SHIPMENT_LINE_ID link the claim line to the original receiving transaction in RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES. The INVENTORY_ITEM_ID and ORGANIZATION_ID identify the claimed item, while TRANSACTION_ID references the specific receiving transaction in RCV_TRANSACTIONS. For vendor and location context, it stores VENDOR_ID, VENDOR_SITE_ID, and LOCATION_ID. The TERM_ID links to JAI_RGM_TERMS, likely governing claim-specific conditions or calculations.

Common Use Cases and Queries

This table is central to generating reports on receipt claim liabilities, analyzing claim trends by vendor or item, and supporting the reconciliation of claimed quantities against original receipts. A common query pattern involves joining to related shipping and item tables to get a complete view of a claim line. For example, to retrieve details for a specific claim line identifier:

  • SELECT jrrl.*, rsh.po_header_id, msib.segment1 item_code
  • FROM ja.jai_rcv_rgm_lines jrrl,
  • rcv_shipment_headers rsh,
  • mtl_system_items_b msib
  • WHERE jrrl.rcv_rgm_line_id = :p_line_id
  • AND jrrl.shipment_header_id = rsh.shipment_header_id
  • AND jrrl.inventory_item_id = msib.inventory_item_id
  • AND jrrl.organization_id = msib.organization_id;

Another typical use case is aggregating claim amounts by vendor over a period, which would involve grouping by VENDOR_ID and filtering on relevant date columns.

Related Objects

JAI_RCV_RGM_LINES has extensive foreign key relationships, acting as a hub between standard EBS tables and localization objects. Key dependencies include:

  • JAI_RCV_RGM_CLAIMS: This table references RCV_RGM_LINE_ID, indicating JAI_RCV_RGM_LINES is a child or detail record to a claim header.
  • Standard Receiving Tables: RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS provide the source transaction data.
  • Inventory & Item Master: MTL_SYSTEM_ITEMS_B for item details.
  • Trading Community Architecture (TCA): HZ_PARTIES and HZ_PARTY_SITES for vendor information.
  • Localization Objects: JAI_RGM_TERMS for claim terms and HR_LOCATIONS_ALL for physical location data.