Understanding the PeopleSoft Enterprise Learning Management with JD Edwards EnterpriseOne Integration

This chapter provides overview of the:

Release levels.
Business process.
Integration architecture.
Integration points.
Assumptions and setup considerations.

Release Levels

This document supports the integration between JD Edwards EnterpriseOne 8.12 and PeopleSoft Enterprise 8.8 Learning Management.

Business Process

With the PeopleSoft Enterprise Learning Management with JD Edwards EnterpriseOne integration, you can use the leading-edge PeopleSoft Enterprise Learning Management system in conjunction with JD Edwards EnterpriseOne Financials and HCM.

The JD Edwards EnterpriseOne system is used to manage employee and financial data. The PeopleSoft Enterprise system is used to manage training and curriculum data.

The major tasks involved in the integration of PeopleSoft Enterprise Learning Management with the JD Edwards EnterpriseOne system are:

Setting up integration options and code cross-referencing in the JD Edwards EnterpriseOne WSG soft-coding/cross-reference database.
Setting up the integration in the PeopleSoft Enterprise database.
Loading JD Edwards EnterpriseOne master data into PeopleSoft Enterprise tables.
Synchronizing incremental changes in JD Edwards EnterpriseOne master data with the PeopleSoft Enterprise system.
Sending PeopleSoft Enterprise objectives to JD Edwards EnterpriseOne competencies.
Sending journal entries for objectives met or departmental chargebacks from the PeopleSoft Enterprise system to the JD Edwards EnterpriseOne system.

Integration Architecture

This section discusses the integration architecture for the:

Objectives to competencies process.
Journal entry process.

Integration Architecture for the Objectives to Competencies Process

This diagram illustrates the objectives to competencies process:

Objectives to Competencies Process

Sending PeopleSoft Enterprise objectives to JD Edwards EnterpriseOne competencies consists of these major steps:

A PeopleSoft Enterprise Learning Management user makes a change in objectives data.
At the time of the change, the PeopleSoft Enterprise Learning Management system creates the LM_HR_LRNR_OBJECTIVES_SYNC message.
The Integration Server is listening for the EIP message, and triggers the E_Objective_To_E1_Competency integration flow, which converts the LM_HR_LRNR_OBJECTIVES_SYNC message and inserts the data in the Resource Competencies Unedited Transactions File table (F05100Z1).
A JD Edwards EnterpriseOne user runs the Inbound Resource Competency Transaction program (R05100Z1) to validate the data and update the Resource Competencies table (F05100).
A JD Edwards EnterpriseOne user uses the Manage Resource Competencies program (P05100Z) to review any data that was not validated by the Inbound Resource Competency Transaction program.

Integration Architecture for the Chargeback Process

This diagram illustrates the process of sending journal entries from PeopleSoft Enterprise Learning Management to the JD Edwards EnterpriseOne system:

Chargeback process

Sending journal entries from PeopleSoft Enterprise Learning Management to the JD Edwards EnterpriseOne system consists of these major steps:

The PeopleSoft Enterprise user publishes the LM_ACCTG_LN Outbound XML message with the Learning Management information to create JD Edwards EnterpriseOne journal entries.
The Integration Server is listening for the EIP message, and triggers the E_Subledger_to_E1_Account_Ledger integration flow, which transforms the message data and inserts the data in the Journal Entry Batch table (F0911Z1).
The Integration Server determines whether the insert was successful and posts LM_ACCTG_LN Inbound reply message to the PeopleSoft Enterprise system.
The PeopleSoft Enterprise system receives the reply message.
A JD Edwards EnterpriseOne user runs the Journal Entries Batch Processor program (R09110Z) to validate the data and update the Account Ledger table (F0911).
A JD Edwards EnterpriseOne user runs the G/L Post program (R09801) to post the F0911 records to the F0902 table.

Integration Points

This chapter lists integration points for:

Initial batch loads
Incremental synchronizations
Transactions

Integration Points for Initial Batch Loads

This table lists the integration points used by the Learning Management integration for the initial batch loads of data from the JD Edwards EnterpriseOne system to the PeopleSoft Enterprise system.

Important! The integration points in this table are listed alphabetically by Integration Flow name. Do not run the initial batch load integrations in this order. The proper order for running the batch load integrations is listed later in this guide.

The integration points include:

PeopleSoft Enterprise Message Name	Integration Service Flow	JD Edwards EnterpriseOne Object/Event	Description
ACCOUNT_ CHARTFIELD_FULLSYNC	E1_Accounts_To_E_Chartfields: convert_E1_Accounts_To_E_Chartfields	Account Master Batch Load (R8909F0901)	This integration point retrieves JD Edwards EnterpriseOne account data from a flat file and converts it to PeopleSoft Enterprise Learning Management ChartFields.
PERSON_BASIC_FULLSYNC	E1_Address_Book_To_E_Person: convert_E1_Address_Book_To_E_Person	Address Book Master Batch Load (R8901F0101)	This integration point retrieves JD Edwards EnterpriseOne employee data from a flat file and converts it to PeopleSoft Enterprise Learning Management person data. This integration point loads the person data into staging tables in the PeopleSoft Enterprise Learning Management system. To transfer this data from the staging tables to the live person tables, you must run the Load Person/Workforce Tables process.
LM_DEPT_FULLSYNC	E1_Business_Unit_To_E_Department: convert_E1_Business_Unit_To_E_Department	Business Unit Batch Load (R8900F0006)	This integration point retrieves JD Edwards EnterpriseOne business unit data from a flat file and converts it to PeopleSoft Enterprise Learning Management department data. This integration point loads the department data into staging tables in the PeopleSoft Enterprise Learning Management system. To transfer this data from the staging tables to the live department tables, you must run the Load Department Tables process.
ROLE_COMP_FULLSYNC	E1_Comp_Job_Desc_To_E_Role_Comp: convert_E1_Comp_Job_Desc_To_E_Role_Comp	Batch Load Outbound Job Descriptions (R89F080601)	This integration point retrieves JD Edwards EnterpriseOne role competencies data from a flat file and converts it to PeopleSoft Enterprise Learning Management person data.
BUS_UNIT_HR_FULLSYNC	E1_Company_To_E_HR_Business_Unit: convert_E1_Company_To_E_HR_Business_Unit	Company Manage Notify Initial Load (R0010IL)	This integration point retrieves JD Edwards EnterpriseOne company data from a flat file and converts it to PeopleSoft Enterprise Learning Management HR business unit data.
BUS_UNIT_GL_FULLSYNC	E1_Company_To_E_GL_Business_Unit: convert_E1_Company_To_E_GL_Business_Unit	Company Manage Notify Initial Load (R0010IL)	This integration point retrieves JD Edwards EnterpriseOne company data from a flat file and converts it to PeopleSoft Enterprise Learning Management GL business unit data.
CURR_QUOTE_MTHD_FULLSYNC	E1_Currency_Rates_To_E_Currency_Quote_Method: convert_E1_Currency_Rates_To_E_Currency_Quote_Method	Currency Exchange Batch Upload (R8900F0015)	This integration point retrieves JD Edwards EnterpriseOne currency exchange rates data from a flat file and converts it to PeopleSoft Enterprise Learning Management currency quote method data.
MARKET_RATE_DEFN_FULLSYNC	E1_Currency_Rates_To_E_Market_Rate_Definition: convert_E1_Currency_Rates_To_E_Market_Rate_Definition	Currency Exchange Batch Upload (R8900F0015)	This integration point retrieves JD Edwards EnterpriseOne currency rate data from a flat file and converts it to PeopleSoft Enterprise Learning Management market rate data.
MARKET_RATE_FULLSYNC	E1_Currency_Rates_To_E_Market_Rates: convert_E1_Currency_Rates_To_E_Market_Rates	Currency Exchange Batch Upload (R8900F0015)	This integration point retrieves JD Edwards EnterpriseOne currency rate data from a flat file and converts it to PeopleSoft Enterprise Learning Management market rate data.
WORKFORCE_FULLSYNC	E1_Employee_Master_To_E_Workforce: convert_E1_Employee_Master_To_E_Workforce	Employee Master Batch Load (R89F060116)	This integration point retrieves JD Edwards EnterpriseOne employee data from a flat file and converts it to PeopleSoft Enterprise Learning Management workforce data. This integration point loads the workforce data into staging tables in the PeopleSoft Enterprise Learning Management system. To transfer this data from the staging tables to the live workforce tables, you must run the Load Person/Workforce Tables process.
JOURNAL_GEN_APPL_ID_ FULLSYNC	E1_Hardcodes_To_E_Journal_Generator: convert_E1_Hardcodes_To_E_Journal_Generator	None	This integration point loads hard-coded data to the PeopleSoft Enterprise Learning Management Journal Generator.
MARKET_RATE_INDEX_FULLSYNC	E1_Hardcodes_To_E_Market_Rate_Index: convert_E1_Hardcodes_To_E_Market_Rate_Index	None	This integration point loads hard-coded data to the PeopleSoft Enterprise Learning Management Market Rate Index.
POSITION_FULLSYNC	E1_Job_In_BU_To_E_Position: convert_E1_Job_In_BU_To_E_Position	Batch Load Outbound Jobs Within Business Units (R890800601)	This integration point retrieves JD Edwards EnterpriseOne job in business unit data from a flat file and converts it to PeopleSoft Enterprise Learning Management position data.
PERSON_COMPETENCY_FULLSYNC	E1_Resource_Comp_To_E_Person_Comp: convert_E1_Resource_Comp_To_E_Person_Comp	Resource Competencies Batch Load (R89F05100)	This integration point retrieves JD Edwards EnterpriseOne competency data from a flat file and converts it to PeopleSoft Enterprise Learning Management person competency data. This integration point loads the competency data into staging tables in the PeopleSoft Enterprise Learning Management system. To transfer this data from the staging tables to the live person competency tables, you must run the Load Person Competency Tables process.
RATING_MODEL_FULLSYNC	E1_Scale_To_E_Rating_Models: convert_E1_Scale_To_E_Rating_Models	Scale Batch Load (R89F05103)	This integration point retrieves JD Edwards EnterpriseOne scale data from a flat file and converts it to PeopleSoft Enterprise Learning Management rating model data.
COMPETENCY_FULLSYNC1	E1_To_E_Competency: convert_E1_To_E_Competency	Competencies Batch Load (R89F05104)	This integration point retrieves JD Edwards EnterpriseOne competency data from a flat file and converts it to PeopleSoft Enterprise Learning Management competency data. Before running this integration point, the user should set up objectives in the PeopleSoft Enterprise Learning Management system. See PeopleSoft Enterprise Learning Management 8.81 Implementation Guide, “Setting Up Objectives.”
JOBCODE_FULLSYNC	E1_Jobcode_To_E_ELMJobcode: convert_E1_Jobcodes_To_E_ELMJobcodes	Job Information Batch Load (R89F08001)	This integration point retrieves JD Edwards EnterpriseOne job code data from a flat file and converts it to PeopleSoft Enterprise job code data.
MARKET_RATE_TYPE_FULLSYNC	E1_To_E_Market_Rate_Type: convert_E1_To_E_Market_Rate_Type	User Defined Codes (F0005)	This integration point retrieves the values for user-defined code (UDC) 11/RT (Multicurrency Rate Type) from the JD Edwards EnterpriseOne system and converts them to PeopleSoft Enterprise Learning Management market rate types.
LM_USER_PROFILE	E1_User_Preference_to_E_LM_User_Profile: convert_E1_User_Preference_To_E_User_Profile	User Profile Batch Load (R89F0092B)	This integration point retrieves JD Edwards EnterpriseOne user preference data from a flat file and converts it to PeopleSoft Enterprise Learning Management user profile data. Before running this integration, the user should set up PeopleSoft Enterprise Learning Management roles in the JD Edwards EnterpriseOne system.

See Loading Master Data for the Learning Management Integration.

Integration Points for Incremental Synchronizations

This table lists the integration points used by the Learning Management integration for the incremental synchronization of data from the JD Edwards EnterpriseOne system to the PeopleSoft Enterprise system:

PeopleSoft Enterprise Message Name	Integration	JD Edwards EnterpriseOne Object/Event	Description
ACCOUNT_CHARTFIELD_ SYNC	E1_Accounts_To_E_Chartfields: convert_E1_Accounts_To_E_Chartfields	RTAMOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne account data to PeopleSoft Enterprise Learning Management ChartFields.
LM_USER_PROFILE	E1_Address_Book_To_E_LM_User_Profile: convert_E1_Address_Book_To_E_LM_User_Profile	RTABOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne address book and user preference data to PeopleSoft Enterprise Learning Management user profiles.
PERSON_BASIC_SYNC	E1_Address_Book_To_E_Person: convert_E1_Address_Book_To_E_Person_Sync	RTPIOUT and RTABOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne employee personal information and address book data to PeopleSoft Enterprise Learning Management person data.
LM_DEPT_SYNC	E1_Business_Unit_To_E_Department: convert_E1_Business_Unit_To_E_Department	RTBUOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne business unit data to PeopleSoft Enterprise Learning Management department data.
ROLE_COMP_SYNC	E1_Comp_Job_Desc_To_E_Role_Comp: convert_E1_Comp_Job_Desc_To_E_Role_Comp	RTJDOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne role competencies data to PeopleSoft Enterprise Learning Management person data.
BUS_UNIT_HR_SYNC	E1_Company_To_E_HR_Business_Unit: convert_E1_Company_To_E_HR_Business_Unit	RTCOOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne company data to PeopleSoft Enterprise Learning Management HR business unit data.
BUS_UNIT_GL_SYNC	E1_Company_To_E_GL_Business_Unit: convert_E1_Company_To_E_GL_Business_Unit	RTCOOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne company data to PeopleSoft Enterprise Learning Management GL business unit data.
CURR_QUOTE_MTHD_SYNC	E1_Currency_Rates_To_E_Currency_Quote_Method: convert_E1_Currency_Rates_To_E_Currency_Quote_Method	RTCROUT	This integration point sends incremental changes in JD Edwards EnterpriseOne currency exchange rates data to PeopleSoft Enterprise Learning Management currency quote method data.
MARKET_RATE_DEFN_SYNC	E1_Currency_Rates_To_E_Market_Rate_Definition: convert_E1_Currency_Rates_To_E_Market_Rate_Definition_Sync	RTCROUT	This integration point sends incremental changes in JD Edwards EnterpriseOne currency rate data to PeopleSoft Enterprise Learning Management market rate data.
MARKET_RATE_SYNC	E1_Currency_Rates_To_E_Market_Rates: convert_E1_Currency_Rates_To_E_Market_Rates	RTCROUT	This integration point sends incremental changes in JD Edwards EnterpriseOne currency rate data to PeopleSoft Enterprise Learning Management market rate data.
WORKFORCE_SYNC	E1_Employee_Master_To_E_Workforce: convert_E1_Employee_Master_To_E_Workforce	RTEMOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne employee data to PeopleSoft Enterprise Learning Management workforce data.
POSITION_SYNC	E1_Job_In_BU_To_E_Position: convert_E1_Job_In_BU_To_E_Position	RTJBUOUTB	This integration point sends incremental changes in JD Edwards EnterpriseOne job in business unit data to PeopleSoft Enterprise Learning Management position data.
PERSON_COMPETENCY_ SYNC	E1_Resource_Comp_To_E_Person_Comp: convert_E1_Resource_Comp_To_E_Person_Comp	RTRCOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne competency data to PeopleSoft Enterprise Learning Management person competency data.
RATING_MODEL_SYNC	E1_Scale_To_E_Rating_Models: convert_E1_Scale_To_E_Rating_Models	RTSLOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne scale data to PeopleSoft Enterprise Learning Management rating model data.
COMPETENCY_SYNC1	E1_To_E_Competency: convert_E1_To_E_Competency	RTCPOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne competency data to PeopleSoft Enterprise Learning Management competency data.
JOBCODE_SYNC	E1_To_E_Jobcode: convert_E1_To_E_Jobcode	RTJBOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne job code data to PeopleSoft Enterprise job code data.
LM_USER_PROFILE	E1_User_Preference_To_E_LM_User_Profile: convert_E1_User_Preference_To_E_LM_User_Profile	RTUPOUT	This integration point sends incremental changes in JD Edwards EnterpriseOne user preference data to PeopleSoft Enterprise Learning Management user profile data.

Integration Points for Transactions

This table lists the integration points used by the Learning Management integration for the transfer of transactional data between the PeopleSoft Enterprise system and the JD Edwards EnterpriseOne system:

PeopleSoft Enterprise Message Name	Integration Service Flow	JD Edwards EnterpriseOne Object/Event	Description
LM_HR_LRNR_ OBJECTIVES_SYNC	E_Objective_To_E1_Competency: insert_E_Objective_To_E1_Competency	Resource Competencies Unedited Transactions File (F05100Z1)	This integration sends PeopleSoft Enterprise Learning Management objectives data to JD Edwards EnterpriseOne competency data. This integration loads the competency data into a staging table in the JD Edwards EnterpriseOne system. To transfer this data from the staging table to the live competencies table, you must run the Inbound Resource Competency Transaction program (R05100Z1).
LM_ACCTG_LN	E_Subledger_to_E1_Account_Ledger: insert_E_Subledger_to_E1_Account_Ledger	Journal Entry Transactions – Batch File (F0911Z1)	This integration sends General Ledger journal entries for PeopleSoft Enterprise Learning Management transactions to the JD Edwards EnterpriseOne system. This integration loads the journal entries data into a staging table in the JD Edwards EnterpriseOne system. To transfer this data from the staging table to the live account table, you must run the Journal Entries Batch Processor program (R09110Z).
LM_ACCTG_LN	E_Subledger_to_E1_Account_Ledger: insert_E_Subledger_to_E1_Account_Ledger	None	This integration sends a response message from the JD Edwards EnterpriseOne system to PeopleSoft Enterprise Learning Management to indicate whether the insert into the account staging table was successful.

Assumptions and Setup Considerations

The PeopleSoft Enterprise Learning Management to JD Edwards EnterpriseOne integration functions based on these assumptions:

PeopleSoft Enterprise Learning Management departments are equivalent to JD Edwards EnterpriseOne business units.
The positions that are sent to PeopleSoft Enterprise Learning Management are the jobs within business units that are set up in JD Edwards EnterpriseOne Job Competencies, not positions from JD Edwards EnterpriseOne Position Control.
On the JD Edwards EnterpriseOne web server, you must set the directive “triggerAutoFetch” in the jdbj.ini file to be activated (uncommented) and set equal to true in order for the delete action in the Competency Information program (P05104) to generate a realtime event.
In order for realtime events to create XML tags for fields with a value of 0, you must set the XMLElementSkipNullOrZero line to 0 in the INTEROPERABILITY section of the jde.ini file on the JD Edwards EnterpriseOne server, for example:

[INTEROPERABILITY]

XMLElementSkipNullOrZero=0
If you change organizational structures in the JD Edwards EnterpriseOne system after the initial load of data to PeopleSoft Enterprise Learning Management has been completed, you must rerun the JD Edwards EnterpriseOne Job in Business Unit to PeopleSoft Enterprise Positions, JD Edwards EnterpriseOne Employee Master to PeopleSoft Enterprise Workforce, and JD Edwards EnterpriseOne to PeopleSoft Enterprise Competency initial loads.

See Defining Organizational Structures for Job Competencies.