Search Results attr_group_id




Overview
Explore in AI Chat

Overview

The EGO_FINANCIAL_REPORTING_AGV view is a reporting construct in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and delivered as part of the EGO — Advanced Product Catalog product family. It exists to expose the attribute group values that back the Financial Reporting descriptive flexfield context attached to the product category set. In practical terms, the view flattens the internal descriptive flexfield metadata join required to resolve which category-set attribute group stores financial reporting values, and then returns the category-set identification and flex value set linkage associated with that attribute group.

Because the view is a read-only projection over the EGO extension tables, it is well suited to reporting, data extraction, and integration scenarios where a downstream consumer needs the financial reporting attribute group without replicating the two-step lookup against the descriptive flexfield context definition. The object is documented as VALID in ETRM, confirming it is a supported catalog object rather than an ad-hoc customization.

Underlying Base Objects

The view is defined over two documented base objects, both reached through synonyms in the APPS schema:

The join is expressed as an OR condition: the outer row qualifies when its ATTR_GROUP_ID matches the attribute group returned for either flex context code, both anchored to APPLICATION_ID = 431 and DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_PRODUCT_CATEGORY_SET'. This is important for the user searching on the term attr_group_id — that column is the pivot of the view's filtering logic rather than a projected output column, so it does not appear in the select list.

Key Columns

The view projects five columns, all sourced from EGO_PRODUCT_CAT_SET_EXT:

  • CATEGORY_SET_ID — identifies the category set to which the financial reporting values belong.
  • CATEGORY_ID — the specific catalog category within that category set.
  • TOP_NODE — the top-of-hierarchy node reference for the category structure.
  • VALUE_ID — the flex value identifier associated with the category set value.
  • FLEX_VALUE_SET_ID — the flex value set that governs the valid values available for the associated flex segment.

Common Use Cases and Queries

The principal use case is retrieving the financial reporting attribute group mapping for a given product category set, typically to drive reporting on catalog categorization or to feed an integration that requires the flex value set linkage. A representative query:

  • SELECT category_set_id, category_id, top_node, value_id, flex_value_set_id FROM apps.ego_financial_reporting_agv WHERE category_set_id = :p_category_set_id;
  • SELECT category_set_id, flex_value_set_id FROM apps.ego_financial_reporting_agv ORDER BY category_set_id, category_id;

Because the view encapsulates the attr_group_id resolution, consumers avoid hard-coding the APPLICATION_ID = 431 and descriptive flexfield context constants, ensuring the lookup remains aligned with Oracle's delivered metadata.