Search Results po_doc_style_headers

Overview

PO_DOC_STYLE_HEADERS is a Purchasing (PO) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas, owned by the PO schema. It stores the definition of document styles that an enterprise uses to govern procurement authoring behavior. A document style is a configurable template of rules and feature toggles that determines which purchasing features are available to a user when creating or modifying a purchasing document, including which line types may be entered, whether advanced pricing constructs such as price breaks or price differentials are permitted, and whether approval routing is driven by AME or by workflow. The table therefore acts as the master reference for procurement document policy in a given operating unit or business configuration.

The ETRM metadata classifies the object heuristically as a standalone Data Vault entity, since no foreign key relationships were mined from the schema. In Data Vault modeling terms, this object is best treated as a hub candidate rather than a link or satellite. The natural business key is STYLE_ID, which is also the primary key constraint PO_DOC_STYLE_HEADERS_PK. A secondary unique index, PO_DOC_STYLE_HEADERS_U1, spans STYLE_ID and ZD_EDITION_NAME, reflecting the Editioning feature introduced in 12.2 and indicating that the object is edition-aware in that release. The documented physical schema contains 40 columns.

Key Information Stored

The most operationally significant columns are described below. The surrogate primary key is STYLE_ID, which uniquely identifies each document style record. Business-key candidates are represented by the unique index PO_DOC_STYLE_HEADERS_U1 (STYLE_ID, ZD_EDITION_NAME).

• STYLE_NAME and STYLE_DESCRIPTION: the human-readable identity and purpose of the style.
• STYLE_TYPE and STATUS: classify the style and indicate whether it is actively usable.
• STYLE_ID: surrogate primary key and the join column referenced throughout the application.
• ADVANCES_FLAG, RETAINAGE_FLAG, PROGRESS_PAYMENT_FLAG, and CONTRACT_FINANCING_FLAG: control availability of payment-related contracting features.
• PRICE_BREAKS_FLAG and PRICE_DIFFERENTIALS_FLAG: control advanced pricing constructs on lines.
• DELIVERABLE_HOLD_FLAG, ENHANCED_PRICING_FLAG, and COMPLEX_PRICING_FLAG: govern deliverable and pricing complexity options.
• LINE_TYPE_ALLOWED: restricts which line types a user may enter under the style.
• SINGLE_DISTRIBUTION_FLAG: limits distribution control on documents.
• CHANGE_PROCESS_TYPE and CTRL_ACTN_IN_CHGDOC_FLAG: define change-order behavior.
• WF_APPROVAL_ITEMTYPE and WF_APPROVAL_PROCESS: bind the style to its workflow approval definition.
• AME_TRANSACTION_TYPE and MOD_AME_TRANSACTION_TYPE: identify the AME transaction types used for approvals and modifications.
• ZD_EDITION_NAME: Editioning discriminator in 12.2.2.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Administrators and developers query this table to audit which features are enabled for a given style, to troubleshoot why a purchasing feature is unavailable to a user, and to reconcile approval routing configuration.

SELECT style_id, style_name, status, line_type_allowed
FROM   po.po_doc_style_headers
WHERE  status = 'ACTIVE';

SELECT style_name, wf_approval_itemtype, wf_approval_process, ame_transaction_type
FROM   po.po_doc_style_headers
WHERE  ame_transaction_type IS NOT NULL;

Reporting use cases include inventorying styles with contract financing or progress payment enabled, identifying styles using AME rather than workflow, and comparing feature flags across editions.

Related Objects

• PO_DOC_STYLE_LINES: detail lines linked by STYLE_ID.
• PO_HEADERS_ALL: purchasing documents referencing a style via STYLE_ID.
• PO_DOCUMENT_TYPES_ALL_B: document types associated with styles.
• PO_LINE_TYPES_B: line types governed by LINE_TYPE_ALLOWED.
• WF_ITEM_TYPES and WF_PROCESSES: referenced by WF_APPROVAL_ITEMTYPE and WF_APPROVAL_PROCESS.
• AME_TRANSACTION_TYPES: referenced by AME_TRANSACTION_TYPE and MOD_AME_TRANSACTION_TYPE.
• FND_DOCUMENT_SEQUENCES: sequence assignment for styled documents.
• PO_STYLE_HEADERS_API or equivalent public APIs used for style maintenance.