New EDI Transactions

We deliver PeopleSoft applications with a number of EDI transactions already defined. You can use PeopleTools to add support for additional transactions. Here are the major steps in the process.

To process new EDI transactions:

  1. Use PeopleTools to develop the application that processes the transaction.

    Create the database tables and the pages that users need to process the transaction.

  2. Define a PeopleSoft Business Document format based on the EDI format for the transaction.

    At this step, think about how the data from the EDI document needs to map to the PeopleSoft application tables.

  3. Write a translation program that converts EDI documents into PeopleSoft Business Document format.

    Usually, you will have an EDI translator program to do this step.

  4. Create staging tables to serve as a temporary holding area between the PeopleSoft document and the application tables.

  5. Create maps to copy data between the PeopleSoft business documents and the staging tables.

  6. Write an application load procedure that transfers data from the staging tables to the application tables.

The PeopleSoft Business Document Format topic documents step 5 in this procedure.