Results for “jl_zz_gl_axi_model_ranges”

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

Overview

JL_ZZ_GL_AXI_MODEL_RANGES is a table owned by the JL schema within the Latin America Localizations (JL) product family of Oracle E-Business Suite. Its documented description, "Accounting Model Account Ranges," identifies it as a configuration repository that stores the account segment value ranges associated with a given accounting model. In the EBS 12.1.1 and 12.2.2 releases the table is marked VALID and forms part of the localization infrastructure used to drive automated accounting entry generation and account derivation logic for Latin American country-specific reporting.

Each row defines the lower and upper bounds of one or more accounting flexfield segments that, in combination, delimit a range of valid accounts for a specific model and ledger. The table therefore acts as a reference or mapping store rather than a transactional table, and its preservation metadata suggests it is relatively static once configured.

The heuristic Data Vault classification mined from the foreign key structure describes this object as a link. This is a modeling suggestion only: the table bridges two parent entities — JL_ZZ_GL_AXI_MODELS and GL_SETS_OF_BOOKS — by holding their respective identifiers alongside the descriptive range attributes.

Key Information Stored

The documented physical schema contains 83 columns. The most significant are summarized below; the remaining columns are either descriptive range attributes or audit/descriptive flexfield fields.

• MODEL_ID — Foreign key to JL_ZZ_GL_AXI_MODELS. Identifies the accounting model to which the range belongs and is the principal business-key candidate.
• SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS. Scopes the range to a specific ledger, ensuring model logic is applied only to the correct chart of accounts.
• SEGMENTn_LOW / SEGMENTn_HIGH — A paired set of range limits for accounting flexfield segments 1 through 30. These thirty low/high pairs define the account range the model applies to.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit trail capturing who created and last modified each range and when.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) storage supporting user-defined extensions without schema modification.

The surrogate primary key is not explicitly documented in the excerpt; in practice the table is keyed on MODEL_ID together with the range identifiers. MODEL_ID and SET_OF_BOOKS_ID are the documented foreign-key business-key candidates.

Common Use Cases and Queries

Typical usage centers on verifying and reporting which account ranges are governed by a given accounting model. A common query joins the ranges to their parent models and ledgers:

SELECT r.model_id, m.model_name, r.set_of_books_id,
       r.segment1_low, r.segment1_high
FROM   jl.jl_zz_gl_axi_model_ranges r,
       jl.jl_zz_gl_axi_models m,
       gl.gl_sets_of_books sob
WHERE  r.model_id = m.model_id
AND    r.set_of_books_id = sob.set_of_books_id
AND    r.set_of_books_id = :p_sob_id;

Other practical scenarios include: auditing range overlaps before enabling a model; diagnosing why an account was included or excluded from automated entry generation; exporting model configuration during a localization upgrade or migration to 12.2.2; and validating that low/high bounds align with the ledger's chart of accounts structure.

Related Objects

The most significant objects that reference or depend on JL_ZZ_GL_AXI_MODEL_RANGES are:

• JL_ZZ_GL_AXI_MODELS — Parent of the range rows; joined on MODEL_ID.
• GL_SETS_OF_BOOKS — Ledger definition; joined on SET_OF_BOOKS_ID.
• GL_CODE_COMBINATIONS — The account combinations that the segment ranges are used to match against.
• JL_ZZ_GL_AXI_MODELS_TL — Translated model names used in localization reporting joins.
• Latin American accounting engine routines — The application logic that reads this table to resolve account applicability during entry generation.

Because the table is a link between models and ledgers, its integrity depends directly on the JL_ZZ_GL_AXI_MODELS and GL_SETS_OF_BOOKS foreign keys documented above.