Search Results ego_style_variant_attr_vs




Overview
Explore in AI Chat

Overview

EGO_STYLE_VARIANT_ATTR_VS is a table within the EGO schema, belonging to the Advanced Product Catalog module of Oracle E-Business Suite. It stores the value set used by each style item for each variant attribute. In the context of Oracle EBS 12.1.1 and 12.2.2, this table bridges style items (configurable or template-based items) and the value sets that constrain the allowable values of their variant attributes. It is central to the variant configuration model, where a style item defines a family of related products differentiated by variant attributes such as color, size, or material.

Documentation classifies this object under ETRM as a standalone table. From a Data Vault modeling perspective, the mined foreign-key structure suggests it functions as a link-like association between style items and value sets rather than a pure hub or satellite. This interpretation should be treated as a heuristic modeling suggestion, since the table associates two business entities—style items and value sets—for each variant attribute.

Key Information Stored

The table contains eight documented columns. The most significant are:

No surrogate primary key column is documented in the provided metadata. The combination of INVENTORY_ITEM_ID, ATTRIBUTE_ID, and VALUE_SET_ID serves as the principal business-key candidate that uniquely associates a value set with a style item and attribute.

Common Use Cases and Queries

This table supports variant configuration setup, validation, and reporting. Typical scenarios include identifying which value sets govern a style item's variant attributes, auditing value set assignments across style items, and tracing how variant attribute values are constrained during configuration.

A common query pattern joins to the value set table to retrieve value set details:

  • SELECT vs.INVENTORY_ITEM_ID, vs.ATTRIBUTE_ID, vs.VALUE_SET_ID FROM EGO.EGO_STYLE_VARIANT_ATTR_VS vs WHERE vs.INVENTORY_ITEM_ID = :item_id;
  • SELECT vs.INVENTORY_ITEM_ID, vs.ATTRIBUTE_ID, pvs.VALUE_SET_NAME FROM EGO.EGO_STYLE_VARIANT_ATTR_VS vs, FRM.FRM_PART_VALUE_SETS pvs WHERE vs.VALUE_SET_ID = pvs.VALUE_SET_ID;

Reporting use cases include generating configuration setup reports showing, for each style item, the attributes and their associated value sets, and validating that every variant attribute has a designated value set before item publication.

Related Objects

The most significant related object is the value set definition table referenced by the documented foreign key:

  • FRM_PART_VALUE_SETS — joined via EGO_STYLE_VARIANT_ATTR_VS.VALUE_SET_ID = FRM_PART_VALUE_SETS.VALUE_SET_ID.

Additional dependent or referenced objects include the inventory item master (EGO_ITEM / MTL_SYSTEM_ITEMS), which supplies the style item identified by INVENTORY_ITEM_ID, and variant attribute definition tables within the Advanced Product Catalog module that supply ATTRIBUTE_ID context. Interfaces and concurrent programs in the EGO product family that manage item and variant attribute configuration also consume or populate this table.