Search Results fnd_folders




Overview
Explore in AI Chat

Overview

FND_FOLDERS is a table in the APPLSYS schema that stores customized folder definitions within Oracle E-Business Suite, owned by the FND – Application Object Library product. Folders in EBS provide an end-user personalization mechanism: they allow users to save a specific arrangement, filter, and ordering of rows and columns on a given form or region, distinct from the underlying form definition. FND_FOLDERS holds the header-level definition of each such folder, including the object it applies to, ownership, visibility, and default query and sort behavior. In EBS 12.1.1 and 12.2.2 the table remains valid and centrally managed by the FND framework, serving as the parent record for the folder's saved columns and its default-folder assignment.

From a dimensional modeling perspective, the mined foreign-key structure suggests a hub-leaning classification. The table is referenced by two dependent tables (FND_DEFAULT_FOLDERS and FND_FOLDER_COLUMNS) through the FOLDER_ID column, indicating it behaves as a hub whose business identity and descriptive attributes are carried locally rather than depending on another parent entity.

Key Information Stored

The table contains 14 documented columns. The most significant are summarized below.

  • FOLDER_ID — The surrogate primary key, enforced by the FND_FOLDERS_PK constraint and backed by unique index FND_FOLDERS_U1. It uniquely identifies each folder definition and is the column through which dependent tables join.
  • OBJECT — Identifies the application object (form or region) to which the folder definition applies.
  • NAME — The user-assigned name of the folder definition.
  • LANGUAGE — The language context of the folder definition, allowing language-specific folder records.
  • PUBLIC_FLAG — Indicates whether the folder is public (shared across users) or private to its creator.
  • AUTOQUERY_FLAG — Controls whether the folder automatically executes its saved query when opened.
  • WINDOW_WIDTH — Stores the saved display width associated with the folder layout.
  • WHERE_CLAUSE — The saved filter condition applied when the folder is invoked.
  • ORDER_BY — The saved sort specification for the folder's rows.
  • CREATED_BY and CREATION_DATE — Standard audit columns recording folder creation; CREATED_BY also participates in the business-key candidate.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification context.

The surrogate key FOLDER_ID is distinct from the documented business-key candidates: unique index FND_FOLDERS_U2 covering OBJECT, LANGUAGE, CREATED_BY, and NAME enforces that a given user cannot hold two folders with the same name for the same object and language, while FND_FOLDERS_U1 mirrors the primary key.

Common Use Cases and Queries

Administrators and technical consultants query FND_FOLDERS to audit folder ownership, diagnose missing or duplicated folders, and migrate folder definitions between environments. Typical scenarios include identifying all public folders for a form and enumerating a user's private folders.

  • List folders for a specific object: SELECT folder_id, name, public_flag, autoquery_flag FROM fnd_folders WHERE object = :object_name;
  • Find a user's private folders: SELECT folder_id, object, name FROM fnd_folders WHERE created_by = :user_id AND public_flag = 'N';
  • Review saved query and sort behavior: SELECT folder_id, where_clause, order_by FROM fnd_folders WHERE folder_id = :folder_id;

Reporting commonly joins FND_FOLDERS to FND_FOLDER_COLUMNS to reconstruct the saved column layout, and to FND_DEFAULT_FOLDERS to determine which folder is set as the default for a user and object.

Related Objects

  • FND_FOLDER_COLUMNS — Child table linked via FND_FOLDER_COLUMNS.FOLDER_ID → FND_FOLDERS.FOLDER_ID; stores the saved column-level details for each folder.
  • FND_DEFAULT_FOLDERS — Child table linked via FND_DEFAULT_FOLDERS.FOLDER_ID → FND_FOLDERS.FOLDER_ID; records which folder is assigned as the default for a user and object.
  • FND_FOLDERS_PK — The primary key constraint on FOLDER_ID.
  • FND_FOLDERS_U1 / FND_FOLDERS_U2 — Unique indexes enforcing the surrogate key and the OBJECT, LANGUAGE, CREATED_BY, NAME business key.

Together these objects form the folder personalization subsystem within the FND Application Object Library, with FND_FOLDERS acting as the hub that anchors folder headers, their column definitions, and their default assignments.