Understanding the Error Handling Utility

The Error Handling utility is a PeopleTools application that you use to view and correct messages that are received by the subscriber. You can also use this utility to correct data that is stored in staging tables.

Warning! Effective with the PeopleTools 8.48 release, the Integration Broker Service Operations Monitor supersedes the Error Handling utility.

For more details, see product documentation for PeopleTools: Integration Broker Service Operations Monitor.

PeopleSoft applications that receive flat file data from other systems through batch processes have built-in facilities to validate and correct data prior to updating the main application tables. Likewise, before updating core PeopleSoft application tables, the subscription process detects data errors in the messages that it receives. These error messages are stored in either message queues or staging tables.

In some cases, however, errors can’t be sent back to the third party for correction (such as when data is in a flat file). In these cases, you must provide error processing on incoming data so that messages that contain information about business objects, such as items and vendors, can be corrected and reprocessed in the PeopleSoft system.

In many integration point implementations, especially those that involve huge transactions and complex data validations, subscription codes are written to run simple incoming data validations. Upon a successful outcome, the system performs these steps:

  1. Writes incoming data to staging tables.

  2. Runs more stringent data validation processes, usually in batch processes.

As a result of the first subscription process, entries are written to a special staging table (EO_EIP_CTL). The EO_EIP_CTL table is keyed by a single key, EIP_CTL_ID, and has messaging keys. The EO_EIP_CTL table maintains links between the source message and the staged data and ensures that the data maintenance program can identify the staging tables.

To find the particular message that you want to view:

  1. Select a message by using standard selection criteria, including data maintenance programs, business unit or setID, data status, and staging table or message queue.

  2. Click a detail button to access the application page related to the edited message.

  3. Make your edits.

  4. Save the message.

Note: Messages that are selected from a staging table are saved to the staging table. Before they're saved permanently (to the application table), the corrected messages that were selected from the message queue are assigned a status of Changed and saved to the same queue. The messages then undergo the subscription process data validation again, after which they're saved to an application table.

A data maintenance program corrects errors in data that enters the PeopleSoft system.

Note: Subscription error management does not apply to real-time data that enters the PeopleSoft system through PeopleSoft Business Interlinks.

Error management consists of the following sequential activities:

  1. The PeopleSoft system receives XML messages from a third-party source.

  2. Subscription processes validate the data and send the data to:

    • PeopleSoft application tables (if no errors were found).

    • Message queue (if errors were found).

    • PeopleSoft staging tables (if subscription logic requires).

  3. The Error Handling utility interacts with:

    • Message queue.

    • Staging tables.

  4. The user interacts with:

    • The Error Handling page (to select a message for review or correction).

    • Application pages (for editing data errors).

  5. The PeopleSoft system updates:

    • Message queue (if the original message was selected from the queue).

    • Staging tables (if the original data was extracted for staging tables).