Search Results jai_rgm_stl_balances




Overview
Explore in AI Chat

Overview

The JAI_RGM_STL_BALANCES table is a core data repository within the Oracle E-Business Suite Asia/Pacific Localizations module (product JA). Its primary function is to store detailed settlement information for tax or regulatory regimes on a periodic basis. The table acts as a ledger, capturing the finalized financial outcomes of settlement processes. It plays a critical role in the statutory compliance and financial reporting workflows for implementations in regions requiring such localized settlement functionality, particularly within the 12.1.1 and 12.2.2 versions of Oracle EBS.

Key Information Stored

The table's structure is designed to uniquely identify and detail each settlement entry. Its primary key is the system-generated STL_BALANCE_ID. A unique key constraint ensures that a combination of critical business attributes cannot be duplicated, which includes the SETTLEMENT_ID, SETTLEMENT_DATE, PARTY_ID, PARTY_TYPE, LOCATION_ID, and TAX_TYPE. These columns collectively define the specific settlement event, the involved legal or organizational entity (party), the relevant geographical location, and the type of tax being settled. Other columns, implied by the table's purpose, would typically store financial amounts such as assessed tax liability, credits applied, payments made, and the resulting net settlement balance for the period.

Common Use Cases and Queries

This table is central to generating historical settlement reports and reconciling tax regime activities. A common operational use case is querying the settlement history for a specific legal entity (PARTY_ID) and tax type (TAX_TYPE) over a date range to support audits or internal analysis. For reporting, data from this table is often joined with descriptive information from related master tables to produce readable compliance reports. A typical analytical query pattern would involve filtering by SETTLEMENT_DATE and PARTY_ID, and summing balance amounts. Sample SQL to retrieve settlement details for a party might be:

  • SELECT stl.settlement_date, stl.tax_type, stl.location_id, stl.balance_amount
  • FROM jai_rgm_stl_balances stl
  • WHERE stl.party_id = :p_party_id
  • AND stl.settlement_date BETWEEN :p_from_date AND :p_to_date
  • ORDER BY stl.settlement_date DESC, stl.tax_type;

Related Objects

JAI_RGM_STL_BALANCES is integrally linked to several master and transactional tables via foreign key relationships, as documented in the ETRM. The key dependencies are:

  • JAI_RGM_SETTLEMENTS: Linked via the SETTLEMENT_ID column. This is the primary parent table, providing the header-level information for the settlement process to which these balance details belong.
  • HR_LOCATIONS_ALL: Linked via the LOCATION_ID column. This join provides the physical or legal address details associated with the settlement record.
  • HR_ALL_ORGANIZATION_UNITS: Linked via the PARTY_ID column (when PARTY_TYPE indicates an organization). This relationship ties the settlement balance to a specific operating unit or organization within the EBS hierarchy.