Search Results ax_setup_books




Overview
Explore in AI Chat

Overview

AX_SETUP_BOOKS is a configuration table within the AX (Global Accounting Engine) schema of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores the accounting setup parameters that govern how the Global Accounting Engine processes and transfers subledger transactions into the General Ledger for each accounting book. Each row in AX_SETUP_BOOKS is keyed by a single set of books, making it the definitive record of AX-side configuration for a given ledger in a multi-organization or multi-book environment.

Because the table is keyed by SET_OF_BOOKS_ID and is referenced as a parent by the AX_SETUP_SUBLEDGERS table, the ETRM metadata classifies it as hub-leaning under a Data Vault heuristic. In Data Vault modeling terms, AX_SETUP_BOOKS functions as a hub: it holds the durable business key (the set of books identifier) that other AX objects reference, rather than acting as a transactional satellite or a link between two independent hubs. Modeling exercises should treat SET_OF_BOOKS_ID as the anchor key for this entity.

Key Information Stored

The table contains 11 documented columns and a primary key constraint, AX_SETUP_BOOKS_PK, defined solely on SET_OF_BOOKS_ID. A unique index, AX_SETUP_BOOKS_U1, also exists on SET_OF_BOOKS_ID, which confirms that this column serves simultaneously as the surrogate primary key and the sole business-key candidate — no other column or column combination is documented as uniquely identifying a row.

Common Use Cases and Queries

Typical uses center on verifying AX configuration for a ledger, auditing sequencing behavior, and joining setup data to subledger definitions. A common query retrieves the AX setup for all books in an instance:

SELECT asb.set_of_books_id,
       gsob.name AS book_name,
       asb.gl_sequencing_flag,
       asb.legal_sequencing_mode,
       asb.category_code,
       asb.fiscal_segment_value_low,
       asb.fiscal_segment_value_high
FROM   ax.ax_setup_books asb,
       gl.gl_sets_of_books gsob
WHERE  asb.set_of_books_id = gsob.set_of_books_id;

Other scenarios include identifying books where legal sequencing is enabled (filtering on LEGAL_SEQUENCING_MODE) ahead of a statutory audit, confirming the FISCAL_SEGMENT_VALUE_LOW/HIGH range before running AX transfer programs, and reconciling the AX book configuration against the corresponding subledger entries in AX_SETUP_SUBLEDGERS. Reporting teams frequently extract this table to a configuration inventory for change tracking, since the audit columns provide a clear history of setup modifications.

Related Objects

  • AX_SETUP_SUBLEDGERS — The primary dependent table, linked via AX_SETUP_SUBLEDGERS.MAIN_SET_OF_BOOKS_ID referencing AX_SETUP_BOOKS.SET_OF_BOOKS_ID. This FK establishes AX_SETUP_BOOKS as the parent hub.
  • GL_SETS_OF_BOOKS — The GL-side ledger definition joined on SET_OF_BOOKS_ID to resolve book names and attributes.
  • GL_LEDGERS (12.2.2) — The replacement ledger view in R12, commonly joined to validate the AX-configured book against the GL ledger setup.
  • GL_JE_CATEGORIES — Resolves the CATEGORY_CODE column to a journal category name.
  • GL_JE_BATCHES and GL_JE_HEADERS — Downstream journal objects whose AX-generated entries are governed by the sequencing flags configured here.

Collectively, these relationships confirm AX_SETUP_BOOKS as the anchor configuration entity for Global Accounting Engine book-level processing, with AX_SETUP_SUBLEDGERS as its principal child table.