Search Results jai_ar_trx_ins_hdrs_t

Overview

The JAI_AR_TRX_INS_HDRS_T table is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves a specific transactional purpose in the Accounts Receivable (AR) process for localized requirements. As documented, its primary role is to store values passed during the "RG entry" (likely referring to a localized tax or regulatory entry process) when a manual AR transaction is created for the first time. This table acts as a supporting repository for transaction header-level data that is essential for compliant financial reporting and processing within the supported Asia/Pacific jurisdictions. Its existence underscores the customization layer that regional localizations add to the standard EBS financials core.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign key relationships reveal the critical header-level attributes stored. The table anchors a manual transaction to its core AR transaction via CUSTOMER_TRX_ID, linking to JAI_AR_TRXS or RA_CUSTOMER_TRX_ALL. It stores the transaction's context through BATCH_SOURCE_ID and CUST_TRX_TYPE_ID. Crucially, it holds key party and location information necessary for localized calculations, including BILL_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_ID, and their corresponding site use IDs (BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID). Furthermore, it records ORGANIZATION_ID and LOCATION_ID, which are vital for determining the legal entity and physical place of supply as per regional tax laws.

Common Use Cases and Queries

The primary use case is supporting the generation and audit of localized tax or regulatory reports for manually entered invoices, debit memos, and credit memos. A typical query would join this table to standard AR and customer tables to extract a complete transactional view for compliance purposes. For example, to retrieve all manual transactions for a specific legal entity, one might use a SQL pattern such as: SELECT jai.customer_trx_id, hro.name org, hla.address1 location FROM jai_ar_trx_ins_hdrs_t jai, hr_all_organization_units hro, hr_locations_all hla WHERE jai.organization_id = hro.organization_id AND jai.location_id = hla.location_id AND jai.organization_id = :p_org_id; This table is also critical for troubleshooting discrepancies in localized tax calculations, as it holds the initial values captured during the first manual entry of a transaction.

Related Objects

The table maintains integral relationships with several core EBS tables, as documented by its foreign keys. Its primary link to the transactional system is through JAI_AR_TRXS (or RA_CUSTOMER_TRX_ALL) via CUSTOMER_TRX_ID. It references master data for transaction setup (RA_BATCH_SOURCES_ALL, RA_CUST_TRX_TYPES_ALL), organizational structure (HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL), and customer information (HZ_PARTIES for customer identities, HZ_CUST_SITE_USES_ALL for operational addresses). These relationships ensure data integrity and allow the localization data to be consistently contextualized within the broader EBS ecosystem.

Table: JAI_AR_TRX_INS_HDRS_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_HDRS_T, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores values pass'g RGentry when manual ARtransaction done for 1st time , implementation_dba_data: JA.JAI_AR_TRX_INS_HDRS_T ,
Table: JAI_AR_TRX_INS_HDRS_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_HDRS_T, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores values pass'g RGentry when manual ARtransaction done for 1st time , implementation_dba_data: JA.JAI_AR_TRX_INS_HDRS_T ,
APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.2.2
APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.1.1
APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.2.2
APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.2.2
APPS.JAI_AR_TRXS_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.2.2
APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.2.2
APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_HDRS_T 12.1.1
VIEW: JA.JAI_AR_TRX_INS_HDRS_T# 12.2.2
owner:JA, object_type:VIEW, object_name:JAI_AR_TRX_INS_HDRS_T#, status:VALID,
SYNONYM: APPS.JAI_AR_TRX_INS_HDRS_T 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID,
SYNONYM: APPS.JAI_AR_TRX_INS_HDRS_T 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID,
VIEW: JA.JAI_AR_TRX_INS_HDRS_T# 12.2.2
APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_FIN_YEARS 12.2.2
Table: JAI_AR_TRXS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRXS, object_name:JAI_AR_TRXS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores information about the receivables invoices. , implementation_dba_data: JA.JAI_AR_TRXS ,
TABLE: JA.JAI_AR_TRX_INS_HDRS_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_HDRS_T, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID,
Table: RA_BATCH_SOURCES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_BATCH_SOURCES_ALL, object_name:RA_BATCH_SOURCES_ALL, status:VALID, product: AR - Receivables , description: Sources of invoice, credit memo and commitments , implementation_dba_data: AR.RA_BATCH_SOURCES_ALL ,
Table: JAI_AR_TRXS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRXS, object_name:JAI_AR_TRXS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores information about the receivables invoices. , implementation_dba_data: JA.JAI_AR_TRXS ,
TABLE: JA.JAI_AR_TRX_INS_HDRS_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_HDRS_T, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID,
APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS 12.1.1
APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS 12.2.2
Table: RA_BATCH_SOURCES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_BATCH_SOURCES_ALL, object_name:RA_BATCH_SOURCES_ALL, status:VALID, product: AR - Receivables , description: Sources of invoice, credit memo and commitments , implementation_dba_data: AR.RA_BATCH_SOURCES_ALL ,
Table: HZ_CUST_SITE_USES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
PACKAGE BODY: APPS.JAI_AR_TRXS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_TRXS_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_JAR_TRXS_TRIGGER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_JAR_TRXS_TRIGGER_PKG, status:VALID,
Table: RA_CUST_TRX_TYPES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUST_TRX_TYPES_ALL, object_name:RA_CUST_TRX_TYPES_ALL, status:VALID, product: AR - Receivables , description: Transaction type for invoices, commitments and credit memos , implementation_dba_data: AR.RA_CUST_TRX_TYPES_ALL ,
Table: RA_CUST_TRX_TYPES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUST_TRX_TYPES_ALL, object_name:RA_CUST_TRX_TYPES_ALL, status:VALID, product: AR - Receivables , description: Transaction type for invoices, commitments and credit memos , implementation_dba_data: AR.RA_CUST_TRX_TYPES_ALL ,
PACKAGE BODY: APPS.JAI_JAR_TRXS_TRIGGER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_JAR_TRXS_TRIGGER_PKG, status:VALID,
APPS.JAI_AR_TRXS_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.JAI_AR_RCTA_TRIGGER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_RCTA_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_AR_TRX_HEADERS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_TRX_HEADERS_PKG, status:VALID,
Table: HZ_CUST_SITE_USES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
PACKAGE BODY: APPS.JAI_AR_RCTA_TRIGGER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_RCTA_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_AR_IMPORT_SYNC_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_IMPORT_SYNC_PKG, status:VALID,
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
Table: HR_LOCATIONS_ALL 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_LOCATIONS_ALL, object_name:HR_LOCATIONS_ALL, status:VALID, product: PER - Human Resources , description: Work location definitions. , implementation_dba_data: HR.HR_LOCATIONS_ALL ,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.JAI_JAR_TRXS_TRIGGER_PKG SQL Statements 12.2.2
Table: HR_LOCATIONS_ALL 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_LOCATIONS_ALL, object_name:HR_LOCATIONS_ALL, status:VALID, product: PER - Human Resources , description: Work location definitions. , implementation_dba_data: HR.HR_LOCATIONS_ALL ,
APPS.JAI_JAR_TRXS_TRIGGER_PKG SQL Statements 12.1.1
Table: HZ_PARTIES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTIES, object_name:HZ_PARTIES, status:VALID, product: AR - Receivables , description: Information about parties such as organizations, people, and groups , implementation_dba_data: AR.HZ_PARTIES ,
Table: HZ_PARTIES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTIES, object_name:HZ_PARTIES, status:VALID, product: AR - Receivables , description: Information about parties such as organizations, people, and groups , implementation_dba_data: AR.HZ_PARTIES ,
PACKAGE BODY: APPS.JAI_AR_TRXS_PKG 12.2.2
PACKAGE BODY: APPS.JAI_JAR_TRXS_TRIGGER_PKG 12.2.2
Table: HR_ALL_ORGANIZATION_UNITS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: PER - Human Resources , description: Organization unit definitions. , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
Table: HR_ALL_ORGANIZATION_UNITS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: PER - Human Resources , description: Organization unit definitions. , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
PACKAGE BODY: APPS.JAI_JAR_TRXS_TRIGGER_PKG 12.1.1