Search Results error_sequence_id

Overview

PSP_REPORT_ERRORS is a transactional table in the PSP (Labor Distribution) product module of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. Per the ETRM metadata, the table is described as containing data for the Warning Report. In practical terms, PSP_REPORT_ERRORS functions as a diagnostic and message-capture repository: it stores error, warning, and informational messages generated during labor distribution processing runs, keyed to the concurrent request that produced them. This makes it a critical object for troubleshooting payroll cost distribution, error reconciliation, and audit trails of processing failures.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is standalone. This is a modeling suggestion only: the table does not behave as a classic hub, link, or satellite, because its relationships are largely request-scoped message records rather than shared business entities. Its grain is one row per error or message occurrence within a processing request, which is reflected in the composite primary key.

Key Information Stored

The documented physical schema contains 31 columns. The most significant are as follows:

• ERROR_SEQUENCE_ID — Part of the composite primary key and also the sole column in the unique index PSP_REPORT_ERRORS_U1, making it the primary business-key candidate for a single message record.
• REQUEST_ID — The concurrent request that generated the message; the second component of the composite primary key and the principal linkage to the concurrent manager execution context.
• MESSAGE_LEVEL — Classification of the record, distinguishing warnings from errors and informational entries.
• ERROR_MESSAGE — The textual message presented in the Warning Report.
• SOURCE_ID / SOURCE_NAME — Identifier and descriptive name of the source object or employee/assignment that triggered the message.
• PARENT_SOURCE_ID / PARENT_SOURCE_NAME — Hierarchical reference to the parent source when the message relates to a nested structure.
• PAYROLL_ACTION_ID — Foreign key to PAY_PAYROLL_ACTIONS, tying the message to a specific payroll action.
• RETRY_REQUEST_ID / PDF_REQUEST_ID — Request identifiers for retry attempts and the PDF output request associated with the run.
• VALUE1–VALUE10 — Generic placeholder columns populated by the process for contextual reporting values (for example, amounts, dates, or codes) that vary by message type.
• INFORMATION1–INFORMATION10 — Additional descriptive text fields supplying supplementary detail for the generated warning or error.

The surrogate primary key is PSP_REPORT_ERRORS_PK, defined over (ERROR_SEQUENCE_ID, REQUEST_ID), while the unique index PSP_REPORT_ERRORS_U1 on ERROR_SEQUENCE_ID alone is the business-key candidate.

Common Use Cases and Queries

Typical scenarios include reconciliation of distribution runs, investigation of why a payroll action produced warnings, and operational reporting on error volumes. A common pattern joins the table back to the concurrent request so messages can be reviewed per run:

• Retrieve all warnings for a given request: SELECT ERROR_SEQUENCE_ID, MESSAGE_LEVEL, ERROR_MESSAGE FROM PSP_REPORT_ERRORS WHERE REQUEST_ID = :request_id ORDER BY ERROR_SEQUENCE_ID;
• Trace errors to payroll actions: SELECT e.ERROR_MESSAGE, p.PAYROLL_ACTION_ID, p.ACTION_STATUS FROM PSP_REPORT_ERRORS e, PAY_PAYROLL_ACTIONS p WHERE e.PAYROLL_ACTION_ID = p.PAYROLL_ACTION_ID;
• Count errors by level for trend analysis: SELECT MESSAGE_LEVEL, COUNT(*) FROM PSP_REPORT_ERRORS GROUP BY MESSAGE_LEVEL;

Related Objects

• PAY_PAYROLL_ACTIONS — Referenced via the PAYROLL_ACTION_ID foreign key; identifies the payroll action associated with each message.
• FND_CONCURRENT_REQUESTS — Joined on REQUEST_ID to obtain request status, timing, and program details.
• PSP_REPORT_ERRORS_PK — The primary key constraint supporting unique access to each message row.
• PSP_REPORT_ERRORS_U1 — The unique index on ERROR_SEQUENCE_ID serving as the business-key candidate.
• PAY_PAYROLL_ACTIONS and related payroll distribution tables — Form the broader context for interpreting PSP Labor Distribution results.
• PSP reporting and Warning Report concurrent programs — Consume PSP_REPORT_ERRORS rows to render the dashboard and PDF output referenced by PDF_REQUEST_ID.