Search Results reporting_level

Overview

FND_MO_REPORTING_ENTITIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the FND – Application Object Library product family and is used by the Multi-Org (MO) reporting infrastructure to expose the set of reporting entities that a given responsibility or user is authorized to access. The view consolidates ledger-level reporting entities from General Ledger into a single, security-filtered result set that downstream ETRM (Enterprise Tax Reporting and Management) and financial reporting components can query.

The view is particularly significant because it surfaces the COMPLETION_STATUS_CODE column, which reflects the configuration completion state of each ledger as recorded in GL_LEDGER_CONFIGURATIONS. Users searching for "completion_status_code" are typically trying to determine whether a ledger's configuration has been fully completed before allowing it to participate in tax or accounting reporting. The view returns a value such as 'C' (complete) or an incomplete indicator for ledgers that have not finished configuration setup, enabling reporting tools to suppress or flag incompletely configured ledgers.

Underlying Base Objects

The view is defined as a UNION ALL over two logically similar branches. The first branch joins GL_LEDGERS_PUBLIC_ALL_V and GL_LEDGERS to GL_LEDGER_CONFIGURATIONS on CONFIGURATION_ID, returning primary ledgers. The second branch handles ALC (Application Ledger Configuration) and secondary ledgers, sourcing TARGET_LEDGER_ID values from GL_LEDGER_RELATIONSHIPS where TARGET_LEDGER_CATEGORY_CODE is 'ALC' or 'SECONDARY', RELATIONSHIP_ENABLED_FLAG is 'Y', and RELATIONSHIP_TYPE_CODE is 'SUBLEDGER'. Documented base objects include GL_LEDGERS, GL_LEDGERS_PUBLIC_ALL_V, GL_LEDGER_CONFIGURATIONS, GL_LEDGER_RELATIONSHIPS, HR_OPERATING_UNITS, HR_ORGANIZATION_INFORMATION, MO_GLOBAL, and XLE_ENTITY_PROFILES.

Both branches are filtered by a security predicate that calls MO_GLOBAL.CHECK_ACCESS against operating unit organization IDs derived from HR_ORGANIZATION_INFORMATION, ensuring only authorized ledgers are returned.

Key Columns

• REPORTING_LEVEL – Hard-coded as '1000', indicating the ledger reporting level.
• ENTITY_NAME – The ledger name (GL.NAME).
• ENTITY_ID – The ledger identifier (GL.LEDGER_ID).
• OPERATING_UNIT_ID / LEGAL_ENTITY_ID – Returned as -9999 in the documented view text, acting as placeholders at the ledger level.
• LEDGER_ID – The governing ledger.
• CURRENCY_CODE – Ledger currency.
• LEDGER_CATEGORY_CODE – Primary, ALC, or Secondary designation.
• COMPLETION_STATUS_CODE – Sourced from GL_LEDGER_CONFIGURATIONS, indicating whether ledger configuration is complete.

Common Use Cases and Queries

Typical usage filters the view by completion status to exclude partially configured ledgers from reporting:

• Listing all reporting entities with completed configurations: SELECT ENTITY_NAME, LEDGER_ID, COMPLETION_STATUS_CODE FROM FND_MO_REPORTING_ENTITIES_V WHERE COMPLETION_STATUS_CODE = 'C';
• Auditing incomplete ledger setups: SELECT ENTITY_NAME, LEDGER_CATEGORY_CODE FROM FND_MO_REPORTING_ENTITIES_V WHERE COMPLETION_STATUS_CODE != 'C';
• Joining to XLE_ENTITY_PROFILES for legal entity reconciliation.
• Feeding ETRM tax reporting extracts scoped to authorized ledgers only.