Results for “pon_auc_doctypes”

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

Overview

PON_AUC_DOCTYPES is a Sourcing (PON) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the catalog of negotiation document types — the master definitions of auction, RFQ, and bid document templates used throughout the Oracle Sourcing application. Each row defines a distinct document type that governs behavior, layout, and business rules for negotiations created against it. Because Sourcing negotiations, auction headers, bid headers, and templates all point back to a single doctype definition, this table functions as the reference (lookup) dimension for the entire negotiation document lifecycle. Its heuristic Data Vault classification is hub, reflecting a stable business entity keyed by DOCTYPE_ID with descriptive attributes and downstream satellites; treating it as a hub is a reasonable modeling suggestion when designing a warehouse layer over EBS Sourcing.

Key Information Stored

The table contains 14 documented columns in the PON schema. The most significant are:

• DOCTYPE_ID — the surrogate primary key, defined by the unique index PON_AUC_DOCTYPES_PK. It is the join column used by all dependent tables.
• INTERNAL_NAME — the internal system identifier for the document type; a business-key candidate via unique index PON_AUC_DOCTYPES_U2 when combined with ZD_EDITION_NAME.
• SCOPE — indicates the coverage of the document type within the negotiation process.
• STATUS — the active/inactive state controlling whether the type is selectable at runtime.
• TRANSACTION_TYPE — classifies the negotiation transaction the type represents.
• MESSAGE_SUFFIX — the token appended to messages when the type is used in processing or messaging.
• DOCTYPE_GROUP_NAME — groups related document types for presentation and filtering.
• DOCUMENT_TYPE_CODE and DOCUMENT_SUBTYPE — the coded classification used to distinguish document variants.
• ZD_EDITION_NAME — the edition tag used in the 12.2.x online patching/editioning model, present in both unique indexes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns tracking who created and last modified each row.

The unique indexes PON_AUC_DOCTYPES_U1 (DOCTYPE_ID, ZD_EDITION_NAME) and PON_AUC_DOCTYPES_U2 (INTERNAL_NAME, ZD_EDITION_NAME) confirm the surrogate/business key separation, with ZD_EDITION_NAME supporting editioned access in 12.2.2.

Common Use Cases and Queries

Typical scenarios include resolving the document type name for a negotiation, enumerating active document types for setup validation, and joining from auction or bid headers to classify negotiations. A common query pattern joins the header to the document type:

• SELECT h.AUCTION_HEADER_ID, dt.INTERNAL_NAME, dt.DOCUMENT_TYPE_CODE FROM PON_AUCTION_HEADERS_ALL h, PON_AUC_DOCTYPES dt WHERE h.DOCTYPE_ID = dt.DOCTYPE_ID;
• SELECT DOCTYPE_ID, INTERNAL_NAME, STATUS FROM PON_AUC_DOCTYPES WHERE STATUS = 'ACTIVE'; (active types for LOV or setup checks)
• Join PON_AUC_DOCTYPES_TL on DOCTYPE_ID to retrieve translated names for multilingual reporting.

Report use cases include inventory of negotiation types by group, audit of which types are in use across auctions and bids, and business-rule validation via PON_AUC_DOCTYPE_RULES.

Related Objects

The table is referenced by several significant Sourcing objects, all joining on DOCTYPE_ID:

• PON_AUCTION_HEADERS_ALL — auction header records referencing the negotiation document type.
• PON_AUCTION_TEMPLATES — reusable negotiation templates tied to a document type.
• PON_AUC_BIZRULE_VALUES — business-rule values scoped by document type.
• PON_AUC_DOCTYPES_TL — translated (language) descriptions of the document types.
• PON_AUC_DOCTYPE_RULES — rules governing each document type.
• PON_DOCTYPE_STYLES — style/formatting definitions associated with the type.
• PON_BID_HEADERS and PON_BID_HEADERS_ARCH — bid header and archived bid records referencing the type.

Together these objects form the negotiation document framework, with PON_AUC_DOCTYPES acting as the central reference hub.