Search Results jai_rgm_term_assigns_uk1




Overview
Explore in AI Chat

Overview

The JAI_RGM_TERM_ASSIGNS table is a core data repository within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary function is to manage the hierarchical assignment of regulatory terms and conditions to business entities. This table stores the relationships that define which specific terms, as established within a regulatory regime, are automatically applied or defaulted to transactions, organizations, or locations. It is a critical component for ensuring compliance with regional statutory requirements by enabling the systematic and rule-based application of legal terms across the enterprise hierarchy.

Key Information Stored

The table's structure is designed to capture the context of a term assignment across multiple dimensions. The primary identifier is the TERM_ASSIGNMENT_ID. The table's unique key (JAI_RGM_TERM_ASSIGNS_UK1) reveals the core attributes that define an assignment's scope: REGIME_ID identifies the overarching regulatory framework; REGIME_ITEM_CLASS and REGIME_REGNO specify the item category and registration number within that regime; ORGANIZATION_ID and ORGANIZATION_TYPE pinpoint the specific business unit or legal entity; and LOCATION_ID defines the geographical context. The TERM_ID column is the foreign key linking to the specific term being assigned from the JAI_RGM_TERMS table.

Common Use Cases and Queries

A primary use case is determining the default terms applicable to a transaction for a given organization, location, and product class within a specific tax or regulatory regime. For instance, a report to audit all term assignments for a particular regime and organization would utilize a query joining to related master tables. Developers may query this table to validate or debug the term defaulting logic within localization-specific workflows, such as invoice generation or goods receipt.

Sample Query Pattern:
SELECT a.term_assignment_id, t.term_code, t.description, r.regime_code
FROM jai_rgm_term_assigns a,
jai_rgm_terms t,
jai_rgm_definitions r
WHERE a.term_id = t.term_id
AND a.regime_id = r.regime_id
AND a.organization_id = :p_org_id
AND a.regime_item_class = :p_item_class;

Related Objects

The JAI_RGM_TERM_ASSIGNS table is centrally connected to several key master and transactional tables via foreign key relationships, forming a critical part of the regulatory data model.

  • JAI_RGM_TERMS: Links via TERM_ID to retrieve the detailed definition, code, and description of the assigned term.
  • JAI_RGM_DEFINITIONS: Links via REGIME_ID to identify the regulatory regime (e.g., a specific Goods and Services Tax scheme).
  • JAI_RGM_REGISTRATIONS: Links via REGIME_REGNO to the specific registration certificate under the regime.
  • HR_ALL_ORGANIZATION_UNITS: Links via ORGANIZATION_ID to the HR organization master, identifying the assigned business unit or legal entity.
  • HR_LOCATIONS_ALL: Links via LOCATION_ID to the master location table, providing the geographical context for the term assignment.
  • Table: JAI_RGM_TERM_ASSIGNS 12.2.2

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_RGM_TERM_ASSIGNS,  object_name:JAI_RGM_TERM_ASSIGNS,  status:VALID,  product: JA - Asia/Pacific Localizations ,  description: Stores the term assignments to default at various hierarchial levels ,  implementation_dba_data: JA.JAI_RGM_TERM_ASSIGNS , 

  • Table: JAI_RGM_TERM_ASSIGNS 12.1.1

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_RGM_TERM_ASSIGNS,  object_name:JAI_RGM_TERM_ASSIGNS,  status:VALID,  product: JA - Asia/Pacific Localizations ,  description: Stores the term assignments to default at various hierarchial levels ,  implementation_dba_data: JA.JAI_RGM_TERM_ASSIGNS , 

  • 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. ,