Results for “org_unit_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_CMN_RG_OTH_BALANCES is a transactional balance table owned by the JA schema (Asia/Pacific Localizations) and stored within the E-Business Suite database. It records the current monetary balances that apply to a specific combination of organization, register type, and tax type. The object is classified as VALID in the ETRM repository and is shipped as standard functionality for Oracle EBS 12.1.1 and 12.2.2 environments where the JA localization products are licensed and installed.

The table plays a supporting role in the Asian localization tax reporting and fiscal register processes, where balances must be maintained at an organizational granularity rather than purely at the document or transaction level. Because each row represents the current state of a balance for one register/tax/organization combination, the table is updated in place as transactions are processed, and the stored value reflects the latest cumulative position rather than a historical snapshot.

From a Data Vault modeling perspective, the mined relationship metadata suggests a satellite-leaning classification. The primary key of ORG_UNIT_ID, REGISTER_TYPE, and TAX_TYPE functions as a natural business key referencing the inventory organization, and the remaining columns capture descriptive and audit attributes around that key. A dimensional or Data Vault implementation would typically treat this as a satellite attached to an organization/register hub rather than as an independent hub or link.

Key Information Stored

The table contains ten documented columns. The most significant are:

• ORG_UNIT_ID — Identifies the inventory organization for which the balance is maintained. This column participates in the composite primary key and is the sole foreign key, referencing JAI_CMN_INVENTORY_ORGS.
• REGISTER_TYPE — Classifies the fiscal register category to which the balance pertains.
• TAX_TYPE — Identifies the tax regime or tax type associated with the balance.
• BALANCE — Holds the current monetary amount for the given organization, register type, and tax type combination. This is the principal business measure of the table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row and when.
• OBJECT_VERSION_NUMBER — Supports optimistic locking in the Oracle Application Framework (OAF) and concurrent update detection.

The primary key, JAI_CMN_RG_OTH_BALANCES_PK, is defined on ORG_UNIT_ID, REGISTER_TYPE, and TAX_TYPE. There is no separate surrogate identifier; the composite business key itself enforces uniqueness of the balance record.

Common Use Cases and Queries

Typical implementations query this table to report current balances by organization and tax type, to reconcile register balances against underlying transactions, and to feed localization tax returns. A representative query follows:

• Balance lookup for one organization and tax type: SELECT balance FROM jai_cmn_rg_oth_balances WHERE org_unit_id = :p_org AND register_type = :p_reg AND tax_type = :p_tax.
• Consolidated reporting across organizations: join to inventory organizations and aggregate balance by operating unit or legal entity.
• Audit and freshness checks: ordering by LAST_UPDATE_DATE to identify stale or recently refreshed balances.
• Reconciliation: comparing BALANCE against sums from register transaction tables for the same period.

Because the table stores current balances, historical point-in-time reporting requires either snapshotting the table on a schedule or reconstructing balances from the underlying transaction details.

Related Objects

• JAI_CMN_INVENTORY_ORGS — The foreign key parent; joined on JAI_CMN_RG_OTH_BALANCES.ORG_UNIT_ID = JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID.
• JAI_CMN_RG_OTH_BALANCES_PK — The primary key constraint enforcing uniqueness of the organization, register type, and tax type combination.
• HR_OPERATING_UNITS / HR_ALL_ORGANIZATION_UNITS — Frequently joined to resolve organization names for reporting.
• JAI_CMN_REGISTERS and related JA register tables — Conceptually linked through the register type dimension.
• JAI_CMN_TAX_* localization tables — Provide tax type reference data used in joins and validation.

These relationships should be validated against the actual database version in use, as localization object availability varies by installed products and patch level.