Search Results gl_system_setup_pk

Overview

GL_SYSTEM_SETUP_11I is a General Ledger configuration table in the GL schema that stores system-level setup information associated with each accounting set of books. In Oracle EBS 12.1.1 and 12.2.2, the object retains its legacy "11i" naming convention even though the underlying architecture has evolved, particularly with the introduction of ledger and subledger accounting concepts in Release 12. The table is primarily relevant to the accounting setup configuration layer that governs how General Ledger processes flexfield data and manages system resources for a given books context.

From a data modeling perspective, the ETRM metadata offers a heuristic Data Vault classification of satellite-leaning. This suggests that GL_SYSTEM_SETUP_11I is best modeled as a satellite table, since it describes attributes of a parent business entity — the set of books — rather than acting as an independent hub or a connecting link. Each row represents a descriptive record attached to a single set of books, reinforcing its satellite nature.

Key Information Stored

The table contains nine documented columns. The most significant are described below.

• SET_OF_BOOKS_ID — The primary business identifier and the column forming the unique index GL_SYSTEM_SETUP_U1. It establishes the one-to-one relationship between a setup record and its owning set of books.
• INDEXED_SEGMENT — Identifies which accounting flexfield segment is indexed, supporting query performance on segment-based reporting.
• RECORDS_TO_PROCESS — A processing parameter controlling the volume of records handled in a batch or setup operation.
• FLEX_CACHE_SIZE — Specifies the size of the flexfield value cache, influencing memory allocation for accounting flexfield validation.
• ARCHIVE_EASYLINK_FLAG — A flag governing EasyLink archiving behavior, relevant to historical interface and output processes.
• ROLLBACK_SEGMENT — Names the rollback segment associated with processing, a legacy oracle configuration attribute.
• CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — Standard audit columns recording row creation and last update context.

The documented surrogate primary key is GL_SYSTEM_SETUP_PK, defined on SET_OF_BOOKS_ID, which also serves as the unique business-key candidate via GL_SYSTEM_SETUP_U1.

Common Use Cases and Queries

Typical use cases center on diagnosing General Ledger configuration and performance-related parameters per set of books. Consultants and DBAs query this table to verify flexfield and rollback segment settings, particularly when investigating performance or configuration drift across environments.

A common reporting pattern joins the setup table to its parent books definition:

• SELECT s.SET_OF_BOOKS_ID, s.INDEXED_SEGMENT, s.FLEX_CACHE_SIZE, s.ROLLBACK_SEGMENT FROM GL.GL_SYSTEM_SETUP_11I s WHERE s.SET_OF_BOOKS_ID = :books_id;
• To identify all configured books with their setup attributes: SELECT g.NAME, s.FLEX_CACHE_SIZE, s.RECORDS_TO_PROCESS FROM GL.GL_SETS_OF_BOOKS_11I g JOIN GL.GL_SYSTEM_SETUP_11I s ON g.SET_OF_BOOKS_ID = s.SET_OF_BOOKS_ID;

Given the sparse column set, the table is less useful for transactional reporting and more valuable for configuration auditing and migration validation between instances.

Related Objects

The dominant relationship is with the parent set of books table.

• GL_SETS_OF_BOOKS_11I — Referenced through the foreign key GL_SYSTEM_SETUP_11I.SET_OF_BOOKS_ID → GL_SETS_OF_BOOKS_11I. This is the primary dependency and the join column for nearly every query against this table.
• GL_SYSTEM_SETUP_PK / GL_SYSTEM_SETUP_U1 — The primary key and unique index enforcing the one-record-per-books constraint.

Because the documented relationship data is limited to this single foreign key, broader dependencies are best confirmed through the GL application's accounting configuration and flexfield setup objects, which consume the parameters stored here.