Search Results psb_error_messages

Overview

The PSB_ERROR_MESSAGES table is a critical component within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically serving the Public Sector Budgeting (PSB) module. Owned by the database schema PSB, this table functions as a centralized repository for error messages that are generated during the execution of various Public Sector Budgeting processes. In the context of EBS, this table plays a diagnostic and audit role, capturing runtime exceptions, validation failures, and process-specific errors that occur during budget formulation, approval, or posting cycles. Because PSB processes are often batch-driven and complex, this table provides a structured mechanism for system administrators and functional users to retrieve and analyze failures without having to parse concurrent manager log files. The table is marked as VALID, indicating that its structure and metadata are current and fully supported for the listed Oracle EBS releases.

Key Information Stored

The table’s primary key, CONCURRENT_REQUEST_ID, is the central column and directly ties each error record to a specific concurrent manager request. This column is part of the CONCURRENT_REQUEST_ID_PK constraint. The table is designed to hold the following core data attributes (based on documented structure and standard PSB error logging conventions):

• CONCURRENT_REQUEST_ID (PK): A unique identifier for the concurrent request that generated the error. This is the foreign key linkage to the FND_CONCURRENT_REQUESTS interface.
• Error Sequence/Line Number: Typically stores the order of errors when multiple messages are generated from a single request.
• Error Message Text: The actual descriptive message, identifying the specific validation failure or processing exception, often including table names, column names, or SQL error codes.
• Process Name/Stage: Indicates which specific PSB process (e.g., budget batch posting, funds check) triggered the error.
• Creation Date/Timestamp: Stores the exact date and time when the error was written, facilitating chronological troubleshooting.

Common Use Cases and Queries

In a production support environment, this table is primarily used for post-processing error diagnosis and audit trail analysis. Common use cases include:

• Concurrent Request Failure Analysis: When a PSB concurrent program fails, DBAs query this table to see the exact underlying error message tied to that request ID.
• Historical Trend Monitoring: Reporting which processes generate the highest volume of errors over a fiscal period, aiding in process optimization.
• Data Validation: Cross-referencing errors against budget document IDs to identify problematic budget lines.

Example diagnostic query pattern:

SELECT CONCURRENT_REQUEST_ID, ERROR_MESSAGE, CREATION_DATE
FROM PSB.PSB_ERROR_MESSAGES
WHERE CONCURRENT_REQUEST_ID = :P_CONC_REQ_ID
ORDER BY CREATION_DATE DESC;

Use case: Identify all errors for a specific request and retrieve the messages to correlate with the log file output.

Related Objects

Based on the documented relationship data, the primary related object is the FND_CONCURRENT_REQUESTS table in the APPLSYS schema. The join is established via the CONCURRENT_REQUEST_ID column, where PSB_ERROR_MESSAGES.CONCURRENT_REQUEST_ID = FND_CONCURRENT_REQUESTS.CONCURRENT_REQUEST_ID. This relationship allows for joined queries that retrieve user-friendly request metadata (e.g., request status, program name, requester) alongside the error details. The PSB_ERROR_MESSAGES table is also indirectly related to the FND_CONCURRENT_PROGRAMS table (through FND_CONCURRENT_REQUESTS) to identify which program produced the errors. No other direct foreign keys to PSB-specific tables were documented in the provided metadata, though in practice, the error message text often references PSB budget header or line tables such as PSB_BUDGET_DOCUMENTS for contextual tracing.