Understanding the PeopleSoft Enterprise Payroll Applications to JD Edwards EnterpriseOne General Ledger Integration

This chapter provides overviews of the:

• Release levels

• Business process

• Integration architecture

• Integration points

Release Levels

This document supports the integration between JD Edwards EnterpriseOne 8.12 and PeopleSoft Enterprise 8.9 Payroll for North America or PeopleSoft Enterprise 8.9 Global Payroll.

Business Process

The purpose of this integration is to translate the accounting entries generated by PeopleSoft Enterprise Global Payroll and PeopleSoft Enterprise Payroll for North America into journal entries that can be accepted and processed in JD Edwards EnterpriseOne General Ledger.

The major tasks involved in the integration of PeopleSoft Enterprise payroll applications with JD Edwards EnterpriseOne General Ledger are:

1. Setup of integration options and code cross-referencing in the JD Edwards EnterpriseOne WSG soft-coding/ cross-reference database.

2. Initial loading, configuring, and mapping of master data:

   1. Load JD Edwards EnterpriseOne master data into PeopleSoft Enterprise tables.

   2. Configure general ledger business units in the PeopleSoft Enterprise system and map them to human resources (HR) business units.

   3. Map JD Edwards EnterpriseOne master data to PeopleSoft Enterprise payroll data.

3. Incremental synchronization of changes in JD Edwards EnterpriseOne master data.

   1. Add, change, or delete actions performed on the master JD Edwards EnterpriseOne tables automatically trigger incremental synchronization integrations.

   2. When the JD Edwards EnterpriseOne system updates data in PeopleSoft Enterprise tables by the incremental integration, PeopleSoft Enterprise payroll users must update data configuration and mapping as needed.

4. Routine transactions such as monthly posting of payroll data to general ledger:

   1. Synchronize currency exchange rates if needed.

   2. PeopleSoft Enterprise payroll applications process and post accounting lines to the JD Edwards EnterpriseOne staging table.

   3. In the JD Edwards EnterpriseOne system, validate transactions and load them into the Account Ledger table (F0911).

   4. If necessary, data errors are corrected in the JD Edwards EnterpriseOne table or the payroll applications reset GL processing, correct errors, reprocess, and repost.

   5. In the JD Edwards EnterpriseOne system, post journal entries to the Account Balances table (F0902).

Integration Architecture

This section discusses the integration architecture for the:

• Import of currency exchange rates.

• Processing of payroll data.

See Also

Batch Loads

Incremental Synchronizations

Integration Architecture for the Import of Currency Exchange Rates Process

This diagram illustrates the PeopleSoft Enterprise import of currency exchange rates from the JD Edwards EnterpriseOne system process:

Import of exchange rates diagram

The import of currency exchange rates is initiated manually in Enterprise and consists of these major steps:

1. A PeopleSoft Enterprise user requests an import of currency exchange rates from the JD Edwards EnterpriseOne system, which publishes the MARKET_RATE_REQ request XML message.

2. The E_MarketRate_To_E1_Exchange Rate integration flow receives the request XML message, retrieves the requested exchange rates from the JD Edwards EnterpriseOne system, and maps the data to the MARKET_RATE_SYNC XML response message.

3. The Integration Server Dispatcher picks up the XML response message and sends it to the PeopleSoft Enterprise system using HTTP.

Integration Architecture for the Processing of Payroll Data

This diagram illustrates the processing of PeopleSoft Enterprise payroll data in the JD Edwards EnterpriseOne system:

Payroll transactions diagram

The routine transfer of PeopleSoft Enterprise payroll accounting entries to JD Edwards EnterpriseOne General Ledger consists of these major steps:

1. The PeopleSoft Enterprise Global Payroll or Payroll for North America user processes payroll to create staging data.

2. The PeopleSoft Enterprise payroll user transfers payroll journal entries to the JD Edwards EnterpriseOne system, by either the PAYROLL_ACCTG_TRANSACTION (Payroll for North America) or GP_POST_GL (Global Payroll) XML message.

3. The E_NorthAmericanPayroll_To_E1_BatchJournalEntry or E_GlobalPayroll_To_E1_BatchJournalEntry integration flow transforms the XML message data and inserts it into a JD Edwards EnterpriseOne batch (Z1) table.

4. The Integration Server returns the PAYROLL_TRANSACTION_REPLY or GP_POST_GL_REPLY status message to the PeopleSoft Enterprise system, indicating whether the table insert was successful.

5. The JD Edwards EnterpriseOne user runs a batch program to post records from the Z1 table to the Account Ledger table (F0911).

6. The JD Edwards EnterpriseOne user posts journal entries from the F0911 table to the Account Balances table (F0902).

   Note. The PeopleSoft Enterprise Global Payroll and Payroll for North America systems must be separately set up, processed, and posted as described in this document.

Integration Points

This table lists the integration points used in this integration and provides a brief description of each: