Search Results fun_rule_criteria_pub




Overview
Explore in AI Chat

Overview

FUN_RULE_CRITERIA_PUB is a public PL/SQL API package in the APPS schema that exposes the rule criteria maintenance functionality used by Oracle E-Business Suite's Financials Common Module (formerly Enterprise Transaction Rules Management, ETRM). Rule criteria define the conditional expressions that determine when an accounting or transaction rule applies — for example, the conditions under which a specific account derivation, tax determination, or subledger mapping rule is selected. This package is the public-facing wrapper that encapsulates the underlying manipulation logic while enforcing the standard EBS API conventions, including dependency on FND_API for error handling and message retrieval.

The object is classified as a PUB (public) API, meaning it is designed for external invocation rather than internal-only use. Its status is VALID in the documented environment. The package functions as a controlled entry point to rule criteria records, shielding callers from the direct table structures while allowing programmatic creation and maintenance of criteria used by the validation engine.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures and functions within this package. Parameter lists are intentionally omitted here since they are not contained in the source metadata.

  • CREATE_RULE_CRITERIA — Inserts a new rule criteria record into the underlying FUN_RULE_CRITERIA table, establishing a new conditional definition associated with a rule. This is the primary entry point for provisioning criteria programmatically.
  • UPDATE_RULE_CRITERIA — Modifies an existing rule criteria record, allowing changes to the criterion definition, associated rule, or related attributes.
  • GET_RULE_CRITERIA_REC — Retrieves a single rule criteria record, typically returning the full column set for a specified criterion so that callers can inspect or reuse the definition.
  • DELETE_RULE_CRITERIA — Removes a rule criteria record, supporting cleanup or removal of obsolete conditions.

Together these procedures form a complete CRUD surface over rule criteria, consistent with the pattern used by other _PUB packages in the Financials Common Module.

Tables Accessed

The package reads and writes the FUN_RULE_CRITERIA table (via the APPS synonym). This table is the repository for the individual criterion records that are evaluated when the rules engine determines whether a given rule's conditions are satisfied. Because the package is the public interface, all DML against FUN_RULE_CRITERIA in supported customizations should flow through these procedures rather than through direct SQL, ensuring that validation and error-handling logic in FND_API are applied consistently.

Usage Notes

FUN_RULE_CRITERIA_PUB is referenced by two other packages, notably FUN_RULE_VALIDATE_PKG, which indicates that the validation package consumes these procedures to construct and maintain criteria during rule validation processing. It is also referenced internally by its wrapper FUN_RULE_CRITERIA_PUB_W and by itself, reflecting standard EBS layering where a private or working package (the _W variant) orchestrates calls into the public API.

Typical invocation occurs during rule configuration — from EBS forms or concurrent programs within the Financials Common Module setup flows — and from custom code that needs to seed or migrate rule criteria. Custom developers should invoke the _PUB package rather than manipulating FUN_RULE_CRITERIA directly, and should check the standard FND_API return status and error message outputs after each call. Because parameter signatures are not reproduced in the ETRM excerpt, developers must consult the package specification in the APPS schema on the target release (12.1.1 or 12.2.2) before coding calls, as binding variables and defaults can differ between releases.