Search Results gl_system_setup

Overview

GL_SYSTEM_SETUP is a General Ledger configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores system-level setup information scoped to an individual ledger (set of books). The table is the authoritative repository for control flags and operating parameters that govern how General Ledger processes transactions, maintains balances, and applies accounting conventions for a given accounting representation.

The ETRM metadata classifies the object with a heuristic Data Vault designation of satellite-leaning. In Data Vault modeling terms, this suggests GL_SYSTEM_SETUP should be treated as a satellite hanging off the ledger hub (GL_SETS_OF_BOOKS), rather than as a standalone hub or a link table. Its descriptor attributes change over time, so the recommendation is to model it as a descriptive child of the ledger key. The table is keyed by the GL_SYSTEM_SETUP_PK primary key defined on SET_OF_BOOKS_ID, meaning a single setup record exists per ledger code combination.

The ETRM documentation notes that the object is "Not implemented in this database" for the specific extraction referenced, which indicates the table may be conditionally populated or absent depending on patch level, localization, or feature enablement.

Key Information Stored

Documented columns from the ETRM metadata are limited, but the following are the structural and functional elements of greatest importance:

• SET_OF_BOOKS_ID — The primary key column and sole documented business-key candidate. It uniquely identifies the ledger to which the setup record belongs and is the FK join to GL_SETS_OF_BOOKS.
• GL_SYSTEM_SETUP_PK — The named primary key constraint enforcing uniqueness on SET_OF_BOOKS_ID.
• System control flags — Additional configuration columns (not enumerated in the excerpt) store ledger-level switches such as journal approval requirements, suspense account handling, and accounting calendar linkage.
• Retained earnings and translation settings — Parameters governing how retained earnings are computed and how foreign currency balances are translated for reporting.
• Journal and reversal defaults — Options controlling automatic reversal, suspense posting, and journal entry validation behavior.

The surrogate key is effectively the same column as the business key here, since SET_OF_BOOKS_ID serves both roles. There is no separate generated sequence-based identifier documented.

Common Use Cases and Queries

Typical scenarios include auditing ledger configuration across multiple sets of books, validating that consistent accounting controls are applied, and driving concurrent program logic that reads ledger behavior at runtime.

SELECT gss.set_of_books_id, gsob.name, gsob.chart_of_accounts_id
FROM   gl_system_setup gss,
       gl_sets_of_books gsob
WHERE  gss.set_of_books_id = gsob.set_of_books_id;

SELECT set_of_books_id
FROM   gl_system_setup
WHERE  set_of_books_id = :p_ledger_id;

Reporting use cases include reconciling enabled ledgers against their setup rows, generating configuration baseline extracts for SOX or audit reviews, and supporting multi-org data migration checks where setup rows must exist for every active ledger.

Related Objects

• GL_SETS_OF_BOOKS — The parent table; joined on GL_SYSTEM_SETUP.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID. This is the only documented FK relationship.
• GL_LEDGERS — The 12.x ledger definition, mapping to sets of books for upgraded instances.
• GL_PERIOD_STATUSES — Open/close periods, used alongside setup flags to control posting.
• GL_JE_HEADERS / GL_JE_LINES — Journal entries whose validation and posting behavior depends on setup options.
• FND_ID_FLEX_STRUCTURES — Chart of accounts structure referenced through the ledger.
• GL_SYSTEM_SETUP forms and concurrent programs — The GL setup form and ledger maintenance programs that read and write this table.