Search Results validate_re_object




Overview
Explore in AI Chat

Overview

SYS.DBMS_RULEADM_INTERNAL is the internal administrative package that underpins the Oracle Server Rule Manager (RuleSet/Rule) infrastructure used throughout Oracle E-Business Suite 12.1.1 and 12.2.2. The Rule Manager allows applications to define evaluation contexts, rule sets, and individual rules whose conditions are evaluated at runtime to drive configurable business behavior. DBMS_RULEADM_INTERNAL is the implementation side of the Rule Manager administration interface; it is not intended for direct customer invocation but is the engine invoked by the documented DBMS_RULE_ADM package and by EBS-internal callers. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, an important characteristic because it is owned by SYS and exposed through APPS synonyms. In EBS it participates in the broader Rule Manager stack that supports features such as advanced pricing, approval management, and other rule-driven processing. The nv_list term the user searched for appears in the package signature as the datatype parameter sys.re$nv_list, which represents a name-value list used to carry action-context definitions and internal action-context definitions into rule creation and alteration operations.

Key Procedures and Functions

  • I_CREATE_EVAL_CTX — Creates an evaluation context, accepting a context name, table aliases, variable types, an evaluation function, a comment, and context properties.
  • I_CREATE_RULE_SET — Creates a rule set bound to an evaluation context, with optional comment, properties, and a result-cache flag.
  • I_CREATE_RULE — Creates a rule within a rule set, defining its condition, evaluation context, action context (an sys.re$nv_list name-value list), comment, properties, and internal action-context/client parameters.
  • I_ALTER_RULE — Modifies an existing rule; condition, evaluation context, action context, and comment can each be set or removed, with corresponding remove flags and internal action-context parameters.
  • PATCH_RULE_PRIV — Adjusts rule privileges for a base table identified by schema and name together with a condition, used to reconcile privilege metadata.
  • VALIDATE_RE_OBJECT — Validates a Rule Manager object by name and namespace, ensuring the object is well formed and consistent.
  • REGISTER_INTERNAL_ACTX — Registers an internal action context, supporting the internal action-context mechanism referenced in rule creation and alteration.
  • UNREGISTER_INTERNAL_ACTX — Removes a previously registered internal action context.
  • I_EVALUATION_CONTEXT_ADD_VAR — Adds a variable to an existing evaluation context, extending the set of variables available to rule conditions.

Tables Accessed

The ETRM metadata for this object does not enumerate specific tables referenced through APPS synonyms. The package operates on the Rule Manager data dictionary, which is represented by the sys.re$ object types and their associated dictionary tables that store evaluation contexts, rule sets, rules, action contexts, and internal action-context registrations. The sys.re$nv_list and sys.re$table_alias_list types are the collection constructs through which action-context and table-alias metadata are passed into and persisted by these operations.

Usage Notes

DBMS_RULEADM_INTERNAL is an internal implementation package and should not be invoked directly by EBS customization or extension code. Customers and partners interact with the Rule Manager through the supported DBMS_RULE_ADM interface or through EBS application forms and concurrent programs that internally depend on this layer. The metadata records that this package is referenced by eight other packages, confirming its role as a low-level dependency within the Rule Manager stack. The presence of the nv_list datatype in I_CREATE_RULE and I_ALTER_RULE underscores that action contexts are passed as name-value collections rather than scalar arguments. Because the package runs AUTHID CURRENT_USER and is owned by SYS, any direct experimentation carries significant risk and is not supported; it should be treated as read-only reference material when diagnosing Rule Manager behavior in EBS 12.1.1 or 12.2.2.