Search Results jai_rgm_parties




Overview
Explore in AI Chat

Overview

The JAI_RGM_PARTIES table is a core data object within the Oracle E-Business Suite Asia/Pacific (JA) Localizations module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for associating an organization with a specific tax or regulatory regime. This association is fundamental for managing region-specific compliance, such as Goods and Services Tax (GST) in India or other statutory regimes across the Asia/Pacific region. The table acts as a junction, linking the master definitions of regimes, organizational structures, physical locations, and tax authorities to define the precise context under which tax rules and calculations are applied for a given business entity.

Key Information Stored

The table's primary key, REGIME_ORG_ID, uniquely identifies each organization-regime association. Its critical foreign key columns define the components of this association. The REGIME_ID links to JAI_RGM_DEFINITIONS, specifying the applicable tax regime. The ORGANIZATION_ID and LOCATION_ID link to HR_ALL_ORGANIZATION_UNITS and HR_LOCATIONS_ALL, respectively, pinpointing the specific operating unit and its physical address subject to the regime. Furthermore, AUTHORITY_ID and AUTHORITY_SITE_ID establish connections to HZ_PARTIES and HZ_PARTY_SITES, identifying the relevant government tax authority and its official address for reporting and remittance purposes related to this specific association.

Common Use Cases and Queries

A primary use case is determining the applicable tax regime for a transaction originating from a specific organization and location. For reporting, the table is essential for generating statutory returns, as it links transactional data to the correct authority. Common queries involve joining this table to regime definitions and organization details. For instance, to list all regime associations for an organization:

  • SELECT rgp.regime_org_id, rgd.regime_code, hou.name org_name, hl.location_code
    FROM jai_rgm_parties rgp,
    jai_rgm_definitions rgd,
    hr_all_organization_units hou,
    hr_locations_all hl
    WHERE rgp.regime_id = rgd.regime_id
    AND rgp.organization_id = hou.organization_id
    AND rgp.location_id = hl.location_id
    AND hou.name = '<Org Name>';

Another critical query pattern validates the regime-party setup before processing transactions by checking for an existing association between a given regime, organization, and location.

Related Objects

JAI_RGM_PARTIES maintains extensive relationships with other localization tables, as documented in the ETRM metadata. It references master tables for its key components:

  • JAI_RGM_DEFINITIONS via REGIME_ID
  • HR_ALL_ORGANIZATION_UNITS via ORGANIZATION_ID
  • HR_LOCATIONS_ALL via LOCATION_ID
  • HZ_PARTIES via AUTHORITY_ID
  • HZ_PARTY_SITES via AUTHORITY_SITE_ID

Conversely, it is referenced as a parent table by transactional and regulatory objects:

These relationships underscore its role as a mandatory setup prerequisite for generating compliant tax transactions and registrations within the localized system.