Results for “psb_ws_query_profiles_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB_WS_QUERY_PROFILES_V is a database view defined within the Public Sector Budgeting (PSB) product family of Oracle E-Business Suite. The PSB module is documented as obsolete in the ETRM metadata supplied for this object, and the view itself is annotated as "Not implemented in this database" in the current environment. Despite its obsolete status, the view definition remains relevant as a reference artifact for historical implementations of PSB, particularly for installations that performed budgeting worksheet operations prior to the module's retirement.

The view presents worksheet query profile configurations. Each row represents a saved query profile that governs how a budgeting worksheet is filtered, staged, and ordered for a specific user. The presence of user identifier, worksheet identifier, and profile type columns indicates that the view is user-centric and worksheet-scoped, making it a natural source for reporting on saved worksheet personalization settings.

In reporting and integration contexts, views of this class were typically consumed by PSB worksheet UI layers or by custom extracts that needed to enumerate a user's saved query preferences. The view is described in the documentation as read-only and derived, exposing no new persistent data of its own.

Underlying Base Objects

The documented base objects underpinning PSB_WS_QUERY_PROFILES_V are two PSB tables:

• PSB_WS_USER_PROFILES (WUP) — the driving table containing worksheet user profile records.
• PSB_SUMMARY_TEMPLATES (ST) — the lookup source for template names.

The join is defined as WUP.TEMPLATE_ID = ST.TEMPLATE_ID(+), an outer join from the profiles table to the templates table. This ensures that profile rows with no matching template remain visible in the result set, with the template name column returning NULL. The view also filters on WUP.PROFILE_TYPE = 'Q', restricting output strictly to query-type profiles. The ETRM metadata notes that no referenced base objects are separately documented, so the relationship is inferred entirely from the view text.

Key Columns

• ROW_ID — the ROWID of the underlying PSB_WS_USER_PROFILES row; useful for direct row identification.
• WORKSHEET_ID / USER_ID — identify the worksheet and the user to whom the profile applies.
• PROFILE_TYPE — always 'Q' in this view, denoting a query profile.
• TEMPLATE_ID / TEMPLATE_NAME — template reference and its truncated (first 30 characters) name from PSB_SUMMARY_TEMPLATES.
• CURRENCY_FLAG — the column of interest in the originating search; indicates whether currency is included as a selection dimension in the saved query profile.
• YEAR_FLAG, SERVICE_PACKAGE_FLAG, ACCOUNT_FLAG — parallel flags controlling whether year, service package, and account are part of the query criteria.
• ORDER_BY_COLUMN1..5 and ORDER_BY_COLUMN_NAME1..5 — define up to five ordering columns and their display names for the worksheet query.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical uses centered on auditing which selection dimensions (including currency) were enabled for each user's saved worksheet query, and reconciling profile configurations across users. A representative query retrieving currency-flagged profiles is:

SELECT USER_ID, WORKSHEET_ID, TEMPLATE_NAME, CURRENCY_FLAG, YEAR_FLAG, ACCOUNT_FLAG
FROM PSB_WS_QUERY_PROFILES_V
WHERE CURRENCY_FLAG = 'Y';

Given the module's obsolete status and the "not implemented" note, these queries are primarily of historical or migration interest rather than active operational value.