Results for “consolidation_method”

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

Overview

The APPS.GL_CONS_SET_ASSIGNMENTS_V view is a consolidated reporting object within the Oracle E-Business Suite General Ledger module. It presents the assignment of consolidation definitions to consolidation sets, enriched with descriptive attributes drawn from the source ledger and consolidation method configuration. The view is owned by the APPS schema and is documented in ETRM for both Oracle EBS 12.1.1 and 12.2.2.

Its principal role is to expose the relationship between a consolidation set (GL_CONS_SET_ASSIGNMENTS) and the consolidation definition it references (GL_CONSOLIDATION), while resolving foreign-key identifiers into human-readable values. The view resolves the consolidation method code to its lookup meaning, and resolves the source ledger identifiers to short name and descriptive name using the GL_FC_XLATE_PKG package. This makes it suitable for reporting, reconciliation, and integration scenarios where consumers require a denormalized, presentation-ready representation of consolidation set membership.

The object is especially relevant when users query on consolidation_method, because the view exposes both the raw METHOD_CODE and the translated METHOD_MEANING drawn from the CONSOLIDATION_METHOD lookup type. This dual exposure allows filtering by code or by descriptive meaning, and it supports the analysis of which consolidation method is applied to each set assignment.

Underlying Base Objects

The view is defined over the following documented base objects:

• GL_CONS_SET_ASSIGNMENTS (SYNONYM) — supplies the consolidation set assignment rows, including CONSOLIDATION_SET_ID and the associated CONSOLIDATION_ID.
• GL_CONSOLIDATION (SYNONYM) — supplies consolidation definition attributes: NAME, DESCRIPTION, METHOD, FROM_LEDGER_ID, FROM_CURRENCY_CODE, and COA_MAPPING_ID.
• GL_LEDGERS (SYNONYM) — supplies source ledger attributes: SHORT_NAME, NAME, LEDGER_ID, CHART_OF_ACCOUNTS_ID, ENABLE_AVERAGE_BALANCES_FLAG, PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE, and FROM_CURRENCY_CODE.
• GL_COA_MAPPINGS (SYNONYM) — supplies the mapping definition dates START_DATE_ACTIVE and END_DATE_ACTIVE.
• GL_LOOKUPS (VIEW) — supplies the lookup meaning for the CONSOLIDATION_METHOD lookup type, joined on LOOKUP_CODE = CONS.METHOD.
• GL_FC_XLATE_PKG (PACKAGE) — invoked for GET_LEDGER_SHORT_NAME and GET_LEDGER_NAME to translate ledger identifiers into presentation values.

The joins are inner joins across these objects, keyed on consolidation_id, ledger_id, and coa_mapping_id, with the lookup constrained to lookup_type = 'CONSOLIDATION_METHOD'.

Key Columns

• ROW_ID — the ROWID of the underlying GL_CONSOLIDATION row.
• CONSOLIDATION_SET_ID — identifier of the consolidation set to which the definition is assigned.
• CONSOLIDATION_ID — identifier of the consolidation definition.
• NAME / DESCRIPTION — the consolidation definition name and description.
• METHOD_CODE — the raw consolidation method code (CONS.METHOD).
• METHOD_MEANING — the translated lookup meaning for the CONSOLIDATION_METHOD lookup type; this is the column most relevant to queries on consolidation_method.
• FROM_LEDGER_ID, FROM_SHORT_NAME, FROM_LEDGER_NAME — the source ledger and its resolved short and descriptive names.
• FROM_CHART_OF_ACCOUNTS_ID, ADB_ENABLED_FLAG, CALENDAR, PERIOD_TYPE — source ledger accounting configuration attributes.
• FROM_CURRENCY_CODE — the source ledger currency passed to the translation package.
• START_DATE_ACTIVE, END_DATE_ACTIVE — effective dates of the associated chart of accounts mapping.

Common Use Cases and Queries

Typical scenarios include auditing consolidation set membership, verifying which consolidation method applies to each assignment, and reporting on source ledger configuration for consolidation definitions.

• List all consolidation set assignments with their translated method meaning.
• Filter by consolidation method to determine which sets use a given method.
• Report source ledger names, calendars, and currencies for consolidation assignments.
• Identify mappings by active date range.

Sample query:

• SELECT consolidation_set_id, consolidation_id, name, method_code, method_meaning, from_short_name, from_ledger_name, calendar, period_type, start_date_active, end_date_active FROM apps.gl_cons_set_assignments_v WHERE method_meaning = :p_method;

Because the view resolves ledger names and lookup meanings at query time, it is well suited for ad-hoc reporting and for integration extracts that require descriptive rather than coded values.