Integrating PeopleSoft HCM 9.1 with PeopleSoft GL (Non-Commit Accounting)

We implemented both PeopleSoft FIN and HCM back in 2011, and one of the things we wanted to utilize was the integration between PeopleSoft Payroll NA and PeopleSoft GL.  However, there was a lot of confusion on how this integration worked and what need to be done to accomplish it.  The consultant's that we hired had never setup the integration completely and recommended that we customize the PAYGL01 to populate the chartfield values on the hr accounting line based on the employee's job record.  This worked fine, but it limited our organization's ability to track chartfield values below the department level and it prevented the Payroll to AP integration from working, since the chartfield values where not getting populated on the liability tables only the accouting line.  It also created some posting issues, since we never knew if the chartfield values we populated where valid until we posted them in FIN!

In summary, we took a quick fix approach to get us live on PeopleSoft, that we knew we would have to readdress later.  When later finally came, we discovered that the process for setting up the integration was not that difficult after all!  Here are the steps to setup Payroll Integration between and GL.

 1. Configure Integration Broker and sync the data between your systems.

Service Operation	Description
RELEASE_REQUEST	HRMS requests an update of the General Ledger version from Financials.
RELEASE_RESPONSE	HRMS receives the update of the General Ledger version from Financials.
FSCM_CF_CONFIG	HRMS receives the specific ChartField configuration template from Financials.
One integration point for each GL ChartField	HRMS receives the ChartField values published from the Financials database. See Entering and Maintaining ChartField Values.
HR_ACCT_CD_LOAD	HRMS receives the combination codes imported from the Financials database or flat file and populates the GL Account Code table (GL_ACCT_CD_TBL).
HR_CHARTFLD_COMBO_SYNC	HRMS receives the service operation published by the Financials database to keep the Speed Type table up to date.
COMBO_CF_EDIT_REQUEST	HRMS sends a request to the Financials database (8.4.01 or higher version) to validate a combination code.
COMBO_CF_EDIT_REPLY	HRMS receives and processes the response from the Financials database to a request for validation
BUS_UNIT_GL_FULLSYNC	Financials database initial full table publish of GL business unit IDs.
BUS_UNIT_GL_SYNC	Financials database ongoing incremental publish of GL business unit IDs.
BUS_UNIT_FS_FULLSYNC	Financials database initial full table publish of GL business unit descriptions
BUS_UNIT_FS_SYNC	Financials database ongoing incremental publish of GL business unit descriptions
JOURNAL_GEN_APPL_ID_FULLSYNC	Financials database initial full table publish of PeopleSoft Journal Generator templates
JOURNAL_GENERATOR_APPL_ID_SYNC	Financials database ongoing incremental publish of PeopleSoft Journal Generator templates.
PAYROLL_ACCTG_TRANSACTION	PeopleSoft HCM database batch publish of HR (payroll) accounting lines.

2. Associate a GL/AP Buiness Unit to your HR Business Units  

3. GL/HR Business Unit Mapping- Associate a Journal Template to your Business Unit.

4. Turn on the General Ledger option on the HCM Installation Record

5. On the Product Specific Tab on the HCM Intall press the Update Version button in the General Ledger Group box

6. Publish Chartfield Data from Finance to HCM

   A. When building Combination Data in FIN publish process groups to HCM 

 B. Load Combination Code Table in HCM

7. Create GL Activity Groups

 

8. Map your Expenses.

Now you are ready to send Payroll to GL.