Search Results ax_setup_subledgers




Overview
Explore in AI Chat

Overview

The AX_SETUP_SUBLEDGERS table is a configuration table within the AX - Global Accounting Engine product of Oracle E-Business Suite. It stores subledger dependent parameters used by the Global Accounting Engine to control how accounting events originating in various subledgers are processed and posted to the general ledger. Each row defines the setup rules for a specific combination of application (subledger source) and main set of books, making the table central to how the AX engine interprets and balances transactions at the subledger level.

The table resides in the AX schema and is classified as a VALID object at 12.1.1 and 12.2.2. Documented physical metadata indicates 23 columns and a unique index, AX_SETUP_SUBLEDGERS_U1, defined on (APPLICATION_ID, MAIN_SET_OF_BOOKS_ID), which also serves as the primary key constraint AX_SETUP_SUBLEDGERS_PK. The heuristic Data Vault classification derived from the foreign key structure is satellite-leaning, suggesting that this table is best modeled as a descriptive satellite attached to the business keys APPLICATION_ID and MAIN_SET_OF_BOOKS_ID, which are themselves hubs of FND_APPLICATION and GL_SETS_OF_BOOKS respectively.

Key Information Stored

The most significant columns capture subledger processing rules and audit tracking:

The surrogate/business key is the composite (APPLICATION_ID, MAIN_SET_OF_BOOKS_ID); there is no single-column surrogate. The remaining columns are descriptive attributes, consistent with the satellite classification.

Common Use Cases and Queries

Typical scenarios include verifying that subledger processing flags are consistently configured across operating units and sets of books, auditing changes to posting behavior, and diagnosing discrepancies in automatic variance processing. A representative query retrieving setup for a given book:

  • SELECT application_id, main_set_of_books_id, translate_events, secure_posting, inter_company_balancing_flag FROM ax.ax_setup_subledgers WHERE main_set_of_books_id = :sob_id;
  • Reporting on automatic processing configuration: SELECT a.application_name, s.* FROM ax.ax_setup_subledgers s, fnd_application a WHERE s.application_id = a.application_id;
  • Auditing recent changes: SELECT * FROM ax.ax_setup_subledgers WHERE last_update_date > SYSDATE - 30;

Related Objects

The following tables reference or are referenced by AX_SETUP_SUBLEDGERS based on documented FK relationships:

  • AX_SETUP_BOOKS – Referenced via MAIN_SET_OF_BOOKS_ID.
  • GL_SETS_OF_BOOKS – Referenced via MAIN_SET_OF_BOOKS_ID.
  • FND_APPLICATION – Referenced via APPLICATION_ID.
  • AX_SETUP_INV_ORG_PROCS – Child table joining on APPLICATION_ID and MAIN_SET_OF_BOOKS_ID.
  • AX_SETUP_POSTING_BOOKS – Child table joining on APPLICATION_ID and MAIN_SET_OF_BOOKS_ID.