Results for “xla_mo_reporting_ent_mrc_v”

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 Subledger Accounting (XLA) reporting view that exposes the organizational hierarchy relevant to multi-organization (MO) and multi-reporting-currency (MRC) accounting configurations. It presents three distinct reporting levels — set of books, legal entity, and operating unit — as a unified, de-normalized result set. Its principal role is to resolve the relationship between operating units, legal entities, and their associated sets of books so that XLA reporting and integration processes can attribute subledger transactions to the correct accounting entity and reporting context.

The view is defined by a series of UNION ALL branches distinguished by a REPORTING_LEVEL literal: '1000' for the set of books level, '2000' for the legal entity level, and '3000' for the operating unit level. Notably, several of its join conditions and filters are driven by ORG_INFORMATION descriptive flexfield segments, making the view a direct consumer of organization classification flexfield data. This is the reason searches for org_information3 resolve to this object.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the documented referenced base objects are:

• FND_PRODUCT_GROUPS (synonym) — supplies the MULTI_ORG_FLAG, which must equal 'Y' for the legal entity and operating unit branches to return rows.
• GL_SETS_OF_BOOKS (view) — provides the set of books name and identifier for the reporting level '1000' branch.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — the translated organization name source, filtered by LANGUAGE = USERENV('LANG').
• HR_ORGANIZATION_INFORMATION (synonym) — the organization information flexfield table, aliased multiple times (OI, LE, OU, OU1, OU2) to resolve classification, legal entity accounting, and operating unit information contexts.

Because HR_ORGANIZATION_INFORMATION is referenced repeatedly with different ORG_INFORMATION_CONTEXT values, the view effectively pivots key flexfield segments into relational columns used as join keys and output values.

Key Columns

• REPORTING_LEVEL — literal flag identifying the hierarchy tier ('1000', '2000', '3000').
• ENTITY_NAME — the set of books name or organization name for the row.
• ENTITY_ID — the set of books ID or organization ID.
• OPERATING_UNIT_ID — populated with the operating unit organization ID at level '3000'; -9999 at higher levels.
• LEGAL_ENTITY_ID — the legal entity organization ID, or -9999 at the set of books level.
• SET_OF_BOOKS_ID / SET_BOOKS_ID — the accounting set of books, derived from ORG_INFORMATION1 (legal entity accounting) or ORG_INFORMATION3 (operating unit information).

The ORG_INFORMATION3 segment is central: at level '2000' it links the legal entity's ORG_INFORMATION1 to the operating unit's ORG_INFORMATION3, and at level '3000' it supplies the set of books ID directly.

Common Use Cases and Queries

Typical uses include resolving the operating unit to set of books mapping for subledger reporting, and validating organization flexfield configuration. A sample query listing operating units and their accounting context:

• SELECT reporting_level, entity_name, operating_unit_id, legal_entity_id, set_of_books_id FROM xla_mo_reporting_ent_mrc_v WHERE reporting_level = '3000';
• SELECT * FROM xla_mo_reporting_ent_mrc_v WHERE set_of_books_id = :p_sob_id;
• SELECT entity_name, set_of_books_id FROM xla_mo_reporting_ent_mrc_v WHERE reporting_level = '2000';

Note that the set of books branch relies on USERENV('CLIENT_INFO'), so results are sensitive to the session's client information context. Queries should account for the -9999 placeholder values returned for inapplicable hierarchy levels.