Results for “standard_value_source_id”

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

Overview

The SO_STANDARD_VALUE_RULES table, owned by the OE (Order Entry) schema, is a configuration and defaults repository used by Oracle E-Business Suite Order Management. The object is described as "Standard value rules," meaning it stores the rule definitions that drive automatic defaulting and standard value substitution for order attributes such as pricing context, order type, and related descriptive flexfield values. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the standard value rule sets that control how attribute values are populated on sales orders and pricing entities during order capture and processing.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This is a modeling suggestion only: the table connects a standard value rule set to an attribute and to a standard value source, forming the associative record between these dimensions. The link classification reflects its role as a relationship table rather than as a pure descriptive satellite, though the table also carries attribute value and override control columns that behave in a satellite-like manner.

Key Information Stored

The table contains 45 documented columns. The most significant columns are grouped below.

• STANDARD_VALUE_RULE_ID — surrogate primary key, enforced by the constraint SO_STANDARD_VALUE_RULES_PK and the unique index SO_STANDARD_VALUE_RULES_U1. This is the internal identifier for each standard value rule.
• STANDARD_VALUE_RULE_SET_ID — foreign key to SO_STANDARD_VALUE_RULE_SETS; identifies the rule set to which the rule belongs and participates in the primary business-key candidates.
• ATTRIBUTE_ID — foreign key to SO_ATTRIBUTES; identifies the attribute whose value is being defaulted or standardized. It is part of both UK1 (ATTRIBUTE_ID, SEQUENCE_NUMBER, STANDARD_VALUE_RULE_SET_ID) and UK2 (ATTRIBUTE_ID, STANDARD_VALUE_RULE_SET_ID, STANDARD_VALUE_SOURCE_ID).
• STANDARD_VALUE_SOURCE_ID — identifies the source from which the standard value is derived; it forms part of the UK2 business key.
• SEQUENCE_NUMBER — establishes evaluation order among rules and participates in UK1.
• ATTRIBUTE_VALUE — holds the standard value supplied by the rule.
• OVERRIDE_ALLOWED_FLAG — indicates whether a user may override the standardized value.
• OVERRIDE_EXISTING_VALUE_FLAG — indicates whether the rule replaces a value already present on the entity.
• PRICING_CONTEXT and PRICING_ATTRIBUTE1 through PRICING_ATTRIBUTE15 — capture the pricing context and pricing descriptive attributes used to scope rule applicability.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield context and segment columns that allow extensible rule metadata.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

The documented unique indexes distinguish the surrogate key (STANDARD_VALUE_RULE_ID) from the composite business-key candidates UK1 and UK2 described above.

Common Use Cases and Queries

Typical usage centers on auditing which standard value rule applies to a given attribute and rule set, and on validating defaulting behavior during order entry. A common pattern joins rules to their rule sets and attributes:

• Retrieving all rules for a rule set: SELECT * FROM SO_STANDARD_VALUE_RULES WHERE STANDARD_VALUE_RULE_SET_ID = :set_id ORDER BY SEQUENCE_NUMBER;
• Determining values for a specific attribute: join on ATTRIBUTE_ID and inspect ATTRIBUTE_VALUE, OVERRIDE_ALLOWED_FLAG, and OVERRIDE_EXISTING_VALUE_FLAG.
• Reporting the evaluation sequence and value source for each rule by joining to SO_STANDARD_VALUE_RULE_SETS and SO_ATTRIBUTES.

These queries support configuration review, impact analysis before changing rule sets, and troubleshooting of unexpected defaulted values on sales orders.

Related Objects

The following objects are most significant in relation to SO_STANDARD_VALUE_RULES, based on the documented foreign-key relationships:

• SO_STANDARD_VALUE_RULE_SETS — referenced via STANDARD_VALUE_RULE_SET_ID; parent of the rule set membership.
• SO_ATTRIBUTES — referenced via ATTRIBUTE_ID; defines the attribute being standardized.
• SO_STANDARD_VALUE_RULES_PK — primary key constraint on STANDARD_VALUE_RULE_ID.
• SO_STANDARD_VALUE_RULES_U1 — unique index on STANDARD_VALUE_RULE_ID.
• SO_STANDARD_VALUE_RULES_U2 — unique index on STANDARD_VALUE_RULE_SET_ID, ATTRIBUTE_ID, SEQUENCE_NUMBER.
• SO_STANDARD_VALUE_RULES_U3 — unique index on STANDARD_VALUE_SOURCE_ID, STANDARD_VALUE_RULE_SET_ID, ATTRIBUTE_ID.

Order Management defaulting and pricing logic consume these relationships when resolving standard values during order capture.