Search Results fnd_apptree




Overview
Explore in AI Chat

Overview

FND_APPTREE is a PL/SQL package body owned by the APPS schema that provides the programmatic foundation for managing the folder hierarchy maintained within the Oracle E-Business Suite Applications menu and function security framework. Its name reflects the "application tree" concept, and its role is to expose a controlled, reusable set of operations for creating, maintaining, relocating, and removing folders that organize Functions within the hierarchical navigator. Rather than allowing forms or concurrent programs to manipulate folder records directly against the underlying tables, FND_APPTREE centralizes that logic, ensuring that naming rules, sequence-generated identifiers, and uniformity constraints are applied consistently.

The package is classified in the ETRM repository as an OTHER API, indicating that it is a supporting internal package rather than a formally published public API. It is documented as VALID in the APPS schema across both 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

Six procedures and functions are documented for this package:

  • GET_FOLDER_PROPERTIES — Retrieves the descriptive attributes of a given folder, such as its name and related metadata, so that callers can inspect folder configuration before performing maintenance or display operations.
  • INSERT_FOLDER — Creates a new folder record within the tree, establishing its position in the hierarchy.
  • UPDATE_FOLDER — Modifies the attributes of an existing folder, allowing renames and other property changes without disturbing unrelated nodes.
  • DELETE_FOLDER — Removes a folder from the hierarchy, handling the associated bookkeeping required by the underlying tables.
  • MOVE_FOLDER — Repositions a folder (and implicitly its subtree) from one parent location to another, restructuring the tree without recreating nodes.
  • UNIQUE_NAME — Enforces or generates a folder name that does not collide with existing siblings, preserving the integrity of folder naming within the tree.

These routines operate as an integrated set: identification and validation (GET_FOLDER_PROPERTIES, UNIQUE_NAME) support the mutating operations (INSERT, UPDATE, MOVE, DELETE). No parameter lists are documented in the source metadata and none are asserted here.

Tables Accessed

FND_APPTREE references two base tables via APPS synonyms, plus the standard DUAL table:

  • FND_TREE_FOLDERS — The primary table holding folder definitions and their placement within the tree. The insert, update, move, and delete operations all act against this table.
  • FND_TREE_FOLDERS_S — The corresponding sequence table, used to obtain unique folder identifiers when new folders are created.
  • DUAL — The standard SYS table, consulted for trivial single-row evaluation and sequence or expression retrieval.

The dependency documentation confirms that FND_APPTREE is a consumer of these tables and is not referenced by any database object, meaning it is not exposed through views, triggers, or other stored PL/SQL units.

Usage Notes

FND_APPTREE is an internal maintenance package. It is typically invoked by Oracle Forms-based administrative screens (such as those used to define and organize menu functions) and by standard or custom concurrent programs that need to synchronize or migrate folder structures between environments. Because it is referenced by twelve other packages, it also functions as a shared library consumed by higher-level application modules that perform tree maintenance on the caller's behalf.

Custom code should treat FND_APPTREE as a non-public helper API. Direct invocation is appropriate only when performing controlled folder maintenance within the Applications framework, and developers should rely on the procedures above rather than issuing DML against FND_TREE_FOLDERS directly, so that uniqueness and sequencing behavior remain intact.