Results for “worksheet_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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_FLAGto list lines locked for editing within a worksheet or across worksheets during an approval cycle. - Hidden-line auditing: filtering on
VIEW_LINE_FLAGto 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.
-
Matrix between PSB_WORKSHEETS and PSB_WS_ACCOUNT_LINES
-
Matrix between PSB_WORKSHEETS and PSB_WS_POSITION_LINES
-
Stores comments for review groups sent during Submit Worksheet process
-
APPS.PSBBV_WS_POSITION_LINES·↳ PSB_WORKSHEETS·↳ PSB_WS_LINES_POSITIONS·↳ PSB_WS_POSITION_LINES·Explore PSB module →
-
Service packages submitted for a worksheet
-
APPS.PSB_POSITION_PAY_DISTR_DATE_V·↳ PSB_POSITIONS_PVT·↳ PSB_POSITION_PAY_DISTRS_V·Explore PSB module →
-
Workflow item key information for a worksheet
-
APPS.PSB_POSITION_ASSIGN_EMP_V·↳ PSB_EMPLOYEES·↳ PSB_POSITION_ASSIGNMENTS·Explore PSB module →
-
APPS.PSB_POSITION_PAY_DISTRS_V·↳ PSB_POSITIONS·↳ PSB_POSITIONS_PVT·↳ PSB_POSITION_PAY_DISTRIBUTIONS·Explore PSB module →
-
APPS.PSBFV_PAY_ELEMENT_RATES·↳ PSB_PAY_ELEMENTS·↳ PSB_PAY_ELEMENT_OPTIONS·↳ PSB_PAY_ELEMENT_RATES·Explore PSB module →
-
APPS.PSB_WS_POSITION_ACCOUNTS_V·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES_POSITIONS·↳ PSB_WS_MATRIX·Explore PSB module →
-
APPS.PSB_WS_SERVICE_PKG_PROFILES_V·↳ PSB_SERVICE_PACKAGES·↳ PSB_WS_USER_PROFILES·Explore PSB module →
-
APPS.PSB_WS_SELECT_POSITIONS_V·↳ PSB_POSITIONS·↳ PSB_POSITIONS_PVT·↳ PSB_WORKSHEETS·Explore PSB module →
-
Information on each instance of worksheet distribution
-
Transaction data for working on budget version
-
APPS.PSB_POSITION_ASSIGN_SALARY_V·↳ PSB_PAY_ELEMENTS·↳ PSB_PAY_ELEMENT_OPTIONS·↳ PSB_POSITIONS_PVT·Explore PSB module →
-
View: PSB_WS_BUDGET_YEARS_V 12.1.1
APPS.PSB_WS_BUDGET_YEARS_V·↳ PSB_BUDGET_CALENDARS·↳ PSB_BUDGET_PERIODS·↳ PSB_BUDGET_YEAR_TYPES·Explore PSB module →
-
APPS.PSBFV_WS_POSITION_LINES·↳ PSB_POSITIONS·↳ PSB_POSITION_DEFINITIONS_KFV·↳ PSB_WORKSHEETS·Explore PSB module →
-
View: PSBFV_WS_ACCOUNT_LINES 12.1.1
APPS.PSBFV_WS_ACCOUNT_LINES·↳ GL_CODE_COMBINATIONS_KFV·↳ GL_SETS_OF_BOOKS·↳ PSB_BUDGET_GROUPS·Explore PSB module →
-
Details for each instance of worksheet distribution
-
View: PSB_WORKSHEETS_RESP_V 12.1.1
APPS.PSB_WORKSHEETS_RESP_V·↳ FND_DATE·↳ FND_USER_RESP_GROUPS·↳ PSB_BUDGET_GROUPS·Explore PSB module →
-
APPS.PSB_WS_QUERY_PROFILES_V·↳ PSB_SUMMARY_TEMPLATES·↳ PSB_WS_USER_PROFILES·Explore PSB module →
-
Attribute, element, employee assignments to positions
-
View: PSB_WS_ACCOUNTS_V 12.1.1
APPS.PSB_WS_ACCOUNTS_V·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES·↳ PSB_WS_MATRIX·Explore PSB module →
-
APPS.PSB_WS_SERVICE_PACKAGES_V·↳ PSB_BUDGET_PERIODS·↳ PSB_BUDGET_YEAR_TYPES·↳ PSB_SERVICE_PACKAGES·Explore PSB module →
-
View: PSBBV_WS_ACCOUNT_LINES 12.1.1
APPS.PSBBV_WS_ACCOUNT_LINES·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES·Explore PSB module →
-
Work table of Hr entities for Budget information
-
APPS.PSBBV_POSITION_ASSIGNMENTS·↳ PSB_POSITION_ASSIGNMENTS·Explore PSB module →
-
APPS.PSBBV_PAY_ELEMENT_RATES·↳ PSB_PAY_ELEMENT_RATES·Explore PSB module →
-
APPS.PSBFV_BUDGET_WORKSHEETS·↳ FND_GLOBAL·↳ GL_BUDGET_VERSIONS·↳ PSB_BUDGET_CALENDARS·Explore PSB module →
-
Transaction data for working on budget version
-
APPS.PSBFV_POSITION_ASSIGNMENTS·↳ PSB_PAY_ELEMENTS·↳ PSB_PAY_ELEMENT_OPTIONS·↳ PSB_POSITIONS·Explore PSB module →
-
View: PSB_WS_DISTRIBUTIONS_V 12.1.1
APPS.PSB_WS_DISTRIBUTIONS_V·↳ PSB_BUDGET_GROUPS·↳ PSB_WORKSHEETS·↳ PSB_WS_DISTRIBUTIONS·Explore PSB module →
-
Rates for a pay element or pay element option
-
View: PSB_WS_LINE_YEAR_XL_V 12.1.1
APPS.PSB_WS_LINE_YEAR_XL_V·↳ PSB_SERVICE_PACKAGES·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES·Explore PSB module →
-
View: PSB_WS_YEAR_PROFILES_V 12.1.1
APPS.PSB_WS_YEAR_PROFILES_V·↳ PSB_BUDGET_PERIODS·↳ PSB_BUDGET_YEAR_TYPES·↳ PSB_WS_USER_PROFILES·Explore PSB module →
-
APPS.PSB_POSITION_ASSIGN_ATTR_V·↳ PSB_ATTRIBUTES·↳ PSB_ATTRIBUTE_VALUES·↳ PSB_POSITIONS_PVT·Explore PSB module →
-
View: PSB_WS_SUMMARY_V 12.1.1
APPS.PSB_WS_SUMMARY_V·↳ FND_USER·↳ PSB_BUDGET_GROUPS_V·↳ PSB_BUDGET_STAGES·Explore PSB module →
-
Worksheet interface table for spreadsheet import and export
-
View: ASF_FRCST_SUM_REPRT_V 12.2.2
APPS.ASF_FRCST_SUM_REPRT_V·↳ AS_MC_SALES_CREDITS_DEN·↳ AS_OPP_WORKSHEET_LINES·↳ AS_SALES_CREDITS_DENORM·Explore ASF module →
-
View: ASF_FRCST_SUM_REPRT_V 12.1.1
APPS.ASF_FRCST_SUM_REPRT_V·↳ AS_MC_SALES_CREDITS_DEN·↳ AS_OPP_WORKSHEET_LINES·↳ AS_SALES_CREDITS_DENORM·Explore ASF module →
-
View: PSB_WS_LINE_PERIOD_V 12.1.1
APPS.PSB_WS_LINE_PERIOD_V·↳ GL_CODE_COMBINATIONS·↳ PSB_SERVICE_PACKAGES·↳ PSB_WS_ACCOUNT_LINES·Explore PSB module →
-
APPS.PSB_POSITION_ASSIGNMENTS_V·↳ PSB_POSITIONS_PVT·↳ PSB_POSITION_ASSIGNMENTS·Explore PSB module →
-
APPS.PSB_WS_POSITION_PERIODS_V·↳ GL_CODE_COMBINATIONS·↳ PSB_SERVICE_PACKAGES·↳ PSB_SUMMARY_TEMPLATES·Explore PSB module →
-
Table: PSB_WORKSHEET_CONTEXT 12.1.1
Worksheet Context inofrmation
-
Position cost distribution rules
-
Work table of Hr entities for Budget information
-
View: PSB_WS_FOLDER_V 12.1.1
APPS.PSB_WS_FOLDER_V·↳ FND_USER·↳ PSB_BUDGET_GROUPS·↳ PSB_BUDGET_STAGES·Explore PSB module →
-
APPS.PSB_POSITION_ASSIGN_ELEMENT_V·↳ PSB_PAY_ELEMENTS·↳ PSB_PAY_ELEMENT_OPTIONS·↳ PSB_POSITIONS_PVT·Explore PSB module →
-
User profiles for a worksheet