Search Results set_of_books_name

Overview

PA_GL_SET_OF_BOOKS_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) product family. It is documented as VALID in both ETRM 12.1.1 and 12.2.2. The view is defined to resolve the set of books (ledger) context associated with an implemented operating unit (OU), returning the primary and reporting currency attributes required by Projects forms, reports, and concurrent programs.

The view exists because Projects functionality relies on identifying which general ledger set of books is assigned to a given operating unit implementation, and on identifying any associated reporting set of books. Rather than requiring every consumer to join PA_IMPLEMENTATIONS to GL_SETS_OF_BOOKS and interpret MRC lookup codes independently, PA_GL_SET_OF_BOOKS_V encapsulates that logic in a single reusable object. The user search term "set_of_books_name" maps directly to the view's first exposed column, which carries the general ledger name from GL_SETS_OF_BOOKS.NAME.

Underlying Base Objects

The documented base objects referenced by the view are GL_SETS_OF_BOOKS (VIEW), GL_LOOKUPS (VIEW), GL_ALC_LEDGER_RSHIPS_V (VIEW), and PA_IMPLEMENTATIONS (SYNONYM).

The view text is a UNION ALL of two branches:

• Primary set of books branch. Joins GL_SETS_OF_BOOKS to PA_IMPLEMENTATIONS on SET_OF_BOOKS_ID, and to GL_LOOKUPS with LOOKUP_TYPE = 'MRC_SOB_TYPE' and LOOKUP_CODE = 'P', identifying the primary set of books for the implementation.
• Reporting set of books branch. Joins GL_ALC_LEDGER_RSHIPS_V (aliased GAL) to GL_SETS_OF_BOOKS, PA_IMPLEMENTATIONS, and GL_LOOKUPS. This branch matches the source ledger to the implementation's set of books, requires RELATIONSHIP_ENABLED_FLAG = 'Y', restricts to ORG_ID = -99 or the implementation's ORG_ID, and filters GAL.APPLICATION_ID = 275. The GL_LOOKUPS join uses LOOKUP_CODE = 'R' to designate the reporting set of books type.

Because the second branch reads GL_ALC_LEDGER_RSHIPS_V, the view supports both single-ledger and multi-reporting-currency (MRC) configurations.

Key Columns

• SET_OF_BOOKS_NAME — The general ledger name from GL_SETS_OF_BOOKS.NAME. This is the column most frequently referenced in ad hoc queries and integrations.
• CURRENCY — The currency code of the ledger. In the first branch it is SOB.CURRENCY_CODE; in the second branch it is GAL.CURRENCY_CODE.
• SET_OF_BOOKS_TYPE — Lookup meaning truncated to 30 bytes via SUBSTRB, describing the ledger type (primary or reporting).
• SET_OF_BOOKS_TYPE_CODE — The MRC_SOB_TYPE lookup code: 'P' for the primary set of books, 'R' for the reporting set of books.
• SET_OF_BOOKS_ID — In the primary branch, the implementation's SET_OF_BOOKS_ID; in the reporting branch, GAL.LEDGER_ID.
• ORG_ID — The operating unit identifier from PA_IMPLEMENTATIONS.

Common Use Cases and Queries

The view is typically queried to determine the ledger name and currency that Projects will use for a specific operating unit, or to list all reporting ledgers associated with a primary set of books. A representative query follows:

• SELECT set_of_books_name, currency, set_of_books_type_code, set_of_books_id, org_id FROM apps.pa_gl_set_of_books_v WHERE org_id = :p_org_id; — Retrieve ledger context for one operating unit.
• SELECT set_of_books_name, currency FROM apps.pa_gl_set_of_books_v WHERE set_of_books_type_code = 'P'; — List primary sets of books across implementations.
• SELECT set_of_books_name, set_of_books_type_code FROM apps.pa_gl_set_of_books_v WHERE set_of_books_name LIKE 'US%'; — Search by ledger name.

Note that a single ORG_ID may yield multiple rows when MRC reporting relationships are enabled, since the UNION ALL returns both the primary and reporting ledger entries.