Results for “ax_setup_books_u1”

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

Overview

AX.AX_SETUP_BOOKS is a Subledger Accounting setup table owned by the AX schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores setup parameters at the set of books level, and its contents are maintained through the Subledger Setup screen. In practical terms, the table defines per-ledger control flags and sequencing parameters that govern how the journal sequencing program operates within a given set of books. Each row corresponds to one set of books, identified by SET_OF_BOOKS_ID.

The documentation for this object is limited to its physical structure, dependency information, and column comments; no procedural or view logic is documented in the repository metadata. From a Data Vault modeling perspective, the mined relationship structure classifies AX.AX_SETUP_BOOKS as hub-leaning: SET_OF_BOOKS_ID functions as a durable business key and no descriptive change histories are modeled on this object. Where a set of books (ledger) hub is already established in an enterprise data warehouse, AX.AX_SETUP_BOOKS maps naturally to a satellite carrying the sequencing and fiscal segment attributes described below.

Key Information Stored

The table contains eleven columns. The principal ones are:

• SET_OF_BOOKS_ID (NUMBER) — The set of books identifier and the single-column primary key (AX_SETUP_BOOKS_PK). It is also the business-key candidate exposed through the unique index AX_SETUP_BOOKS_U1.
• GL_SEQUENCING_FLAG (VARCHAR2) — Controls whether GL sequencing behavior is enabled for the set of books.
• LEGAL_SEQUENCING_MODE (VARCHAR2, 30) — The legal sequencing mode applied during journal sequencing.
• CATEGORY_CODE (VARCHAR2, 30) — The category code consumed by the journal sequencing program.
• FISCAL_SEGMENT_VALUE_LOW (VARCHAR2, 25) — The lowest balancing segment value considered by the journal sequencing program.
• FISCAL_SEGMENT_VALUE_HIGH (VARCHAR2, 25) — The highest balancing segment value considered by the journal sequencing program.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns providing creation and change audit information.

The distinction between the surrogate primary key and business keys is straightforward here: SET_OF_BOOKS_ID serves as both the primary key of the table and the unique business key (via AX_SETUP_BOOKS_U1), so no separate surrogate column exists. This means AX_SETUP_BOOKS is effectively keyed one-to-one with the set of books.

Common Use Cases and Queries

Typical use cases include auditing ledger-level sequencing configuration prior to closing periods, verifying that fiscal segment ranges and category codes align with the accounting calendar, and reconciling the AX schema setup against the General Ledger ledger definitions.

A standard audit query is simply:

• SELECT SET_OF_BOOKS_ID, GL_SEQUENCING_FLAG, LEGAL_SEQUENCING_MODE, CATEGORY_CODE, FISCAL_SEGMENT_VALUE_LOW, FISCAL_SEGMENT_VALUE_HIGH FROM AX.AX_SETUP_BOOKS ORDER BY SET_OF_BOOKS_ID;

A segmented-range query identifies books where a low/high fiscal range has been configured:

• SELECT SET_OF_BOOKS_ID, FISCAL_SEGMENT_VALUE_LOW, FISCAL_SEGMENT_VALUE_HIGH FROM AX.AX_SETUP_BOOKS WHERE FISCAL_SEGMENT_VALUE_LOW IS NOT NULL OR FISCAL_SEGMENT_VALUE_HIGH IS NOT NULL;

Because the table is small and keyed by SET_OF_BOOKS_ID, it can be joined directly to ledger and subledger setups without concern for cardinality blowup. It also supports quick validation of standard Who columns to identify stale or manually updated setup records.

Related Objects

The documented foreign key relationship places AX_SETUP_BOOKS at the parent end of AX_SETUP_SUBLEDGERS: the child column AX_SETUP_SUBLEDGERS.MAIN_SET_OF_BOOKS_ID references SET_OF_BOOKS_ID. This parent-child link means a single book can be associated with multiple subledger setup rows.

• AX.AX_SETUP_SUBLEDGERS — Child table joined via AX_SETUP_SUBLEDGERS.MAIN_SET_OF_BOOKS_ID = AX_SETUP_BOOKS.SET_OF_BOOKS_ID.
• AX.AX_SETUP_BOOKS# — The documented subtype/synonym reference under the AX schema; queries against the base object should account for it where applicable.
• Standard EBS ledger views, such as GL_SETS_OF_BOOKS and GL_LEDGERS, join on the same SET_OF_BOOKS_ID column and are commonly used to enrich sequencing configuration with ledger names and currencies.
• Journal sequencing and legal sequencing program logic consumes GL_SEQUENCING_FLAG, LEGAL_SEQUENCING_MODE, CATEGORY_CODE, and FISCAL_SEGMENT_VALUE_LOW/HIGH from this table.

No other database objects are documented as directly referenced by AX.AX_SETUP_BOOKS.