Search Results pon_auc_doctypes

Overview

The PON_AUC_DOCTYPES table is a core reference table within the Oracle E-Business Suite Sourcing (PON) module. It functions as the master repository for defining and storing the distinct types of negotiation documents available in the application. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the sourcing lifecycle, as every negotiation—whether a Request for Quotation (RFQ), Reverse Auction, or other sourcing event—must be associated with a valid document type. The table's primary role is to enforce data integrity and provide a centralized lookup for document type definitions, which subsequently control the behavior, rules, and validations applicable to a specific negotiation.

Key Information Stored

The table's structure is centered on the DOCTYPE_ID column, which serves as the unique primary key identifier for each document type. While the provided metadata does not list all columns, the existence of a corresponding translation table (PON_AUC_DOCTYPES_TL) indicates that the base table likely contains language-independent code columns, such as an internal NAME or CODE. The translation table would store the user-facing, language-specific NAME and DESCRIPTION. The core table may also include system-level columns like CREATION_DATE, CREATED_BY, and ENABLED_FLAG to manage the lifecycle of these reference codes within the application.

Common Use Cases and Queries

A primary use case is retrieving the list of active document types for setup or reporting purposes. System administrators and functional implementers reference this table when configuring sourcing rules and templates. A typical query involves joining with the translation table to get user-readable names in a specific language. For example, to find all document types used by active auction templates, one might execute:

SELECT dtl.name, COUNT(t.template_id)
FROM pon_auc_doctypes d, pon_auc_doctypes_tl dtl, pon_auction_templates t
WHERE d.doctype_id = dtl.doctype_id
AND dtl.language = USERENV('LANG')
AND d.doctype_id = t.doctype_id
GROUP BY dtl.name;

Another critical use is data validation and troubleshooting, where support personnel trace document type assignments from a specific negotiation header back to its master definition to understand configured behaviors.

Related Objects

The PON_AUC_DOCTYPES table has several key foreign key relationships, as documented, making it a central hub in the sourcing data model:

• PON_AUCTION_HEADERS_ALL: Links via DOCTYPE_ID. This is the most critical relationship, as it classifies every sourcing negotiation.
• PON_AUCTION_TEMPLATES: Links via DOCTYPE_ID. Associates document types with reusable template configurations.
• PON_AUC_BIZRULE_VALUES: Links via DOCTYPE_ID. Stores business rule settings specific to each document type.
• PON_AUC_DOCTYPES_TL: Links via DOCTYPE_ID. Provides the translated names and descriptions for the document types.
• PON_AUC_DOCTYPE_RULES: Links via DOCTYPE_ID. Defines specific functional and validation rules attached to a document type.