Search Results jai_ar_sup_changes_all

Overview

JAI_AR_SUP_CHANGES_ALL is a transactional mapping table owned by the JA (Asia/Pacific Localizations) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store mapping information for the customer and customer site combinations that are considered during the supplemental invoice (supp inv) process, a localization feature used primarily for regional tax and statutory reporting in Asia/Pacific deployments. The table effectively records which party/site pairing is captured for a given ledger, operating unit, and batch run, together with the attributes required to reconcile those records against downstream supplemental invoice, line, and tax tables.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is hub-leaning. It carries a single-column surrogate primary key, JAI_AR_SUP_CHANGES_ALL_PK on MAPPING_ID, and functions as a central reference point from which multiple dependent detail tables hang. In a Data Vault model it would most naturally be modeled as a hub (the mapping identity) with attached satellites for the temporal and conversion attributes, and links to customer, site, ledger, and organization hubs.

Key Information Stored

The table is documented with 19 columns. The most significant are:

MAPPING_ID — the surrogate primary key and sole unique index (JAI_AR_SUP_CHANGES_ALL_PK). All dependent detail tables reference this column.
MAPPING_TYPE — classifies the nature of the mapping record, distinguishing the various mapping roles the process supports.
EXISTING_TYPE_ID / NEW_TYPE_ID — capture the prior and new classification identifiers applied when a customer or site mapping is changed by the supplemental invoice process.
EFFECTIVE_FROM_DATE / EFFECTIVE_TO_DATE — define the dated validity window of the mapping, enabling point-in-time reconstruction.
PROCESS_DATE — the date the mapping was processed, supporting run-level reconciliation and audit.
CONVERSION_RATE — the exchange rate applied when the supplemental invoice is generated.
SET_OF_BOOKS_ID — the ledger under which the mapping applies (FK to GL_LEDGERS).
ORG_ID — the operating unit (FK to HR_ALL_ORGANIZATION_UNITS), which also drives Multi-Org security.
CUSTOMER_ID / SITE_USE_ID — the customer party and site use captured for the process (FKs to HZ_PARTIES and HZ_PARTY_SITES).
BATCH_ID — self-referencing grouping identifier that ties a set of mappings to a single processing run.
OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/Forms layer.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO audit columns.

The business-key candidate is effectively the composite of SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_ID, SITE_USE_ID, and the effective dates; however, only MAPPING_ID is formally backed by a unique index in the documented schema.

Common Use Cases and Queries

Typical usage centers on diagnosing and reporting supplemental invoice mappings. A common pattern joins the header mapping to its detail tables:

Mapping audit by ledger and operating unit — filter on SET_OF_BOOKS_ID, ORG_ID, and PROCESS_DATE to list all mappings processed in a period.
Point-in-time reconstruction — restrict on EFFECTIVE_FROM_DATE <= :as_of AND (EFFECTIVE_TO_DATE IS NULL OR EFFECTIVE_TO_DATE > :as_of) to reproduce the mapping state at a prior date.
Batch reconciliation — group by BATCH_ID, including the self-referenced parent rows, to verify completeness of a supplemental run.
Customer/site drill-down — join CUSTOMER_ID to HZ_PARTIES and SITE_USE_ID to HZ_PARTY_SITES to report which parties were included.
Rate verification — compare CONVERSION_RATE against GL daily rates for the PROCESS_DATE.

Sample SQL: SELECT c.mapping_id, c.customer_id, c.site_use_id, c.conversion_rate FROM jai_ar_sup_changes_all c WHERE c.set_of_books_id = :sob AND c.org_id = :org AND c.process_date BETWEEN :from AND :to ORDER BY c.batch_id, c.mapping_id;

Related Objects

The FK structure identifies the following significant dependencies:

JAI_AR_SUP_INV_T — references this table via MAPPING_ID; holds supplemental invoice header detail.
JAI_AR_SUP_LINES — references this table through both PL_MAPPING_ID and AL_MAPPING_ID, linking line-level records back to their mappings.
JAI_AR_SUP_TAXES — references MAPPING_ID; stores tax detail attributed to each mapping.
JAI_AR_TRX_SUP_INV_T — references MAPPING_ID; the transaction-level supplemental invoice table.
GL_LEDGERS — referenced via SET_OF_BOOKS_ID.
HR_ALL_ORGANIZATION_UNITS — referenced via ORG_ID for operating unit context.
HZ_PARTIES — referenced via CUSTOMER_ID.
HZ_PARTY_SITES — referenced via SITE_USE_ID.
JAI_AR_SUP_CHANGES_ALL (self-referencing) — BATCH_ID links child mappings to their batch parent.

Table: JAI_AR_SUP_CHANGES_ALL 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_CHANGES_ALL, object_name:JAI_AR_SUP_CHANGES_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores mapping info with the Cust/CustSite considered for supp inv process , implementation_dba_data: JA.JAI_AR_SUP_CHANGES_ALL ,
Table: JAI_AR_SUP_CHANGES_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_CHANGES_ALL, object_name:JAI_AR_SUP_CHANGES_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores mapping info with the Cust/CustSite considered for supp inv process , implementation_dba_data: JA.JAI_AR_SUP_CHANGES_ALL ,
VIEW: JA.JAI_AR_SUP_CHANGES_ALL# 12.2.2
owner:JA, object_type:VIEW, object_name:JAI_AR_SUP_CHANGES_ALL#, status:VALID,
Table: JAI_AR_SUP_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_LINES, object_name:JAI_AR_SUP_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores SuppTransaction dtls of the individual items with the Orig Inv dtls , implementation_dba_data: JA.JAI_AR_SUP_LINES ,
SYNONYM: APPS.JAI_AR_SUP_CHANGES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JAI_AR_SUP_CHANGES_ALL, status:VALID,
SYNONYM: APPS.JAI_AR_SUP_CHANGES_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JAI_AR_SUP_CHANGES_ALL, status:VALID,
Table: JAI_AR_SUP_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_LINES, object_name:JAI_AR_SUP_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores SuppTransaction dtls of the individual items with the Orig Inv dtls , implementation_dba_data: JA.JAI_AR_SUP_LINES ,
VIEW: JA.JAI_AR_SUP_CHANGES_ALL# 12.2.2
Table: JAI_AR_SUP_INV_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_INV_T, object_name:JAI_AR_SUP_INV_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores TempInfo of Suppl INV used by India Gen. Suggestive Suppl Report. , implementation_dba_data: JA.JAI_AR_SUP_INV_T ,
TABLE: JA.JAI_AR_SUP_CHANGES_ALL 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_CHANGES_ALL, object_name:JAI_AR_SUP_CHANGES_ALL, status:VALID,
TABLE: JA.JAI_AR_SUP_CHANGES_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_CHANGES_ALL, object_name:JAI_AR_SUP_CHANGES_ALL, status:VALID,
Table: JAI_AR_TRX_SUP_INV_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_SUP_INV_T, object_name:JAI_AR_TRX_SUP_INV_T, status:VALID, product: JA - Asia/Pacific Localizations , description: TempTable stores Supp Invoices and used by India Gen Suggestive Supp Report. , implementation_dba_data: JA.JAI_AR_TRX_SUP_INV_T ,
Table: JAI_AR_SUP_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_TAXES, object_name:JAI_AR_SUP_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores SuppTransaction details of the individual taxes with the Orig INV dtls. , implementation_dba_data: JA.JAI_AR_SUP_TAXES ,
Table: JAI_AR_TRX_SUP_INV_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_SUP_INV_T, object_name:JAI_AR_TRX_SUP_INV_T, status:VALID, product: JA - Asia/Pacific Localizations , description: TempTable stores Supp Invoices and used by India Gen Suggestive Supp Report. , implementation_dba_data: JA.JAI_AR_TRX_SUP_INV_T ,
Table: JAI_AR_SUP_INV_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_INV_T, object_name:JAI_AR_SUP_INV_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores TempInfo of Suppl INV used by India Gen. Suggestive Suppl Report. , implementation_dba_data: JA.JAI_AR_SUP_INV_T ,
Table: JAI_AR_SUP_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_TAXES, object_name:JAI_AR_SUP_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores SuppTransaction details of the individual taxes with the Orig INV dtls. , implementation_dba_data: JA.JAI_AR_SUP_TAXES ,
PACKAGE BODY: APPS.JAI_AR_SUP_TRX_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_SUP_TRX_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_AR_SUP_TRX_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AR_SUP_TRX_PKG, status:VALID,
Table: GL_LEDGERS 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_LEDGERS, object_name:GL_LEDGERS, status:VALID, product: GL - General Ledger , description: Ledger definition , implementation_dba_data: GL.GL_LEDGERS ,
Table: GL_LEDGERS 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_LEDGERS, object_name:GL_LEDGERS, status:VALID, product: GL - General Ledger , description: Ledger definition , implementation_dba_data: GL.GL_LEDGERS ,
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
Table: HZ_PARTY_SITES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTY_SITES, object_name:HZ_PARTY_SITES, status:VALID, product: AR - Receivables , description: Links party to physical locations , implementation_dba_data: AR.HZ_PARTY_SITES ,
Table: HZ_PARTY_SITES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTY_SITES, object_name:HZ_PARTY_SITES, status:VALID, product: AR - Receivables , description: Links party to physical locations , implementation_dba_data: AR.HZ_PARTY_SITES ,
APPS.JAI_AR_SUP_TRX_PKG SQL Statements 12.1.1
APPS.JAI_AR_SUP_TRX_PKG SQL Statements 12.2.2
APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_CHANGES_ALL 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. ,
APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_CHANGES_ALL 12.1.1
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 ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,
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: 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_SUP_TRX_PKG 12.1.1
PACKAGE BODY: APPS.JAI_AR_SUP_TRX_PKG 12.2.2
APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_TRX_SUP_INV_T 12.1.1
APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_TRX_SUP_INV_T 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. ,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1