Search Results jai_cmn_om_ar_ar3_forms

Overview

The table JAI_CMN_OM_AR_AR3_FORMS 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 as the central repository for storing AR3 forms and their associated details. The AR3 form is a statutory document specific to certain Asia/Pacific jurisdictions, often related to tax or commercial invoicing requirements. As indicated by its name and description, this table is designed for shared use across both the Order Management (OM) and Accounts Receivable (AR) application streams, ensuring a single source of truth for AR3 form data that may be generated from sales orders or invoices.

Key Information Stored

The table's primary key is FORM_ID, which uniquely identifies each AR3 form record. Its structure is defined by a series of foreign key relationships that link the form to critical transactional and master data entities within EBS. Key columns, inferred from these relationships, include CUSTOMER_ID (linking to HZ_PARTIES), CUSTOMER_SITE_ID (linking to HZ_PARTY_SITES), and ORGANIZATION_ID (linking to HR_ALL_ORGANIZATION_UNITS) to identify the operating unit. It also links to transactional entities via TRX_TYPE_ID (for invoice types via RA_CUST_TRX_TYPES_ALL) and DELIVERY_ID (for shipments via WSH_NEW_DELIVERIES). The LOCATION_ID column, linked to HR_LOCATIONS_ALL, likely stores a specific address or location relevant to the form's issuance.

Common Use Cases and Queries

Primary use cases revolve around the generation, tracking, and reporting of statutory AR3 forms. In Order Management, a form record may be created upon shipment confirmation. In Accounts Receivable, it may be finalized upon invoice creation. Common reporting needs include listing all AR3 forms for a specific customer, within a date range, or for a particular organization. A typical query would join this table to its related master tables to produce a readable report.

Sample Query Pattern:
SELECT f.form_id, p.party_name, hrc.name organization, f.last_update_date
FROM jai_cmn_om_ar_ar3_forms f,
     hz_parties p,
     hr_all_organization_units hrc
WHERE f.customer_id = p.party_id
AND f.organization_id = hrc.organization_id
AND f.organization_id = :p_org_id
ORDER BY f.last_update_date DESC;

Related Objects

JAI_CMN_OM_AR_AR3_FORMS is integrally connected to several fundamental EBS tables through its foreign key constraints, as documented in the ETRM. These dependencies are crucial for data integrity and application functionality:

• HZ_PARTIES & HZ_PARTY_SITES: For customer and customer site master data.
• HR_ALL_ORGANIZATION_UNITS: For the operating unit context.
• HR_LOCATIONS_ALL: For detailed address information.
• RA_CUST_TRX_TYPES_ALL: For the transaction type (e.g., invoice type) associated with the form.
• WSH_NEW_DELIVERIES: For linkage to shipment and delivery transactions from Order Management.

Any custom reports, interfaces, or extensions dealing with localized AR3 form functionality will likely reference this table as the primary data source.