Search Results pon_auc_bizrule_values




Overview
Explore in AI Chat

Overview

The PON_AUC_BIZRULE_VALUES table is a core data repository within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It functions as a lookup and configuration table designed to store the permissible or assigned values for negotiation business rules. Business rules in Oracle Sourcing govern the behavior and constraints of negotiation documents, such as RFQs and auctions. This table provides the necessary linkage between a defined business rule, a specific document type, and the concrete value that rule takes for that context. Its role is critical for enforcing procurement policies and ensuring consistent negotiation setup across the enterprise.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a rule value configuration. The key columns are BIZRULE_ID, which references the specific business rule from the PON_AUC_BIZRULES table, and DOCTYPE_ID, which references the applicable document type from the PON_AUC_DOCTYPES table. The third primary key column, LOOKUP_CODE, stores the actual value for the rule. This value is typically a code from a lookup type (e.g., 'YES', 'NO', 'REQUIRED') that defines the rule's setting for the given document type. The table's design allows for multiple values (LOOKUP_CODE) to be associated with a single rule and document type combination, supporting rules that may have a set of valid options.

Common Use Cases and Queries

A primary use case is the validation and population of business rule options during the creation of a negotiation document. When a user selects a document type, the application queries this table to determine which rules are applicable and what values are permitted. For reporting and administration, queries often join this table to its parent tables to generate lists of configured rules. A typical diagnostic query to see all rule values for a specific document type would be:

  • SELECT br.rule_name, dt.doctype_name, brv.lookup_code
  • FROM pon_auc_bizrule_values brv,
  • pon_auc_bizrules br,
  • pon_auc_doctypes dt
  • WHERE brv.bizrule_id = br.bizrule_id
  • AND brv.doctype_id = dt.doctype_id
  • AND dt.doctype_name = 'Standard Auction';

Related Objects

The PON_AUC_BIZRULE_VALUES table maintains defined foreign key relationships with two key parent tables in the Sourcing schema, as documented in the ETRM metadata.

  • PON_AUC_BIZRULES: This table defines the master list of available business rules. The relationship is established via the column PON_AUC_BIZRULE_VALUES.BIZRULE_ID, which references PON_AUC_BIZRULES.
  • PON_AUC_DOCTYPES: This table defines the negotiation document types (e.g., RFQ, Auction). The relationship is established via the column PON_AUC_BIZRULE_VALUES.DOCTYPE_ID, which references PON_AUC_DOCTYPES.

These relationships ensure referential integrity, meaning a rule value cannot exist without a valid parent business rule and document type.