Results for “set_books_id”

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

Overview

The view APPS.XLA_MO_REPORTING_ENT_MRC_V is a multi-reporting-currency (MRC) reporting entity view delivered with the Oracle E-Business Suite Subledger Accounting (XLA) module. Its name reflects its purpose: XLA (Subledger Accounting), MO (Multi-Org), Reporting_Ent (reporting entity), and MRC (Multiple Reporting Currencies). It consolidates the set of books, legal entities, and operating units that participate in subledger accounting and reporting, presenting them through a single UNION-based structure keyed by a reporting_level discriminator.

This column exposes three distinct levels of the accounting entity hierarchy, each identified by a numeric literal: '1000' for set of books, '2000' for legal entity, and '3000' for operating unit. Because MRC allows reporting in currencies and ledgers beyond the primary, the view resolves the relationship between operating units, their associated legal entities, and the reporting set of books. It is used principally by XLA reporting programs, MRC reporting templates, diagnostics, and integration extracts that must determine the correct ledger context for a given operating unit within a multi-org environment.

Underlying Base Objects

ETRM documents the following base objects: FND_PRODUCT_GROUPS (synonym), GL_SETS_OF_BOOKS (view), HR_ALL_ORGANIZATION_UNITS_TL (synonym), and HR_ORGANIZATION_INFORMATION (synonym). Each UNION branch selects from a subset of these. HR_ORGANIZATION_INFORMATION is queried multiple times under distinct aliases (oi, le, ou, ou1, ou2) against different org_information_context values — notably 'CLASS', 'Legal Entity Accounting', and 'Operating Unit Information' — to extract the flexible attribute values (org_information1, org_information2, org_information3) that encode legal entity and set-of-books assignments. FND_PRODUCT_GROUPS supplies the multi_org_flag control, ensuring the multi-org branches only return rows when Multi-Org is enabled. HR_ALL_ORGANIZATION_UNITS_TL provides the translated organization name.

Critically, the view is server-gated by USERENV('CLIENT_INFO'), extracting the operating unit and set of books from fixed byte offsets (positions 1–10 and 45–54). This constrains rows to the current session's multi-org context, a standard EBS MRC security pattern.

Key Columns

• reporting_level — Discriminator: 1000 (set of books), 2000 (legal entity), 3000 (operating unit).
• entity_name — Name of the set of books or organization unit.
• entity_id — set_of_books_id or organization_id depending on level.
• operating_unit_id — Populated only at level 3000; -9999 elsewhere.
• legal_entity_id — Legal entity organization ID.
• set_of_books_id / set_books_id — Both variants resolve the ledger (the search term set_books_id maps here).

Common Use Cases and Queries

Typical usage resolves the reporting ledger for an operating unit or verifies MRC entity mappings:

SELECT reporting_level, entity_name, entity_id,
       operating_unit_id, legal_entity_id, set_of_books_id
  FROM apps.xla_mo_reporting_ent_mrc_v
 WHERE reporting_level = '3000';

Diagnostic queries filter on set_of_books_id to confirm which entities map to a reporting ledger, or join the view to XLA/GL reporting tables to attribute balances by entity level.