Search Results ego_product_category_set

Overview

APPS.EGO_FINANCIAL_REPORTING_AGV is an Oracle E-Business Suite view owned by the APPS schema. It presents the subset of product category set data that is associated with the FinancialReporting descriptive flexfield context of the EGO_PRODUCT_CATEGORY_SET flexfield, exposed through a naming convention (the "_AGV" suffix) typical of "Attributes Group View" objects used by Oracle's attribute-grouping and descriptive flexfield infrastructure. The view is not a stored table; it is a read-only projection that joins the product category set extension table to the descriptive flexfield context extension table so that consumers can retrieve category set, category, top node, value, and flex value set identifiers without having to resolve the flexfield context codes themselves.

In Oracle EBS 12.1.1 and 12.2.2, the object is relevant wherever financial reporting category sets are configured for product information management and attribute-grouping flows. Because the view hard-codes the flexfield name EGO_PRODUCT_CATEGORY_SET and the FinancialReporting context codes, it provides a stable, pre-filtered interface for reports, concurrent programs, and integrations that need only the financial reporting slice of product category set data. This makes it useful when generating financial reporting hierarchies, populating downstream reporting structures, or validating which category sets and value sets participate in financial reporting.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both surfaced to the APPS schema as synonyms:

• EGO_PRODUCT_CAT_SET_EXT — the product category set extension table that stores the descriptive flexfield attribute values for product category sets, keyed by ATTR_GROUP_ID along with CATEGORY_SET_ID, CATEGORY_ID, TOP_NODE, VALUE_ID, and FLEX_VALUE_SET_ID.
• EGO_FND_DSC_FLX_CTX_EXT — the descriptive flexfield context extension table used here in two correlated subqueries to resolve the ATTR_GROUP_IDs that correspond to the FinancialReporting and FinancialReportingValues context codes for the EGO_PRODUCT_CATEGORY_SET flexfield (APPLICATION_ID 431).

Functionally, the view filters EGO_PRODUCT_CAT_SET_EXT down to rows whose ATTR_GROUP_ID matches either context, joining the two extension tables through the attribute group identifier rather than through a conventional foreign key. Both referenced objects are documented as synonyms in the APPS schema, which is consistent with the view being defined in APPS and depending on the EGO product information management schema underneath.

Key Columns

• CATEGORY_SET_ID — identifier of the product category set to which the flexfield attribute row belongs.
• CATEGORY_ID — identifier of the category associated with the category set row.
• TOP_NODE — the top (root) node designation for the category hierarchy or reporting structure.
• VALUE_ID — the flex value identifier associated with the attribute row, used to link to the underlying flex value definition.
• FLEX_VALUE_SET_ID — identifier of the flex value set that governs the values available for the financial reporting attribute.

Together these columns describe which category set/category combinations are registered for financial reporting, the root of their hierarchy, and the value set that supplies their values. The view exposes no additional derived or descriptive columns; it is a thin, purpose-built projection of the extension table.

Common Use Cases and Queries

Typical scenarios include retrieving the financial reporting configuration for a specific category set, identifying which flex value sets back financial reporting values, and joining the view to category set and flex value set reference tables for reporting extracts.

• List all financial reporting rows for a category set:

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;

• Find the value sets used in financial reporting:

SELECT DISTINCT flex_value_set_id
FROM   apps.ego_financial_reporting_agv;

• Join to a category set reference table to display descriptive names:

SELECT v.category_set_id, cs.category_set_name, v.category_id, v.top_node
FROM   apps.ego_financial_reporting_agv v,
       apps.ego_category_sets_vl cs
WHERE  v.category_set_id = cs.category_set_id;

Because the context codes are fixed within the view definition, callers do not need to resolve ATTR_GROUP_IDs manually. Privileges should be granted through the APPS schema, and queries should filter by CATEGORY_SET_ID where possible to limit the scan of the underlying extension table.