Results for “psb_ws_user_profiles”

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

Overview

The PSB_WS_USER_PROFILES table is a core configuration object within the PSB – Public Sector Budgeting module of Oracle E-Business Suite (documented in both 12.1.1 and 12.2.2). It stores user-specific worksheet profile settings that govern how budgeting worksheets are displayed, filtered, and ordered for each individual user. In the PSB budgeting workflow, a worksheet defines the data entry and review canvas; the user profile layered on top of that worksheet determines which dimensions, service packages, stages, and budget flags are visible or active for the signed-in user. This separation of worksheet definition from per-user presentation is what allows multiple budget analysts to work against the same worksheet structure while retaining personalized views.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as standalone under the Data Vault scheme. Because the table carries no downstream foreign-key dependents and only a single outbound reference, it is best modeled as a satellite keyed by the combination of worksheet and user, rather than a hub or link. In practice, the composite of WORKSHEET_ID and USER_ID behaves as the natural business key, with the remaining columns acting as descriptive profile attributes.

Key Information Stored

The table contains 33 documented columns. The most significant are:

• WORKSHEET_ID – identifies the budgeting worksheet to which the profile applies; part of the composite business key.
• USER_ID – the EBS application user whose personalization is stored; the second half of the composite business key.
• PROFILE_TYPE – classifies the profile (for example, a default or role-driven profile variant).
• SERVICE_PACKAGE_ID – the only documented foreign key, referencing PSB_SERVICE_PACKAGES, indicating the service package context inherited by the profile.
• STAGE_SET_ID and STAGE_SEQ – control which budgeting stage set and sequence position the user sees.
• TEMPLATE_ID – links the profile to the worksheet template controlling layout.
• BUDGET_PERIOD_ID – scopes the profile to a specific budget period.
• YEAR_FLAG, ACTUAL_FLAG, BUDGET_FLAG, ESTIMATE_FLAG, ENCUMBRANCE_FLAG, FTE_FLAG, START_YEAR_FLAG – boolean display/activation switches for each budget category dimension.
• SERVICE_PACKAGE_FLAG, ACCOUNT_FLAG, CURRENCY_FLAG – additional display toggles for core budgeting dimensions.
• ORDER_BY_COLUMN1..5 and ORDER_BY_COLUMN_NAME1..5 – define the user's preferred sort order, with the numeric columns identifying the column and the name columns storing the resolved label.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – standard EBS audit columns maintained by the concurrent manager and Forms runtime.

The surrogate primary key is not separately documented; the composite (WORKSHEET_ID, USER_ID) is the recommended business-key candidate, and no unique index is enumerated in the metadata beyond that implicit key.

Common Use Cases and Queries

Typical usage centers on determining what a given user will see when opening a worksheet, and on diagnosing why two users see divergent data in the same worksheet.

• Retrieve a user's profile: SELECT * FROM PSB.PSB_WS_USER_PROFILES WHERE WORKSHEET_ID = :ws AND USER_ID = :uid;
• List all profiles for a worksheet: join to FND_USER on USER_ID to produce an auditable roster of personalizations.
• Flag audit: filter on BUDGET_FLAG, ACTUAL_FLAG, ENCUMBRANCE_FLAG, and FTE_FLAG to report which dimensions are exposed for a given worksheet population.
• Sort configuration review: inspect ORDER_BY_COLUMN_NAME1..5 to confirm the ordering presented to users.
• Service package reconciliation: join SERVICE_PACKAGE_ID to PSB_SERVICE_PACKAGES to validate that the profile's package context is active.

Because the table is standalone, queries rarely require deep joins, making it efficient for reporting and data-extraction layers that feed budgeting dashboards.

Related Objects

The most significant associated objects include:

• PSB_SERVICE_PACKAGES – referenced via SERVICE_PACKAGE_ID; the only documented foreign key.
• PSB_WS_... worksheet definition tables keyed by WORKSHEET_ID – the parent worksheet objects the profile personalizes.
• PSB_WS_TEMPLATES – referenced by TEMPLATE_ID for layout delivery.
• PSB_STAGE_SETS – referenced by STAGE_SET_ID and STAGE_SEQ for budgeting stage progression.
• FND_USER – joined on USER_ID to resolve the profile owner.
• GL_BUDGET_PERIODS / BUDGET_PERIOD_ID – supplies period context for BUDGET_PERIOD_ID.

These relationships should be treated as the primary dependency set; the table is otherwise isolated within the PSB schema.