Results for “consolidation_date”

27 results




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

Overview

JAI_CMN_RG_CONSLDATIONS is a transactional table owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations module. Its documented purpose is to store transaction information generated during RG (Regulatory/Reporting Group) Consolidation processing. This consolidation functionality supports statutory reporting requirements specific to Asia/Pacific country localizations, where invoice, payment, and tax-related balances must be periodically aggregated and reconciled against prior period results.

From a data modeling perspective, the mined metadata suggests a Data Vault classification of link. The table carries a single-column surrogate primary key and multiple foreign key references to core Human Resources master data, which is characteristic of a link entity connecting business transactions to organizational and location context. It should be viewed as an integration or association point rather than a pure descriptive satellite.

Key Information Stored

The table contains 66 documented columns. The most significant include:

Common Use Cases and Queries

Typical scenarios include statutory excise reconciliation reporting, verification of consolidation balances against sub-ledger transactions, and period-over-period variance analysis.

  • Retrieving the latest consolidation for an organization and location:
SELECT CONSOLIDATION_ID, CONSOLIDATION_DATE,
       CUR_NET_PAYABLE, CON_NET_PAYABLE
FROM   JA.JAI_CMN_RG_CONSLDATIONS
WHERE  ORGANIZATION_ID = :p_org_id
AND    LOCATION_ID = :p_loc_id
ORDER BY CONSOLIDATION_DATE DESC;
  • Comparing current versus previous RG23AP2 duties:
SELECT CONSOLIDATION_DATE,
       CUR_RG23AP2_BED, PREV_RG23AP2_RID,
       CUR_RG23AP2_CESS, CON_RG23AP2_CESS
FROM   JA.JAI_CMN_RG_CONSLDATIONS
WHERE  CONSOLIDATION_DATE BETWEEN :p_from AND :p_to;
  • Joining to organization and location for reporting:
SELECT h.name org_name, l.location_code,
       r.CONSOLIDATION_DATE, r.TOD_PLA_SED
FROM   JA.JAI_CMN_RG_CONSLDATIONS r,
       HR_ALL_ORGANIZATION_UNITS h,
       HR_LOCATIONS_ALL l
WHERE  r.ORGANIZATION_ID = h.organization_id
AND    r.LOCATION_ID = l.location_id;

Related Objects

  • HR_ALL_ORGANIZATION_UNITS — joined via JAI_CMN_RG_CONSLDATIONS.ORGANIZATION_ID.
  • HR_LOCATIONS_ALL — joined via JAI_CMN_RG_CONSLDATIONS.LOCATION_ID.
  • JAI_CMN_RG_CONSLDATIONS_PK — the primary key constraint enforcing CONSOLIDATION_ID uniqueness.
  • PAYMENT_ID_REF linkage — associates consolidation rows with payment records in the JA payments sub-ledger.
  • RG23AP2 / RG23CP2 / PLA transaction tables in the JA module, which supply the underlying BED, SED, OED, and CESS values summarized here.
  • Standard EBS audit columns reference FND_USER via CREATED_BY and LAST_UPDATED_BY.