Search Results psb_error_message_source

Overview

APPS.PSB_ERROR_REQUESTS_V is a reporting view in the Oracle E-Business Suite Enterprise Resource Planning (EBS ERP) Grants and Budgeting modules—specifically within the Public Sector Budgeting (PSB) schema. The view consolidates error records generated during the budget worksheet processing lifecycle and presents them in a human-readable form alongside descriptive process names and lookup meanings.

Its primary role is to surface the concurrent request ID, the internal process ID, and the originating source process for each recorded error, while resolving coded process identifiers into meaningful text via joins to budget worksheets, data extracts, budget groups, and worksheet interface staging data. The view supports troubleshooting and monitoring of PSB batch processes such as worksheet creation, budget hierarchy validation, budget journal creation, and movement of worksheets to the interface or to the PSB repository.

The search term ws_creation_complete is relevant because the underlying view text references the WS_CREATION_COMPLETE column from PSB_WORKSHEETS to disambiguate worksheet creation errors. This flag tells the view whether worksheet creation has finished for a given worksheet ID, so that only completed worksheet processes are matched to their error messages.

Underlying Base Objects

The view is defined over the following objects, as documented in the view text:

• PSB_ERROR_MESSAGES – the driving table, from which distinct CONCURRENT_REQUEST_ID, PROCESS_ID, and SOURCE_PROCESS combinations are selected. This provides the core error records.
• FND_LOOKUPS – joined on LOOKUP_TYPE='PSB_ERROR_MESSAGE_SOURCE' to translate SOURCE_PROCESS codes into the SOURCE_PROCESS_MEANING.
• PSB_BUDGET_GROUPS – union branch supplying process names where the source process is VALIDATE_BUDGET_HIERARCHY (BUDGET_GROUP_TYPE='R').
• PSB_DATA_EXTRACTS – union branch supplying process names for DATA_EXTRACT_VALIDATION.
• PSB_WORKSHEETS – union branch supplying worksheet NAME and WS_CREATION_COMPLETE for worksheet-related processes (WORKSHEET_CREATION, CREATE_BUDGET_JOURNAL, POSITION_WORKSHEET_EXCEPTION).
• PSB_WORKSHEETS_I – union branch supplying EXPORT_ID/EXPORT_NAME for MOVE_TO_INTERFACE and MOVE_TO_PSB.

Within the view’s inline COMBO_T subquery, each union member carries a discriminator (TNAME: 'BG', 'DE', 'WS', 'WSI') so the outer WHERE clause can conditionally match the correct process source. The seven OR branches correspond one-to-one to the seven supported source processes.

Key Columns

• CONCURRENT_REQUEST_ID – the concurrent program request that produced the error; the primary correlation key for concurrent manager diagnostics.
• PROCESS_ID – internal identifier of the affected budget group, data extract, worksheet, or worksheet interface record.
• SOURCE_PROCESS – the coded source process name (e.g., WORKSHEET_CREATION, MOVE_TO_PSB).
• SOURCE_PROCESS_MEANING – the descriptive text resolved via FND_LOOKUPS for SOURCE_PROCESS.
• PROCESS_NAME – the resolved human-readable name of the process instance, obtained by DECODE over SOURCE_PROCESS against COMBO_T.NAME.

Common Use Cases and Queries

Typical usage includes diagnosing why a concurrent budget request failed, identifying which worksheets or extracts validate incompletely, and exporting error lists for support.

To list all errors for a specific concurrent request:

SELECT concurrent_request_id, process_id, source_process, source_process_meaning, process_name
FROM   apps.psb_error_requests_v
WHERE  concurrent_request_id = :request_id;

To isolate worksheet creation issues (where the ws_creation_complete logic is applied):

SELECT concurrent_request_id, process_id, process_name
FROM   apps.psb_error_requests_v
WHERE  source_process = 'WORKSHEET_CREATION';

To report errors grouped by process type:

SELECT source_process_meaning, COUNT(*)
FROM   apps.psb_error_requests_v
GROUP  BY source_process_meaning;

Because the view exposes only processed, request-scoped error combinations, it is well suited as a component in PSB error-reporting concurrent programs and in operational dashboards for budgeting administrators on EBS 12.1.1 and 12.2.2.