Search Results jl_zz_gl_axi_models




Overview
Explore in AI Chat

Overview

JL_ZZ_GL_AXI_MODELS is a table in the JL schema (Latin America Localizations) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Accounting Models — reusable definitions of accounting entry generation rules used by the Latin America localization extensions that integrate with Oracle General Ledger. Each row represents one named accounting model, scoped to a specific ledger via its SET_OF_BOOKS_ID reference to GL_SETS_OF_BOOKS. The ZZ prefix indicates a localization/customization artifact rather than standard Oracle application object naming.

From the FK topology, the table behaves as a satellite-leaning entity: it is a descriptive master with an owning parent relationship upstream (GL_SETS_OF_BOOKS) and dependent child detail rows downstream (JL_ZZ_GL_AXI_MODEL_RANGES). In Data Vault terms it functions as a hub with attached satellite attributes, keyed by MODEL_ID and contextualized by ledger.

Key Information Stored

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

Because the primary key is a surrogate (MODEL_ID) and the unique index is on the same column, no separate natural business key is documented; NAME combined with SET_OF_BOOKS_ID is the practical logical identifier, though uniqueness is not enforced by a documented unique index.

Common Use Cases and Queries

Typical uses include localization setup review, ledger-level model inventory reporting, and validation that each model carries at least one range definition.

List models for a given ledger:

  • SELECT MODEL_ID, NAME, DESCRIPTION FROM JL_ZZ_GL_AXI_MODELS WHERE SET_OF_BOOKS_ID = :ledger_id ORDER BY NAME;

Find orphaned models (no ranges defined):

  • SELECT m.MODEL_ID, m.NAME FROM JL_ZZ_GL_AXI_MODELS m WHERE NOT EXISTS (SELECT 1 FROM JL_ZZ_GL_AXI_MODEL_RANGES r WHERE r.MODEL_ID = m.MODEL_ID);

Reconcile models against the ledger name:

  • SELECT m.NAME, g.NAME AS ledger_name FROM JL_ZZ_GL_AXI_MODELS m, GL_SETS_OF_BOOKS g WHERE m.SET_OF_BOOKS_ID = g.SET_OF_BOOKS_ID;

Audit models created or changed within a date range using the WHO columns.

Related Objects

  • JL_ZZ_GL_AXI_MODEL_RANGES — child table; joined on MODEL_ID. Holds the ranges/segments that make up each model.
  • GL_SETS_OF_BOOKS — parent ledger table; joined on SET_OF_BOOKS_ID.
  • JL_ZZ_GL_AXI_MODELS_PK — primary key constraint on MODEL_ID.
  • JL_ZZ_GL_AXI_MODELS_U1 — unique index on MODEL_ID.
  • General Ledger localization accounting programs that consume the model and range definitions during entry generation.