Search Results so_attributes




Overview
Explore in AI Chat

Overview

The SO_ATTRIBUTES table is a core metadata repository within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for attributes that can be used within the Order Management system's advanced configuration rules. Its primary role is to define the characteristics and behavior of attributes that are subsequently utilized in constructing Security Rules and Standard Value Rule Sets. These rules govern data access and automate the defaulting of values during the order entry process, making SO_ATTRIBUTES a foundational component for implementing complex, attribute-based business policies.

Key Information Stored

The table stores the metadata that defines each configurable attribute. Key columns include the unique ATTRIBUTE_ID and a human-readable NAME. The ATTRIBUTE_CODE provides a programmatic identifier. The OBJECT_ID column is a critical foreign key to the SO_OBJECTS table, linking the attribute to a specific business object within Order Management, such as a line type or a price adjustment. The SEQUENCE_NUMBER dictates the display order of attributes within a user interface. Additional columns like DESCR_FLEX_APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME link the attribute to a specific Descriptive Flexfield context, enabling the capture of extended, user-defined information.

Common Use Cases and Queries

This table is primarily referenced during the setup and analysis of Order Management's rule-based systems. A common administrative task is to query all attributes available for a specific business object to configure a security or defaulting rule. For example, to list all attributes defined for a particular object identified by its OBJECT_ID, one might use:

SELECT attribute_code, name, sequence_number
FROM oe.so_attributes
WHERE object_id = <object_id_value>
ORDER BY sequence_number;

Another frequent use case is tracing the usage of a specific attribute across the system. Developers and functional consultants query SO_ATTRIBUTES to understand the underlying data elements referenced in pre-configured business rules before modifying them or troubleshooting issues related to security or value defaulting.

Related Objects

SO_ATTRIBUTES maintains integral relationships with several key Order Management tables, as documented by its foreign key constraints. It is a parent table to multiple rule definition tables: