Search Results psb_error_message_source

Overview

PSB_ERROR_REQUESTS_V is an APPS-owned, VALID database view in Oracle E-Business Suite (12.1.1 and 12.2.2) belonging to the PSB – Public Sector Budgeting product. Its purpose is to present a consolidated, human-readable list of concurrent requests and processing activities that have generated errors during budget preparation. Public Sector Budgeting depends on multiple concurrent processes — data extraction, budget hierarchy validation, worksheet creation, budget journal creation, and interface/transfer jobs — and when any of these fail or raise exceptions, error rows are written into the underlying error message table. The view enriches those raw error rows by joining them to lookup meanings, resolving the source process into a descriptive label, and substituting the actual process name (for example the budget group name, data extract name, or worksheet name) depending on the originating process. The result is a reporting-friendly record keyed by concurrent request that administrators and budget analysts can query to identify what failed, in which process, and against which named budget object.

The object is classified as a view rather than a table because it holds no persistent data; it is a query layer over error and definition tables owned by the PSB schema, exposed under APPS for consistent access and security. It typically appears in diagnostics, error-tracking reports, and troubleshooting queries rather than in transactional application logic.

Underlying Base Objects

The view text references the following base objects:

• PSB_ERROR_MESSAGES — the driving table, aliased PEM. Only DISTINCT combinations of CONCURRENT_REQUEST_ID, PROCESS_ID, and SOURCE_PROCESS are selected, forming the error set.
• FND_LOOKUPS — aliased FL, restricted to LOOKUP_TYPE = 'PSB_ERROR_MESSAGE_SOURCE', supplying MEANING as SOURCE_PROCESS_MEANING.
• PSB_BUDGET_GROUPS — supplies budget-group names (TNAME = 'BG') for hierarchy validation.
• PSB_DATA_EXTRACTS — supplies data-extract names (TNAME = 'DE') for data-extract validation.
• PSB_WORKSHEETS — supplies worksheet names and WS_CREATION_COMPLETE (TNAME = 'WS') for worksheet creation, position worksheet exceptions, and budget journal creation.
• PSB_WORKSHEETS_I — supplies interface worksheet/export names (TNAME = 'WSI') for move-to-interface processing.

These definition tables are combined through UNION ALL into an inline view (COMBO_T) that is joined back to the error rows using correlated OR predicates on PROCESS_ID and a discriminator tag, so that each error is matched only to the correct type of source object. ETRM documents no explicitly named referenced base objects, but the view text confirms the dependencies above.

Key Columns

• CONCURRENT_REQUEST_ID — the concurrent request that produced the error; the primary troubleshooting key.
• PROCESS_ID — identifier of the specific PSB entity (budget group, data extract, worksheet, or interface worksheet) involved.
• SOURCE_PROCESS — internal lookup code such as DATA_EXTRACT_VALIDATION, VALIDATE_BUDGET_HIERARCHY, WORKSHEET_CREATION, POSITION_WORKSHEET_EXCEPTION, CREATE_BUDGET_JOURNAL, or MOVE_TO_INTERFACE.
• SOURCE_PROCESS_MEANING — the user-facing description obtained from FND_LOOKUPS.
• PROCESS_NAME — the resolved name of the budget group, data extract, worksheet, or interface worksheet, produced by DECODE logic over COMBO_T.NAME.

Common Use Cases and Queries

Typical scenarios include diagnosing why a budget submission failed, monitoring errors by concurrent request, and auditing which budget groups or worksheets repeatedly raise exceptions.

List all errors for a given request:

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

Count errors grouped by source process:

• SELECT source_process_meaning, COUNT(*) FROM apps.psb_error_requests_v GROUP BY source_process_meaning ORDER BY 2 DESC;

Find all errors tied to a specific named worksheet or budget group:

• SELECT concurrent_request_id, process_id, process_name FROM apps.psb_error_requests_v WHERE process_name = :name;

Because the view deduplicates on request, process, and source process, users should join to PSB_ERROR_MESSAGES directly when the full error text of each individual message is required.