Search Results fnd_tree_folders




Overview
Explore in AI Chat

Overview

FND_TREE_FOLDERS is a Foundation (Application Object Library) table owned by the APPLSYS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Application Tree (APPTREE) personal and public nodes — the user-defined and shared folder hierarchy used by the Oracle Forms tree navigation component (the "Folder" / Navigator tree) that appears in many EBS forms and self-service pages. Each row represents a single tree node, holding its label, its position in the hierarchy, and its ownership scope (personal versus public).

From a Data Vault modeling perspective, the mined relationship classification for FND_TREE_FOLDERS is standalone. Heuristically this suggests the table behaves as a self-contained reference/satellite-like structure with no documented foreign keys to external hubs; the parent-child linkage is expressed internally through the PARENT_FOLDER_ID column rather than through a declarative FK to another table.

Key Information Stored

  • FOLDER_ID — surrogate primary key, enforced by index FND_TREE_FOLDERS_PK and additionally by the unique index FND_TREE_FOLDERS_U1. This is the stable identifier for the tree node.
  • PARENT_FOLDER_ID — self-referencing pointer to the parent node, defining the recursive hierarchy of the tree. Top-level nodes generally carry a null or root value.
  • NODE_LABEL — the display text rendered for the node in the tree UI.
  • OBJ_NAME — identifies the object (form, function, or target) associated with the node.
  • FOLDER_TYPE — classifies the node (for example, folder versus leaf/object), controlling how the entry is treated by the tree.
  • VALUE — the associated value or target passed when the node is selected.
  • SEQUENCE — ordering of the node among its siblings under the same parent.
  • PUBLIC_FLAG — distinguishes public (shared) nodes from personal nodes, which is the central personal/public distinction described in the object's ETRM description.
  • LANGUAGE — the language context for the label, supporting multilingual display of node text.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS who-column audit set that records row creation and the most recent modification, including the responsible application user and login session.

The documented schema contains 14 columns in total; FOLDER_ID is the sole surrogate key, and no separate business-key column set beyond FOLDER_ID is documented.

Common Use Cases and Queries

Typical scenarios include troubleshooting why a user's navigation tree is missing nodes, auditing which personal or public folders have been created, and reporting on the tree hierarchy for a given object or language.

  • List nodes for a specific object: SELECT folder_id, node_label, parent_folder_id, folder_type, public_flag FROM applsys.fnd_tree_folders WHERE obj_name = :obj_name ORDER BY parent_folder_id, sequence;
  • Separate personal from public entries: SELECT public_flag, COUNT(*) FROM applsys.fnd_tree_folders GROUP BY public_flag;
  • Identify recently changed nodes for audit: SELECT folder_id, node_label, last_updated_by, last_update_date FROM applsys.fnd_tree_folders WHERE last_update_date > SYSDATE - 30;
  • Reconstruct a branch of the hierarchy by walking PARENT_FOLDER_ID through a CONNECT BY query.

Related Objects

Because the table is classified as standalone, it carries no documented outward foreign keys. Relationships are primarily logical and self-referential:

  • FND_TREE_FOLDERS (self-join) — PARENT_FOLDER_ID to FOLDER_ID defines the parent-child hierarchy.
  • FND_TREE_FOLDERS_PK / FND_TREE_FOLDERS_U1 — the primary and unique indexes on FOLDER_ID.
  • FND_APPLICATION_TL / FND_APPLICATION — application context that scopes which products expose an APPTREE.
  • FND_FORM / FND_FORM_FUNCTIONS — the forms and functions referenced through OBJ_NAME for navigation targets.
  • FND_LANGUAGES — validates the LANGUAGE column values.
  • FND_USER — the identity referenced by CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for personal folder ownership.