Search Results jl_zz_gl_axi




Overview
Explore in AI Chat

Overview

JL_ZZ_GL_AXI is a Latin America Localizations (JL) table that stores the inflation adjustment gain and loss account assignments used by the region's inflation adjustment processes. In Oracle EBS 12.1.1 and 12.2.2, the table maps a specific account (identified through GL_CODE_COMBINATIONS) to a specific ledger (identified through the SET_OF_BOOKS_ID) so that the inflation adjustment engine can post the calculated gain or loss to the correct accounting flexfield combination.

The object is documented as a table owned by the JL schema with status VALID. Its documented physical schema lists 23 columns, with a primary key constraint JL_ZZ_GL_AXI_PK defined on CODE_COMBINATION_ID and SET_OF_BOOKS_ID, and a unique index JL_ZZ_GL_AXI_U1 on the same column pair. Under a heuristic Data Vault classification, this table is best modeled as a link: it connects an accounting flexfield combination (GL_CODE_COMBINATIONS) to a ledger (GL_SETS_OF_BOOKS), capturing the many-to-many account-to-ledger assignment for inflation adjustment gain/loss accounts. This classification is a modeling suggestion derived from the foreign key structure rather than a documented property of the table.

Key Information Stored

The most significant columns are:

  • SET_OF_BOOKS_ID — the ledger identifier; part of the composite primary key and foreign key to GL_SETS_OF_BOOKS.
  • CODE_COMBINATION_ID — the accounting flexfield combination identifier; part of the composite primary key and foreign key to GL_CODE_COMBINATIONS. This is the gain/loss account used by the inflation adjustment.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns tracking who created and last modified each assignment.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield and 15 generic attribute columns reserved for localization extensions and customer-specific configuration.

The surrogate primary key is JL_ZZ_GL_AXI_PK, composed of CODE_COMBINATION_ID and SET_OF_BOOKS_ID. The unique index JL_ZZ_GL_AXI_U1 covers the same pair, making that combination the documented business-key candidate that guarantees a single gain/loss account mapping per ledger. No separate synthetic identifier column is documented in the ETRM schema listing.

Common Use Cases and Queries

Typical scenarios include validating that a gain/loss account exists for a ledger before running inflation adjustment, and reporting which accounting flexfield combination is configured per ledger.

  • Retrieve the gain/loss account for a ledger: 
    SELECT ax.code_combination_id, ax.set_of_books_id
FROM   jl.jl_zz_gl_axi ax
WHERE  ax.set_of_books_id = :p_set_of_books_id;
  • Join to GL_CODE_COMBINATIONS for the account string: 
    SELECT ax.set_of_books_id, cc.concatenated_segments
FROM   jl.jl_zz_gl_axi ax,
       gl_code_combinations_kfv cc
WHERE  ax.code_combination_id = cc.code_combination_id
AND    ax.set_of_books_id  = :p_set_of_books_id;
  • Cross-check ledger metadata via GL_SETS_OF_BOOKS to confirm the ledger name and chart of accounts.
  • Detect missing or duplicate configurations by testing the PK columns for NULLs or unexpected multiplicity.

These queries support period-close reconciliation, inflation adjustment setup review, and audit of localization account assignments.

Related Objects

The most significant related objects are:

  • GL_CODE_COMBINATIONS — referenced through JL_ZZ_GL_AXI.CODE_COMBINATION_ID; provides the accounting flexfield combination for the gain/loss account.
  • GL_SETS_OF_BOOKS — referenced through JL_ZZ_GL_AXI.SET_OF_BOOKS_ID; identifies the ledger the mapping belongs to.
  • JL_ZZ_GL_AXI_PK and JL_ZZ_GL_AXI_U1 — the primary key constraint and unique index that enforce one gain/loss account per ledger.
  • Inflation adjustment programs and concurrent processes in the JL module that read these assignments to derive the posting account during adjustment runs.
  • GL_CODE_COMBINATIONS_KFV and other GL reporting views that surface the account string for the CODE_COMBINATION_ID.