Search Results jai_rcv_headers_pk

Overview

JAI_RCV_HEADERS is the India Localization receipts header table, owned by the JA schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It mirrors the structure and semantics of the standard Oracle Receiving table RCV_SHIPMENT_HEADERS, extending it with India-specific excise and tax attributes required for statutory compliance. The table is classified as VALID within the ETRM repository and forms part of the JA – Asia/Pacific Localizations product family.

Functionally, the table stores receipt header information for inbound shipments, including vendor and customer references, excise invoice details, and RMA processing indicators. It serves as the localization anchor point that integrates with Oracle Purchasing and Oracle Receiving flows when the India Localization (JA) module is installed. Based on its foreign key structure, the heuristic Data Vault classification for this object is link: it bridges party master data (vendors and customers), party sites, and organization units, connecting these reference hubs to transactional receipt activity.

Key Information Stored

The primary key JAI_RCV_HEADERS_PK is defined on SHIPMENT_HEADER_ID, a surrogate identifier that aligns the localization record with the corresponding standard shipment header. The most significant columns include:

SHIPMENT_HEADER_ID – Primary key and surrogate identifier linking the localized header to the underlying receiving shipment.
RECEIPT_NUM and SHIPMENT_NUM – Human-readable document numbers for the receipt and its shipment grouping.
RECEIPT_SOURCE_CODE – Indicates the origin of the receipt, such as vendor or internal transfer.
SHIPPED_DATE – Date on which the goods were shipped, relevant for excise and reporting timelines.
ORGANIZATION_ID – The inventory organization receiving the goods; foreign key to HR_ALL_ORGANIZATION_UNITS.
VENDOR_ID and VENDOR_SITE_ID – Foreign keys to HZ_PARTIES and HZ_PARTY_SITES identifying the supplier and supplier site.
CUSTOMER_ID and CUSTOMER_SITE_ID – Foreign keys to HZ_PARTIES and HZ_PARTY_SITES identifying the customer, applicable for RMA and returns processing.
EXCISE_INVOICE_NO and EXCISE_INVOICE_DATE – India-specific excise invoice reference and date, central to tax compliance.
RMA_TYPE – Classifies return material authorization types where the receipt is a return.
ONLINE_CLAIM_FLAG, APPLY_HEADER_FLAG, and THIRD_PARTY_FLAG – Control flags governing claim processing, header application, and third-party transaction behavior.
OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN – Standard audit and concurrency columns.
ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – Descriptive flexfield segments for localization-specific extensions.

No unique business-key index other than the primary key is documented; RECEIPT_NUM and SHIPMENT_NUM are therefore business identifiers rather than enforced unique keys.

Common Use Cases and Queries

Typical use cases center on India excise reporting and receipts reconciliation. A common query joins the localization header to the standard receiving tables to reconcile excise invoices against shipments:

Extracting excise invoice registers for a given period using EXCISE_INVOICE_DATE and EXCISE_INVOICE_NO.
Reconciling localization receipts to standard RCV_SHIPMENT_HEADERS on SHIPMENT_HEADER_ID.
Reporting vendor-wise and organization-wise inbound receipt volumes using VENDOR_ID and ORGANIZATION_ID.
Identifying return transactions through RMA_TYPE and CUSTOMER_ID for credit and claim processing.
Auditing third-party and online claim scenarios via THIRD_PARTY_FLAG and ONLINE_CLAIM_FLAG.

A representative pattern: SELECT h.RECEIPT_NUM, h.EXCISE_INVOICE_NO, p.PARTY_NAME FROM JA.JAI_RCV_HEADERS h, HZ_PARTIES p WHERE h.VENDOR_ID = p.PARTY_ID AND h.EXCISE_INVOICE_DATE BETWEEN :start_date AND :end_date;

Related Objects

RCV_SHIPMENT_HEADERS – Standard receiving header; joined on SHIPMENT_HEADER_ID, the localization counterpart structure.
HZ_PARTIES – Referenced by VENDOR_ID and CUSTOMER_ID for supplier and customer identity.
HZ_PARTY_SITES – Referenced by VENDOR_SITE_ID and CUSTOMER_SITE_ID for site-level address and tax details.
HR_ALL_ORGANIZATION_UNITS – Referenced by ORGANIZATION_ID to resolve the receiving inventory organization.
JAI_RCV_LINES – The corresponding India localization receipt line table, linked through the shipment header.
JAI_AP_TDS_INVOICES / JAI_CMN_* – India localization tax and common tables that consume receipt header data for excise reporting.
RCV_SHIPMENT_LINES – Standard line detail that pairs with this header for full receipt documents.
PO_HEADERS_ALL / PO_LINES_ALL – Purchase order references underlying the receipt for procurement traceability.

Table: JAI_RCV_HEADERS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_HEADERS, object_name:JAI_RCV_HEADERS, status:VALID, product: JA - Asia/Pacific Localizations , description: India Localization Receipts Header Table same as RCV_SHIPMENT_HEADERS , implementation_dba_data: JA.JAI_RCV_HEADERS ,
INDEX: JA.JAI_RCV_HEADERS_PK 12.2.2
owner:JA, object_type:INDEX, object_name:JAI_RCV_HEADERS_PK, status:VALID,
Table: JAI_RCV_HEADERS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_HEADERS, object_name:JAI_RCV_HEADERS, status:VALID, product: JA - Asia/Pacific Localizations , description: India Localization Receipts Header Table same as RCV_SHIPMENT_HEADERS , implementation_dba_data: JA.JAI_RCV_HEADERS ,
INDEX: JA.JAI_RCV_HEADERS_PK 12.1.1
owner:JA, object_type:INDEX, object_name:JAI_RCV_HEADERS_PK, status:VALID,
TABLE: JA.JAI_RCV_HEADERS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_HEADERS, object_name:JAI_RCV_HEADERS, status:VALID,
TABLE: JA.JAI_RCV_HEADERS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_HEADERS, object_name:JAI_RCV_HEADERS, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,