Search Results fnd_form_custom_rules_pkg




Overview
Explore in AI Chat

Overview

The APPS.FND_FORM_CUSTOM_RULES_PKG package body is a core Oracle E-Business Suite repository object that supports the Oracle Forms-based personalization and customization framework. In both Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the server-side logic used to manage the metadata definitions that drive runtime form customizations — the rules, actions, parameters, and scopes that administrators and personalization authors define to alter the behavior of Oracle Forms without changing the underlying compiled forms.

Within the Oracle Application Object Library (FND) schema, custom form rules allow declarative customization such as hiding fields, setting defaults, validating entries, or triggering actions when a form is rendered. The FND_FORM_CUSTOM_RULES_PKG body operates on the underlying FND tables that store these definitions, providing the programmatic layer through which customization records are created, maintained, and removed. Its classification is listed as OTHER, indicating it is a supporting infrastructure package rather than a public end-user API, and ETRM documents it as VALID in the APPS schema.

Key Procedures and Functions

The documented API surface of this package is limited. ETRM records a single procedural entry:

  • DELETE_SET — The documented procedure responsible for removing a defined set of custom rule records. Its purpose is to delete the customization definitions associated with a given set, ensuring that the related rule, action, parameter, and scope records are removed in a controlled manner. As a set-level deletion routine, it supports cleanup of obsolete or superseded form customizations without leaving orphaned or inconsistent metadata. Consistent with ETRM guidance, the precise parameter list is not enumerated here.

The package body also references itself, which is typical of internal, shared helper logic within the same package. No additional callable procedures or functions are documented in the metadata excerpt.

Tables Accessed

The package interacts with several FND customization tables through APPS synonyms. ETRM documents the following referenced objects:

  • FND_FORM_CUSTOM_RULES and FND_FORM_CUSTOM_RULES_S — the primary and translated stores for custom rule definitions; these hold the rules that the package manages and deletes.
  • FND_FORM_CUSTOM_ACTIONS — contains the actions executed when a matching rule is triggered; accessed during set deletion and maintenance.
  • FND_FORM_CUSTOM_PARAMS — stores parameters that qualify rules and actions; referenced to maintain referential consistency.
  • FND_FORM_CUSTOM_SCOPES — defines the scope (such as responsibility or user) over which a rule applies, accessed to resolve or remove scoped customizations.
  • DUAL — the standard SYS-provided single-row table, used for trivial selection or validation logic.

Because the package reads and writes these interrelated tables, it functions as a coordinated maintenance layer that preserves integrity across the customization metadata model.

Usage Notes

FND_FORM_CUSTOM_RULES_PKG is an infrastructure package, not a documented public API, and ETRM notes that it is not referenced by any database object. It is therefore invoked internally — typically through Oracle Forms runtime processing or administrative maintenance of form personalizations rather than directly by concurrent programs or customer code. In practice, administrators manage custom rules through the Forms-based personalization UI, which ultimately operates on the same FND tables this package governs. Direct invocation should be treated as unsupported, and custom code should avoid depending on this package because its procedures are not part of the published interface. When cleaning up customization definitions, DELETE_SET provides the intended mechanism for removing a logically grouped set of rules and their dependent records.