Results for “gl_mrc_reporting_sob_profile_v”

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

Overview

The GL_MRC_REPORTING_SOB_PROFILE_V view is a General Ledger reporting object that exposes the set of books designated as reporting sets of books within the Multiple Reporting Currencies (MRC) framework. MRC allows an organization to maintain a primary set of books and one or more reporting sets of books, each using a different functional currency, so that the same transactions can be reported and analyzed in multiple currencies. This view provides a streamlined profile — set of books identifier, name, short name, and currency code — limited to those sets of books flagged as reporting books (the MRC_SOB_TYPE_CODE = 'R' condition).

Because the view carries only descriptive profile attributes rather than transactional balances, its role is primarily as a lookup or validation source for reporting logic, concurrent programs, and integrations that must identify the available reporting sets of books. The selection of the SHORT_NAME column is significant: reporting tools, cross-reference reports, and user-facing name references frequently resolve a set of books by its short name, which is the concise identifier auditors and finance users recognize.

Underlying Base Objects

Although the documented metadata records no referenced base objects, the view text reveals its two operational sources:

• GL_SETS_OF_BOOKS — aliased SB, this is the primary set of books definition table. The view extracts only rows where MRC_SOB_TYPE_CODE = 'R', meaning the reporting set of books classification. From this table it derives SET_OF_BOOKS_ID, NAME, SHORT_NAME, and CURRENCY_CODE.
• GL_LOOKUPS — aliased LU, this general lookup table supplies a synthetic placeholder row. The UNION adds a record with SET_OF_BOOKS_ID = -1, NAME taken from the lookup meaning (N/A), and NULL values for SHORT_NAME and CURRENCY_CODE. This sentinel value enables report parameters and prompts to present a "not applicable" option without failing validation.

The view therefore behaves as a condensed, union-based projection over the set of books definition structure, filtered to the MRC reporting subtype.

Key Columns

• SET_OF_BOOKS_ID — The unique internal identifier of the set of books. The synthetic N/A row uses the reserved value -1.
• NAME — The descriptive name of the reporting set of books, or the lookup meaning N/A for the placeholder row.
• SHORT_NAME — The abbreviated identifier of the reporting set of books. Because the placeholder row returns NULL here, any logic relying on short_name must tolerate a null value when the N/A option is selected. This is the column most commonly referenced by report titles, listings, and cross-references.
• CURRENCY_CODE — The functional currency of the reporting set of books. This is the currency into which the reporting books translate their balances, distinguishing one reporting book from another. It is NULL for the placeholder row.

Common Use Cases and Queries

Typical uses include populating reporting set of books list of values, validating a reporting book selection in a concurrent program, and driving currency-specific reporting joins.

Listing all reporting sets of books by short name:

SELECT set_of_books_id, name, short_name, currency_code
FROM   gl_mrc_reporting_sob_profile_v
ORDER BY short_name NULLS LAST;

Excluding the placeholder row when a valid short name is required:

SELECT set_of_books_id, short_name
FROM   gl_mrc_reporting_sob_profile_v
WHERE  short_name IS NOT NULL;

Joining to reporting balances by book identifier:

SELECT p.short_name, p.currency_code, b.period_name, b.begin_balance
FROM   gl_mrc_reporting_sob_profile_v p,
       gl_balances b
WHERE  b.set_of_books_id = p.set_of_books_id
AND    p.short_name IS NOT NULL;

Because the view is documented as "Not implemented in this database" in the ETRM 12.2.2 metadata, availability must be confirmed in the target instance; in 12.1.1 and 12.2.2 environments where MRC is enabled, it remains a lightweight and dependable source for reporting set of books identification.