Results for “reference_1”

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

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:

• APPLICATION_ID – Identifies the subledger application (references FND_APPLICATION); part of the composite primary key.
• MAIN_SET_OF_BOOKS_ID – Identifies the main set of books for which the subledger parameters apply; also part of the primary key.
• TRANSLATE_EVENTS – Controls whether accounting events are translated during processing.
• SECURE_POSTING – Governs posting security behavior for the configured subledger.
• IPV_AUTOMATIC_PROCESSING – Determines automatic processing for inter-company payables variance.
• PPV_AUTOMATIC_PROCESSING – Determines automatic processing for purchase price variance.
• INTER_COMPANY_BALANCING_FLAG – Indicates whether inter-company balancing applies for this subledger setup.
• PERIOD_FROM / PERIOD_TO – Define the effective period range for which the parameters apply.
• REFERENCE_1 through REFERENCE_5 – Generic descriptive/attribute columns available for setup-specific values.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard audit columns following Oracle EBS conventions.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – Concurrency program context columns recording which process last modified the row.

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.