Search Results cs_qm_folder_filters_pk

Overview

CS_QM_FOLDER_FILTERS is a Service (CS) module table in the Oracle E-Business Suite CS schema. It stores the individual filter instances associated with saved user folders in the Quality Management (QM) folder framework, allowing end users to persist reusable result-set criteria against the folders they create. Each row represents one filter assignment: a specific function filter applied inside a particular user folder. The table is documented as VALID in both EBS 12.1.1 and 12.2.2, with an identical twelve-column physical schema in the 12.2.2 ETRM listing.

The documented uniqueness rule states that the combination of USER_FOLDER_ID and FUNCTION_FILER_ID is unique (the ETRM spelling; the physical column is FUNCTION_FILTER_ID). This confirms the table's role as an intersection or association entity between user-defined folders and the catalog of function filters, rather than a standalone transactional entity. Under the heuristic Data Vault classification mined from its foreign-key structure, the table is best modeled as a link: it resolves many-to-many associations between CS_QM_USER_FOLDERS and CS_QM_FUNCTION_FILTERS. Treat this as a modeling suggestion, not a documented architectural statement.

Key Information Stored

• FOLDER_FILTER_ID — the surrogate primary key, enforced by CS_QM_FOLDER_FILTERS_PK. It uniquely identifies each folder-filter assignment row.
• USER_FOLDER_ID — foreign key to CS_QM_USER_FOLDERS, identifying the owning folder. This is the business-key component that ties a filter instance to a specific user's saved folder.
• FUNCTION_FILTER_ID — foreign key to CS_QM_FUNCTION_FILTERS, identifying the filter definition being applied. Together with USER_FOLDER_ID it forms the documented unique business key, enforced by the CS_QM_FOLDER_FILTERS_U2 unique index.
• FILTER_VALUE_ID — the identifier of the selected filter value; a second unique index, CS_QM_FOLDER_FILTERS_U1, is defined on this column.
• FILTER_OPERATOR — the comparison operator applied to the filter, governing how the filter value is evaluated against the result set.
• FILTER_VALUE — the actual value or literal the filter matches on, complementing FILTER_VALUE_ID for lookup-derived or free-form criteria.
• OBJECT_VERSION_NUMBER — the optimistic-locking column used by the OAF/BC4J framework to detect concurrent updates.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN record who created and last modified each filter assignment and when, consistent with standard EBS WHO column conventions.

Common Use Cases and Queries

The primary operational use case is folder personalization: when a user saves a QM search or results folder, the application writes one row per filter into this table so the folder reopens with the same criteria. Reporting queries typically reconstruct a folder's filter set by joining to both parent tables.

SELECT ff.folder_filter_id,
       ff.function_filter_id,
       ff.filter_operator,
       ff.filter_value,
       fn.filter_name
FROM   cs.cs_qm_folder_filters ff,
       cs.cs_qm_function_filters fn,
       cs.cs_qm_user_folders uf
WHERE  ff.function_filter_id = fn.function_filter_id
AND    ff.user_folder_id     = uf.user_folder_id
AND    uf.user_folder_id     = :p_folder_id;

Additional scenarios include diagnosing duplicate or orphaned folder filters, auditing which filters are most widely used across user folders for tuning or cleanup, and data-migration or cloning validation where folder personalization must be preserved. Because the table is narrow and association-oriented, queries are inexpensive and are usually driven from the folder side.

Related Objects

• CS_QM_USER_FOLDERS — parent of CS_QM_FOLDER_FILTERS.USER_FOLDER_ID; defines the folder that owns each filter instance.
• CS_QM_FUNCTION_FILTERS — parent of CS_QM_FOLDER_FILTERS.FUNCTION_FILTER_ID; supplies the filter definition, operator metadata, and display name.
• CS_QM_FOLDER_FILTERS_PK — primary-key constraint on FOLDER_FILTER_ID.
• CS_QM_FOLDER_FILTERS_U1 — unique index on FILTER_VALUE_ID.
• CS_QM_FOLDER_FILTERS_U2 — unique index enforcing the USER_FOLDER_ID / FUNCTION_FILTER_ID business key.
• The CS QM folder framework views and OAF pages that read folder definitions and render saved search criteria, which consume this table indirectly through the two parent tables.