Search Results cs_qm_user_folders




Overview
Explore in AI Chat

Overview

CS_QM_USER_FOLDERS is a Service (CS) module table in the Oracle E-Business Suite schema owned by CS. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, it stores folders that belong to individual users and maintains a foreign key to FND_USER. The object is registered in the EBS data dictionary with VALID status, and its physical schema is documented with twelve columns. In the Service application, the concept of a "folder" provides users with a personal organizational container for saved queries, filters, and result sets — most typically associated with the quality management (QM) workbench and similar service query tools. The table therefore acts as the per-user registry of these containers, tying each folder to the EBS application user who created and owns it.

From a heuristic Data Vault classification mined from its foreign key structure, this object is described as satellite-leaning. In practice this suggests modeling CS_QM_USER_FOLDERS as a satellite attached to a hub or link representing the owning user, since it carries descriptive attributes (folder name, description, flags) around a business relationship rather than serving as an independent hub or an intersection of multiple entities.

Key Information Stored

The table is defined with 12 documented columns. The most significant are:

  • USER_FOLDER_ID — Surrogate primary key, enforced by CS_QM_USER_FOLDERS_PK. This is the technical identifier referenced by dependent tables.
  • USER_ID — Foreign key to FND_USER identifying the owning application user. This is the principal business-key candidate; the unique index CS_QM_USER_FOLDERS_U1 is documented, consistent with a user-scoped uniqueness constraint such as folder name per user.
  • FOLDER_NAME — The display name of the folder as presented to the user.
  • DESCRIPTION — Free-text description of the folder's purpose or contents.
  • DEFAULT_FLAG — Indicates whether the folder is the user's default selection when the query tool opens.
  • ACTIVE_FLAG — Enables or disables the folder without deleting the underlying record.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns capturing audit and provenance information, including the login responsible for the last change.

Together these distinguish the surrogate key (USER_FOLDER_ID) from the business-key combination of USER_ID plus FOLDER_NAME, with the audit columns supporting standard EBS concurrency and traceability requirements.

Common Use Cases and Queries

Typical use cases include auditing which users have created personal folders, reporting on active versus inactive folders, and identifying default folders per user. A simple listing query follows:

  • SELECT f.user_name, uf.folder_name, uf.description, uf.default_flag, uf.active_flag FROM cs.cs_qm_user_folders uf JOIN applsys.fnd_user f ON f.user_id = uf.user_id WHERE uf.active_flag = 'Y';

Administrators commonly filter by user to review personalization, for example WHERE uf.user_id = :user_id, or count folders per user to detect excessive personalization. Data-load and cleanup scripts should always join through USER_ID rather than assuming a folder belongs to the session user.

Related Objects

  • FND_USER — Referenced by CS_QM_USER_FOLDERS.USER_ID; the parent of every folder record.
  • CS_QM_FOLDER_FILTERS — Child table referencing CS_QM_USER_FOLDERS.USER_FOLDER_ID; stores the filter criteria contained within each folder and is the primary dependent object.
  • CS_QM_USER_FOLDERS_PK / CS_QM_USER_FOLDERS_U1 — Primary and unique indexes underpinning access and integrity.
  • FND_USER related views — Used in conjunction with this table for user-centric reporting.

Any purge, migration, or personalization-copy routine must process CS_QM_FOLDER_FILTERS before removing or re-keying parent folders.