Search Results all_operating_units

Overview

AX_SETUP_POSTING_BOOKS_V is a reporting view within the AX – Global Accounting Engine (Global Accounting Engine) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The view exposes the setup configuration of posting book rules defined in the AX_SETUP_POSTING_BOOKS table, joining those rules to the applications, ledgers (sets of books), and operating units that give the otherwise numeric identifiers their business meaning. Its principal role is to provide a human-readable, query-friendly presentation of the mapping between a source organization (operating unit) and the ledger and posting ledger combination used by the Global Accounting Engine when it transfers and posts accounting entries.

The view is not a transactional or reporting fact object; it is a configuration and setup view. It is typically used by implementers and support analysts to validate how subledger accounting events will be routed to the correct ledger for a given operating unit, and to reconcile differences between source and posting ledgers across multiple organizations.

Underlying Base Objects

The view is defined over the following documented base objects:

• AX_SETUP_POSTING_BOOKS (PB) — the driving table holding the posting book rules, including rule name, ledger identifiers, organization identifiers, and the various flags controlling GL transfer and suspense behavior.
• FND_APPLICATION_VL (A) — supplies APPLICATION_NAME for the owning application.
• GL_SETS_OF_BOOKS (SOB1, SOB2) — aliased twice to resolve the main ledger name and the posting ledger name from MAIN_SET_OF_BOOKS_ID and POSTING_SET_OF_BOOKS_ID respectively.
• HR_OPERATING_UNITS (OU) — supplies the operating unit NAME for records where SOURCE_ORG_ID is not zero.
• AX_LOOKUPS (L) — used in the second branch of the UNION to supply the meaning "ALL_OPERATING_UNITS" for records where SOURCE_ORG_ID equals zero.

The view text is a UNION of two queries. The first handles organization-specific rules (SOURCE_ORG_ID <> 0) and joins HR_OPERATING_UNITS to resolve the source organization name. The second handles the wildcard case (SOURCE_ORG_ID = 0), where the rule applies to all operating units, and substitutes the AX_LOOKUPS meaning for the organizational name.

Key Columns

• ROW_ID — the ROWID of the underlying AX_SETUP_POSTING_BOOKS row, unique per record.
• APPLICATION_ID / APPLICATION_NAME — the owning application identifier and its descriptive name.
• MAIN_SET_OF_BOOKS_ID / MAIN_SET_OF_BOOKS_NAME — the primary ledger and its name.
• SOURCE_ORG_ID / SOURCE_ORG_NAME — the source operating unit identifier and its resolved name; returns "ALL_OPERATING_UNITS" when the identifier is zero, indicating the rule applies globally.
• POSTING_SET_OF_BOOKS_ID / POSTING_SET_OF_BOOKS_NAME — the target ledger for posting and its name.
• RULE_NAME — the user-defined posting rule identifier.
• TRANSFER_TO_GL, GL_POST_REQUIRED, EZL_REQUIRED, ERROR_TO_SUSPENSE_ACCNT — configuration flags governing transfer, GL posting, encumbrance, and error handling.
• JE_LINE_TYPE, RULE_CHANGED_FLAG — journal line classification and a change-indicator flag.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

A frequent requirement is searching for the source organization name associated with a posting rule. The query below returns all rules and their resolved organization names:

SELECT source_org_id, source_org_name, main_set_of_books_name,
       posting_set_of_books_name, rule_name, transfer_to_gl
  FROM ax_setup_posting_books_v
 ORDER BY source_org_name;

To isolate the wildcard "all operating units" rules:

SELECT rule_name, source_org_name, posting_set_of_books_name
  FROM ax_setup_posting_books_v
 WHERE source_org_id = 0;

To confirm the posting configuration for a specific operating unit by name:

SELECT source_org_name, main_set_of_books_name,
       posting_set_of_books_name, je_line_type
  FROM ax_setup_posting_books_v
 WHERE source_org_name = :org_name;

Because the view resolves IDs to names and normalizes the wildcard case, it is well suited to ad hoc diagnosis of Global Accounting Engine behavior, regression checking after setup changes, and validation of ledger routing across multi-organization implementations.