Search Results claim_schedule_id

Overview

The JAI_RCV_RGM_CLAIMS table is a core data repository within the JA (Asia/Pacific Localizations) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is designed to store detailed transactional records for tax claims associated with received goods, specifically within the context of localized tax regimes prevalent in the Asia/Pacific region. The table's primary role is to track and manage the lifecycle of a tax claim generated from a receipt transaction, linking the claim to the original receipt, the applicable tax regime, and the specific tax lines. This enables businesses to comply with complex regional tax regulations that allow for the recovery or adjustment of taxes paid on procurements.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which reveal the critical data points it manages. The primary key, CLAIM_SCHEDULE_ID, uniquely identifies each claim record. The foreign key relationships are particularly informative, indicating that the table stores references to the originating receipt shipment (SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID) and the specific receipt transaction (TRANSACTION_ID). Crucially, it links to the regime tax line (RCV_RGM_LINE_ID via JAI_RCV_RGM_LINES) and the detailed tax transactions (TAX_TRANSACTION_ID, TAX_ID, TRX_TAX_ID). This structure allows the table to hold data such as the claim amount, claim status, associated regime, and the exact tax component being claimed, forming an auditable trail from receipt to tax recovery.

Common Use Cases and Queries

The primary use case is generating reports and supporting processes for tax credit or refund claims on received goods. A typical business scenario involves querying all open claims for a specific tax regime or supplier to facilitate reconciliation and submission to tax authorities. Common SQL patterns include joining this table with related shipment and tax tables to analyze claim volumes and values. For example, a report to list all claims for a given period would join JAI_RCV_RGM_CLAIMS with RCV_SHIPMENT_HEADERS and JAI_CMN_TAXES_ALL. Data from this table is also critical for period-end closing procedures within the localization, ensuring all eligible receipt-based tax claims are accurately captured and accounted for before financial reporting.

Related Objects

As indicated by its foreign keys, JAI_RCV_RGM_CLAIMS is a central hub connected to several key EBS objects. Its most direct relationship is with the JAI_RCV_RGM_LINES table, which holds the regime-specific tax lines for receipts. It is fundamentally tied to the core Receiving module tables: RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS, which provide the underlying receipt transaction data. For tax master data, it references JAI_CMN_TAXES_ALL. This network of relationships positions JAI_RCV_RGM_CLAIMS as the critical link between Oracle's standard receiving functionality and the specialized Asia/Pacific tax claim logic, ensuring localization processes are seamlessly integrated with base application transactions.