Search Results style_allowed_value




Overview
Explore in AI Chat

Overview

PO_DOC_STYLE_VALUES is a Purchasing (PO) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the PO schema. It stores the discrete set of attribute values that a given purchasing document style is permitted to use. A document style in Oracle Purchasing defines the behavioral profile of a purchasing document — for example, whether a purchase order allows price overrides, whether it requires confirmation, or whether a receipt is mandatory. PO_DOC_STYLE_VALUES provides the controlled vocabulary behind each of those style attributes, allowing the application to validate and constrain the options presented against a style definition.

From a Data Vault modeling perspective, the mined heuristic classification places this object as a standalone table rather than a formal hub, link, or satellite. In practice it functions closest to a reference or lookup satellite: it is keyed by the style and attribute it qualifies, and it carries descriptive and state-bearing columns that describe allowed values rather than independent business entities.

Key Information Stored

The documented physical schema contains ten columns, anchored by a composite primary key and a related unique business-key index.

  • STYLE_ID — Foreign reference to the parent document style; the first component of the composite primary key.
  • STYLE_ATTRIBUTE_NAME — The name of the style attribute being constrained; the second component of the composite primary key.
  • STYLE_ALLOWED_VALUE — The specific permitted value for that attribute; the third component of the composite primary key and the column most frequently referenced in direct lookups.
  • ENABLED_FLAG — Indicates whether the allowed value is currently active for the style.
  • ZD_EDITION_NAME — The editioning column introduced under the 12.2 online patching architecture; it participates in the unique index PO_DOC_STYLE_VALUES_U1.
  • CREATION_DATE, CREATED_BY — Standard audit columns recording who created the row and when.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification and the session context of that change.

The surrogate primary key is defined by PO_DOC_STYLE_VALUES_PK over (STYLE_ID, STYLE_ATTRIBUTE_NAME, STYLE_ALLOWED_VALUE). The unique index PO_DOC_STYLE_VALUES_U1 adds ZD_EDITION_NAME to the same three columns, providing the business-key candidate that reconciles the 12.2 editioning model against the logical key.

Common Use Cases and Queries

Typical usage centers on retrieving the allowed value set for a style attribute and on validating whether a proposed value is acceptable. A query to enumerate all enabled values for a given style and attribute follows the pattern:

  • SELECT STYLE_ALLOWED_VALUE, ENABLED_FLAG FROM PO.PO_DOC_STYLE_VALUES WHERE STYLE_ID = :p_style_id AND STYLE_ATTRIBUTE_NAME = :p_attr AND ENABLED_FLAG = 'Y';
  • Validation queries that test membership of a candidate value against STYLE_ALLOWED_VALUE for the relevant STYLE_ID and STYLE_ATTRIBUTE_NAME.
  • Reporting joins to the style master to translate numeric STYLE_ID values back to descriptive style names.
  • Extract and migration scripts that reproduce style configuration across environments, selecting by STYLE_ID and honoring ZD_EDITION_NAME where editioning applies.

Because the table is small and configuration-driven, it is commonly extracted in full for audit reporting on how purchasing styles are configured, and it is frequently joined rather than queried in isolation.

Related Objects

The following objects are the most significant counterparts that reference or depend on PO_DOC_STYLE_VALUES:

  • PO_DOC_STYLES — The style master; joined on STYLE_ID, supplying the style name and context that PO_DOC_STYLE_VALUES qualifies.
  • PO_DOC_STYLE_ATTRS / style attribute definitions — Define the STYLE_ATTRIBUTE_NAME values constrained here.
  • PO_HEADERS_ALL — Purchasing documents that adopt a style and therefore inherit the allowed-value behavior defined by this table.
  • PO_DOC_STYLE_VALUES_PK and PO_DOC_STYLE_VALUES_U1 — The primary key constraint and unique index that enforce row integrity.
  • Purchasing document validation logic and the PO module's style-handling APIs, which consume these rows at runtime to constrain user entries.

The table carries no documented foreign keys to other objects, consistent with its standalone Data Vault classification; relationships are enforced through application logic and the STYLE_ID and STYLE_ATTRIBUTE_NAME values rather than declarative constraints.

  • Table: PO_DOC_STYLE_VALUES 12.2.2

    owner:PO,  object_type:TABLE,  fnd_design_data:PO.PO_DOC_STYLE_VALUES,  object_name:PO_DOC_STYLE_VALUES,  status:VALID,  product: PO - Purchasing ,  description: PO_DOC_STYLE_VALUES contains information for the values which are allowed based on a document style. ,  implementation_dba_data: PO.PO_DOC_STYLE_VALUES , 

  • View: PO_STYLE_ENABLED_PAY_ITEMS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PO.PO_STYLE_ENABLED_PAY_ITEMS,  object_name:PO_STYLE_ENABLED_PAY_ITEMS,  status:VALID,  product: PO - Purchasing ,  description: PO_STYLE_ENABLED_PAY_ITEMS contains information for the pay items which are allowed based on a document style. ,  implementation_dba_data: APPS.PO_STYLE_ENABLED_PAY_ITEMS , 

  • View: PO_STYLE_ENABLED_LINE_TYPES 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PO.PO_STYLE_ENABLED_LINE_TYPES,  object_name:PO_STYLE_ENABLED_LINE_TYPES,  status:VALID,  product: PO - Purchasing ,  description: PO_STYLE_ENABLED_LINE_TYPES contains information for the line types which are allowed based on a document style. ,  implementation_dba_data: APPS.PO_STYLE_ENABLED_LINE_TYPES , 

  • View: PO_STYLE_ENABLED_PAY_ITEMS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PO.PO_STYLE_ENABLED_PAY_ITEMS,  object_name:PO_STYLE_ENABLED_PAY_ITEMS,  status:VALID,  product: PO - Purchasing ,  description: PO_STYLE_ENABLED_PAY_ITEMS contains information for the pay items which are allowed based on a document style. ,  implementation_dba_data: APPS.PO_STYLE_ENABLED_PAY_ITEMS , 

  • View: PO_STYLE_ENABLED_LINE_TYPES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PO.PO_STYLE_ENABLED_LINE_TYPES,  object_name:PO_STYLE_ENABLED_LINE_TYPES,  status:VALID,  product: PO - Purchasing ,  description: PO_STYLE_ENABLED_LINE_TYPES contains information for the line types which are allowed based on a document style. ,  implementation_dba_data: APPS.PO_STYLE_ENABLED_LINE_TYPES ,