Search Results bizrule_id




Overview
Explore in AI Chat

Overview

The PON_AUC_DOCTYPE_RULES table is a core intersection table within the Oracle E-Business Suite Sourcing (PON) module. It functions as a mapping entity that defines which specific business rules are applicable to a given negotiation document type. This table is essential for enforcing and managing the configurable business logic that governs the behavior of different sourcing documents, such as standard auctions, reverse auctions, or RFx processes. By maintaining these associations, the application ensures that the correct validations, workflows, and processing rules are applied based on the document's type, thereby supporting complex and varied sourcing methodologies.

Key Information Stored

The table's structure is straightforward, consisting primarily of two foreign key columns that form a composite primary key. This design enforces the unique association of a business rule to a document type. The key columns are:

  • BIZRULE_ID: A foreign key referencing the PON_AUC_BIZRULES table. This column identifies the specific business rule to be applied.
  • DOCTYPE_ID: A foreign key referencing the PON_AUC_DOCTYPES table. This column identifies the negotiation document type (e.g., Standard Auction, RFI) to which the rule is assigned.

The composite primary key constraint, PON_AUC_DOCTYPE_RULES_PK, on these two columns ensures that no duplicate rule-document type mappings can exist.

Common Use Cases and Queries

A primary use case is to audit or configure the set of rules active for a specific document type during implementation or troubleshooting. For instance, an administrator may need to verify all business rules enabled for a "Reverse Auction" document type. A typical query would join the related tables to provide meaningful descriptions:

SELECT dt.DOCTYPE_NAME, br.RULE_NAME, br.DESCRIPTION
FROM PON_AUC_DOCTYPE_RULES dr,
    PON_AUC_DOCTYPES dt,
    PON_AUC_BIZRULES br
WHERE dr.DOCTYPE_ID = dt.DOCTYPE_ID
AND dr.BIZRULE_ID = br.BIZRULE_ID
AND dt.DOCTYPE_NAME = 'Reverse Auction';

Conversely, to find all document types a particular rule affects, one would filter on the RULE_NAME. This table is also critical for backend logic; when a user creates a new negotiation, the application queries this table to determine the rule set to load and enforce for the session.

Related Objects

The PON_AUC_DOCTYPE_RULES table sits at the center of a key relationship between document type and business rule master data. Its integrity is maintained through defined foreign key constraints:

  • PON_AUC_BIZRULES: The table is referenced via the foreign key on PON_AUC_DOCTYPE_RULES.BIZRULE_ID. This table stores the master definition and logic for each available business rule.
  • PON_AUC_DOCTYPES: The table is referenced via the foreign key on PON_AUC_DOCTYPE_RULES.DOCTYPE_ID. This table contains the master list of negotiation document types configured in the system.

Any process or report that needs to understand the rule-to-document-type relationship must join through this intersection table. It has no direct foreign key relationships from other tables, as its purpose is to serve as a definitive reference for the application's runtime configuration.