Search Results ax_orgs_sobs_v

Overview

The AX_ORGS_SOBS_V view belongs to the AX – Global Accounting Engine product family within Oracle E-Business Suite and exposes the relationship between sets of books (SOBs) and operating units (orgs) across the major subledger applications. Its documented description is "SOBs and Orgs relationships in subledger applications," which reflects the view's principal design intent: to present, in a single union-style result set, the set of books identifier and short name associated with each subledger operating unit. In releases 12.1.1 and 12.2.2, this is directly relevant to users searching on set_of_books_name, since the view surfaces the SET_OF_BOOKS_NAME column as a first-class attribute alongside an application identifier and an org identifier.

Because it consolidates relationships that otherwise reside in separate application setup tables, the view serves reporting and integration scenarios in which a report or concurrent program must translate an operating unit into its accounting book without querying multiple product-specific tables. Note that the ETRM documentation records this object as not implemented in this database, meaning it may not exist in every environment and should be validated before reliance.

Underlying Base Objects

The ETRM metadata documents no explicit referenced base objects, but the view text itself makes the dependencies clear. The view is a three-branch UNION in which each branch joins GL_SETS_OF_BOOKS to a subledger-specific parameters table:

• AP_SYSTEM_PARAMETERS_ALL — joined to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID, contributing a hard-coded APPLICATION_ID of 200 (Payables).
• AR_SYSTEM_PARAMETERS_ALL — joined to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID, contributing a hard-coded APPLICATION_ID of 222 (Receivables).
• ORG_ORGANIZATION_DEFINITIONS — joined to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID, contributing a hard-coded APPLICATION_ID of 401, with ORGANIZATION_ID mapped to ORG_ID.

In every branch, the set of books short name is drawn from GL_SETS_OF_BOOKS.SHORT_NAME, which is the column aliased as SET_OF_BOOKS_NAME. The view therefore inherits its book-level attributes entirely from the GL book definition while sourcing org context from each subledger.

Key Columns

• APPLICATION_ID — Identifies the originating subledger: 200 for Payables, 222 for Receivables, and 401 for the organization definitions branch. This column distinguishes which system the org-to-book row came from.
• SET_OF_BOOKS_ID — The internal identifier of the set of books, joined from each subledger parameters table or organization definition.
• SET_OF_BOOKS_NAME — The set of books short name from GL_SETS_OF_BOOKS.SHORT_NAME; this is the column users typically target when searching for "set_of_books_name."
• ORG_ID — The operating unit identifier. Payables and Receivables supply ORG_ID directly, whereas the 401 branch maps ORGANIZATION_ID to ORG_ID.

Common Use Cases and Queries

Typical usage includes resolving an operating unit to its set of books for cross-subledger reporting, validating that AP and AR operating units share a consistent book, and producing reference listings of books by application. A representative query follows:

• SELECT application_id, set_of_books_id, set_of_books_name, org_id FROM ax_orgs_sobs_v WHERE set_of_books_name = :book_name;
• SELECT DISTINCT set_of_books_name, org_id FROM ax_orgs_sobs_v WHERE application_id = 200 ORDER BY org_id;
• SELECT org_id, set_of_books_name FROM ax_orgs_sobs_v WHERE application_id = 222;

All such queries should be preceded by a check for object existence, given the documented "not implemented" status in the ETRM repository.