Search Results psb_ws_lines




Overview
Explore in AI Chat

Overview

PSB_WS_LINES is a Public Sector Budgeting (PSB) table documented in the Oracle E-Business Suite 12.1.1 and 12.2.2 Electronic Technical Reference Manual (ETRM). Its ETRM description defines it as the "Matrix between PSB_WORKSHEETS and PSB_WS_ACCOUNT_LINES," indicating that it functions as an intersection or association table linking worksheet header records to the account-level line records that belong to those worksheets. In the PSB budgeting model, worksheets represent a budgeting work unit assigned to an organization, position, or group of accounts, while account lines hold the individual budget amounts and account references. PSB_WS_LINES ties the two together, making it the structural backbone for arranging which account lines are visible within a given worksheet.

PSB is marked as Obsolete in the ETRM product list. The metadata further records "Not implemented in this database," which is consistent with the module being deprecated in current releases; the table persists primarily for upgrade, historical data retention, and documentation purposes. Its heuristic Data Vault classification is standalone, meaning the FK structure does not reveal a clear parent hub or dependent satellite role. As a modeling suggestion, the table is best treated as a link-style association between two business keys rather than as a descriptive satellite, since its two key columns are identifiers borrowed from the worksheet and account-line domains.

Key Information Stored

The documented physical schema owns nine columns under the PSB schema. The primary key is the composite PSB_WORKSHEET_LINES_PK, comprising WORKSHEET_ID and ACCOUNT_LINE_ID. This pair is also enforced by the unique index PSB_WS_LINES_U1, so the PK is simultaneously the business-key candidate: there is no separate surrogate key, and uniqueness is guaranteed at the intersection of one worksheet and one account line. Functionally, WORKSHEET_ID identifies the owning PSB_WORKSHEETS record, and ACCOUNT_LINE_ID identifies the related PSB_WS_ACCOUNT_LINES record.

Beyond the keys, the metadata documents two behavior flags. FREEZE_FLAG records whether the line is frozen for editing, a control commonly used to lock budget figures during review or approval cycles. VIEW_LINE_FLAG indicates whether the line is displayed in the worksheet view, supporting filtered presentation of large account sets. The remaining documented columns are standard EBS auditing attributes: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. These support row-level audit trails, concurrency handling, and EBS "Who" columns in forms and reports.

Common Use Cases and Queries

The primary use case is reconstructing the membership of a worksheet. A query joining PSB_WS_LINES to PSB_WS_ACCOUNT_LINES returns every account line associated with a worksheet, with visibility and freeze state applied.

  • Worksheet contents listing: SELECT l.worksheet_id, l.account_line_id, l.view_line_flag, l.freeze_flag FROM psb_ws_lines l WHERE l.worksheet_id = :worksheet_id ORDER BY l.account_line_id;
  • Reverse lookup — which worksheets contain an account line: SELECT worksheet_id FROM psb_ws_lines WHERE account_line_id = :account_line_id;
  • Frozen line reporting: filtering on FREEZE_FLAG to list lines locked for editing within a worksheet or across worksheets during an approval cycle.
  • Hidden-line auditing: filtering on VIEW_LINE_FLAG to identify account lines excluded from the worksheet view but still present in the association.
  • Orphan and integrity checks: detecting PSB_WS_LINES rows whose WORKSHEET_ID or ACCOUNT_LINE_ID no longer resolves to a parent record after data conversion or purging.
  • Audit extraction: selecting CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to trace when worksheet membership was established or changed.

Because PSB is obsolete, these queries are primarily relevant to historical reporting, upgrade validation, and EBS 12.1.1 to 12.2.2 data migration exercises rather than day-to-day budgeting.

Related Objects

  • PSB_WORKSHEETS — the worksheet header entity; joined on PSB_WS_LINES.WORKSHEET_ID = PSB_WORKSHEETS.WORKSHEET_ID.
  • PSB_WS_ACCOUNT_LINES — the account-level line entity; joined on PSB_WS_LINES.ACCOUNT_LINE_ID = PSB_WS_ACCOUNT_LINES.ACCOUNT_LINE_ID.
  • PSB_WS_ACCOUNT_LINES (via the same key) — the source of amounts, account combinations, and period detail displayed through the worksheet view.
  • PSB_WS_LINES_U1 / PSB_WORKSHEET_LINES_PK — the unique index and primary key constraint enforcing one row per worksheet/account-line pair.
  • PSB module upgrade and migration scripts — the consumers that reference this table during conversion between 12.1.1 and 12.2.2, given the "Not implemented" status of the obsolete module.

No FK relationship data was documented beyond the key pair; consequently, PSB_WS_LINES is treated as standalone in the Data Vault heuristic and should be joined explicitly to its two parent tables by the columns listed above.