Search Results fun_rule_objects_pub




Overview
Explore in AI Chat

Overview

FUN_RULE_OBJECTS_PUB is a public PL/SQL API package owned by the APPS schema in Oracle E-Business Suite. It is classified as a PUB (public) API, meaning it is intended for invocation by other application modules, forms, and external integration code rather than being restricted to internal use. The package provides the programmatic interface for maintaining rule objects within the Oracle Subledger Accounting rule engine framework — the same infrastructure that supports rule-based validation and defaulting logic in Oracle Receivables and other financial modules. Rule objects represent the configurable entities against which rule criteria, parameters, and test results are evaluated. FUN_RULE_OBJECTS_PUB encapsulates the lifecycle operations for these objects: creation, maintenance, deletion, retrieval, and existence checks. As a documented public API, it forms part of the supported extension surface of the E-Business Suite, and its status is VALID in the reference environment for both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes eleven documented procedures and functions. The core lifecycle operations are CREATE_RULE_OBJECT, UPDATE_RULE_OBJECT, DELETE_RULE_OBJECT, and GET_RULE_OBJECT_REC. CREATE_RULE_OBJECT establishes a new rule object definition; UPDATE_RULE_OBJECT modifies an existing definition; DELETE_RULE_OBJECT removes it. GET_RULE_OBJECT_REC returns a rule object record for read access.

Each of these routines encapsulates the validation and persistence logic required so that callers need not manipulate the underlying tables directly.

Tables Accessed

The package operates against a defined set of FUN_ rule engine tables through APPS synonyms. Object definitions reside in FUN_RULE_OBJECTS_B (base) and FUN_RULE_OBJECTS_TL (translation), with attribute detail in FUN_RULE_OBJ_ATTRIBUTES. Criteria definitions are held in FUN_RULE_CRITERIA, with parameter metadata in FUN_RULE_CRIT_PARAMS_B and FUN_RULE_CRIT_PARAMS_TL, and assigned parameter values in FUN_RULE_PARAM_VALUES and FUN_RULE_DETAILS. Test and validation results are persisted across FUN_RULE_TESTS, FUN_RULE_TEST_MULTIRULE, FUN_RULE_TEST_MVAL_RES, FUN_RULE_TEST_PARAMS, and FUN_RULE_TEST_RESULTS. These tables provide the storage layer for the rule object model the API maintains.

Usage Notes

FUN_RULE_OBJECTS_PUB depends on the FND_API standard API framework, indicating that its routines follow the EBS API conventions of returning a standard return status, message count, and message data structure. It is referenced by four other packages — ARI_SELF_REG_CONFIG, ARI_UTILITIES, FUN_RULE_VALIDATE_PKG, and its own wrapper FUN_RULE_OBJECTS_PUB_W — demonstrating both inbound reuse and an outbound wrapper pattern. The presence of a _W (wrapper) package is characteristic of EBS APIs that expose a stable public interface while delegating implementation. Callers typically invoke this package from Oracle Receivables setup forms, rule validation routines, concurrent programs that build or migrate rule configurations, and custom integration code. Because it is a PUB API, direct DML against the underlying FUN_ tables should be avoided in favour of these documented entry points, ensuring that validation, translation handling, and audit behaviour remain consistent with Oracle's supported upgrade path across 12.1.1 and 12.2.2.