Integrating General Ledger with Other PeopleSoft Applications
This topic discusses:
Before you set up integration between General Ledger and other PeopleSoft product applications that involve using IPs:
If you are integrating with PeopleSoft HCM products, you must select the HCM product by selecting
Read the Integration Broker topics thoroughly.
See PeopleTools Documentation: Integration Broker Service Operations Monitor
Review the Integration Broker topics to learn how to set up and manage the IB Gateway.
See PeopleTools Documentation: Integration Broker Administration, "Managing Integration Gateways"
Follow these steps to activate integrations on your database. You should perform the setup tasks on both the publishing and subscribing databases, unless stated otherwise.
Set up and configure Integration Broker Gateway.
(Multiple steps are required to set up the gateway. Please see the PeopleTools documentation for details.)
See PeopleTools: Integration Broker Administration, "Managing Integration Gateways"
Activate node definitions.
Activate Service Operation.
- Review Service Operation Security
- Select active for Handler Status and Routings
Provide web service
PeopleTools, Integration Broker, Web Services, Provide Web Service
Check published and subscribed messages.
PeopleTools, Integration Broker, Service Operations Monitor, Monitoring, Asynchronous Services. Or, PeopleTools, Integration Broker, Service Operations Monitor, Monitoring, Synchronous Services
Build Combination Data with Select checked for the Publish to HRMS/SA.
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Combination Editing, Build Combination Data
A ChartField Combo Edit Process Group is added or deleted on the Ledgers For A Unit - Journal Edit Options page.
Set Up Financials/Supply Chain, Business Unit Related, General Ledger, Ledgers For A Unit, Journal Edit Options
Run the full publish run control to publish the messages.
Enterprise Components, Integration Definitions, Initiate Processes, Full Data Publish
Check General Ledger on the Product tab, then navigate to the Product Specific tab and press the Update Version button.
Set Up HRMS, Install, Installation Table
Run the Standard or Advanced ChartField Configuration after modifying or adding ChartFields, depending upon the modifications.
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Configure, Standard Configuration, Or, Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Configure, Advanced Configuration
After you have set up your integration system, you are ready to use it by triggering IPs according to your requirements and business events. This table lists setup and transactional IPs for use with General Ledger (PeopleTools, Integration Broker, Integration Setup, Services):
|
Service/Service Operation |
Queue |
Operation Type |
Remarks |
|---|---|---|---|
|
Setup Integrations: |
|||
|
ACCOUNT_CHARTFIELD_FULLSYNC ACCOUNT_CHARTFIELD_SYNC BUS_UNIT_GL_FULLSYNC BUS_UNIT_GL_SYNC BU_LED_COMB_FULLSYNC BU_LED_GRP_FULLSYNC BU_LED_GRP_SYNC LEDGER_DEFN_FULLSYNC LEDGER_DEFN_SYNC |
GL_SETUP |
One way asynchronous (Out) |
|
|
BUD_PERIOD_CALENDAR_FULLSYNC BUD_PERIOD_CALENDAR_SYNC DETAIL_CALENDAR_FULLSYNC DETAIL_CALENDAR_SYNC |
DETAIL_CALENDAR |
One way asynchronous (Out) |
|
|
PROJECT_FULLSYNC PROJECT_SYNC PROJECT_STATUS_FULLSYNC PROJECT_STATUS_SYNC PROJECT_ACTIVITY_FULLSYNC PROJECT_ACTIVITY_SYNC |
PROJECTS_SETUP |
One way asynchronous (Out) |
|
|
BUS_UNIT_AV_FULLSYNC BUS_UNIT_AV_SYNC BUS_UNIT_HR_FULLSYNC BUS_UNIT_HR_SYNC BUS_UNIT_SF_FULLSYNC BUS_UNIT_SF_SYNC |
HR_SETUP |
One way asynchronous (In) |
|
|
JOURNAL_GEN_APPL_ID_FULLSYNC JOURNAL_GENERATOR_APPL_ID_SYNC |
JOURNAL_GENERATOR |
One way asynchronous (Out) |
Journal Generator Template |
|
DEPT_FULLSYNC DEPT_SYNC |
ENTERPRISE_SETUP |
Bidirectional asynchronous |
|
|
BUS_UNIT_FS_FULLSYNC BUS_UNIT_FS_SYNC ALTACCT_CF_FULLSYNC ALTACCT_CF_SYNC BUDGET_REF_CF_FULLSYNC BUDGET_REF_CF_SYNC BUDGET_SCENARIO_FULLSYNC BUDGET_SCENARIO_SYNC CHARTFIELD1_FULLSYNC CHARTFIELD1_SYNC CHARTFIELD2_FULLSYNC CHARTFIELD2_SYNC CHARTFIELD3_FULLSYNC CHARTFIELD3_FULLSYNC CLASS_CF_FULLSYNC CLASS_CF_SYNC FSCM_CF_CONFIG FUND_LOAD FUND_CF_SYNC OPER_UNIT_CF_FULLSYNC OPER_UNIT_CF_SYNC PRODUCT_CHARTFIELD_FULLSYNC PRODUCT_CHARTFIELD_SYNC PROGRAM_CF_FULLSYNC PROGRAM_CF_SYNC SCHEDULE_FULLSYNC SCHEDULE_SYNC |
ENTERPRISE_SETUP |
One way asynchronous (Out) |
Publish FSCM_CF_CONFIG from ChartField Configuration process. |
|
FSCM_CF_CONFIG Note: With FSCM_CF_CONFIG, financials Standard ChartField Configuration is supported and can be published to HCM release HR89 from release FSCM90. Details of the standard ChartField configuration will be available only if the process completes successfully. PeopleSoft Financials will issue a warning if you attempt an Advanced Configuration action and PeopleSoft HCM is enabled on the Installed Product page. HCM supports only standard configuration. |
ENTERPRISE_SETUP |
One way asynchronous (Out) |
Publish of standard ChartField configuration and log information after the Standard ChartField configuration process completes successfully. |
|
RELEASE_REQUEST RELEASE_RESPONSE |
Synchronous |
Release_Request and Release_Response acts as a set of Synchronized messages to send FSCM version information to HCM when requested. |
|
|
HR_CHARTFLD_COMBO_SYNC |
HR_CHARTFLD_COMBO |
One way asynchronous (Out) |
Launch from SpeedType page. |
|
Transactional Integrations: |
|||
|
HR_ACCT_CD_LOAD |
ENTERPRISE_SETUP |
One way asynchronous (Out) |
Launch from the Combination Build process request. Extract selected data from the ChartField combination data table. Transforms and publishes the data in the PeopleSoft HCM Account Code format. |
|
PAYROLL_ACCTG_TRANSACTION |
PAYROLL_ACCTG_TRANSACTION |
Bidirectional asynchronous |
HCM North America Payroll. See Note #1. |
|
GP_POST_GL |
GP_POST_GL |
Bidirectional asynchronous |
HCM Global Payroll. See Note #1. |
|
STUDENT_ADV_ACCTG_LINE STUDENT_FIN_ACCTG_LINE |
STUDENT_ADMIN_ACCOUNTING |
Bidirectional asynchronous |
Learning Solutions. See Note #1 |
|
LM_ACCTG_LN |
LM_ACCTG_ENTRY |
Bidirectional asynchronous |
(ELM) Enterprise Learning Management. See Note #1. |
|
JOURNAL_LOAD_TEMPLATE |
JOURNAL_LOAD_TEMPLATE |
Bidirectional asynchronous |
Generic accounting entry for demo and users customization. |
|
COMMIT_CNTRL_BUDGET_UPDATE |
COMMIT_CNTRL_BUDGET_UPDATE |
One way asynchronous (In) |
Commitment Control budget journals. |
|
COMMIT_CNTRL_TRAN_CHECK_UPDATE |
COMMIT_CNTRL_TRAN_CHECK_UPDATE |
Bidirectional asynchronous |
Budget checking for commitment control transactions. |
|
LEDGER_LOAD |
LEDGER |
Bidirectional asynchronous |
Works with the Ledger Load process to move ledger data from regional GL to headquarter GL database for consolidation. |
|
XBRL_ASYNC |
XBRL |
One way asynchronous (Out) |
XBRL instance creation. See Note #2. |
|
COMBO_CF_EDIT_REQUEST |
Synchronous |
Combo edit request service calls the combo edit online validation logic. Uses the Service Alias- CFComboEdit, and the Operation Alias — CFComboEditReq. |
|
|
GL_BUDCHECK_ENC_TRANSACTIONS PAYROLL_KK_ENCUMBER_RESPONSE |
GL_BUDGETCHECK |
Bidirectional asynchronous |
Request/response pair that provides real-time budget checking for PeopleSoft HR encumbrance transactions. This could be used as a model for third party applications. See PeopleSoft Enterprise Human Resources documentation: Manage Commitment Accounting |
|
GL_BUDCHECK_EXP_TRANSACTIONS PAYROLL_KK_EXPENSE_RESPONSE |
GL_BUDGETCHECK |
Bidirectional asynchronous |
Request/response pair that provides real-time budget checking for PeopleSoft HR expense transactions. This could be used as a model for third party applications. See PeopleSoft Enterprise Human Resources documentation: Manage Commitment Accounting |
|
GL_BUDCHECK_PAYROLL_REALTIME |
GL_BUDGETCHECK |
Synchronous |
Synchronous (realtime ) budget check of encumbrance transactions from HCM (such as hiring transactions). Used in conjunction with the options that are set in HCM. See PeopleSoft Enterprise Human Resources documentation: Manage Commitment Accounting |
|
GL_BUDCHECK_GETPROCINST_STATUS GL_BUDCHECK_GETTRANS_STATUS GL_BUDCHK_DELETETRANSACTIVITY |
GL_BUDGETCHECK |
Synchronous |
Provides realtime budget checking for PeopleSoft HR or any third party applications. |
|
JRNL_AF_EM_APPROVAL |
GL_EM_APPROVAL |
One way asynchronous (Local to Local) |
GL Actuals and Standard Budget Journal Email Approval |
Note: #1—General Ledger subscribes to these accounting entries and writes the entries to their corresponding accounting tables. When you run Journal Generator, it sends back the accounting message with the updated fields. Please check with the individual products to determine whether they use this service from General Ledger.
Note: #2—The target node is typically an external node that accepts and handles XBRL documents.
See also PeopleTools Documentation: Integration Broker, "Sending and Receiving Messages"
Use to initialize setup tables.
This is typically a one-time setup using service operations with the _FULLSYNC suffix and the FUND_LOAD service operation. Use the Full Table Publish utility to publish the entire setup table. The subscribing database erases its setup table and synchronizes itself by supplying and populating data from the service operation. Make sure that you have activated the full publish rules before you run this process. Navigation to the Full Data Publish utility is
Use to synchronize incremental changes of setup tables.
Setup service operations with a _SYNC suffix are associated with Setup pages. When you make changes to corresponding setup data, such as ChartFields and Detail Calendars, a service operation is published automatically when you save the page.
This section discusses:
Accounting entry service.
Commitment control budget update service.
Realtime budget checking for HCM and third party applications.
HCM account code integration.
Accounting Entry Service
Accounting entries are generated in each PeopleSoft subsystem application and then published to General Ledger. Some of them use the Batch Data Publish utility while others have their specific procedures to publish. Please refer to the application documentation on how to publish data from the subsystems.
After receiving the accounting entries, you run Journal Generator to create journal entries in General Ledger. Journal Generator updates the accounting table and publishes the updated data back to PeopleSoft subsystem applications over the same IP on which it receives accounting entries. Fields that are updated by Journal Generator include Journal ID, Journal date, Journal line number, Fiscal year, Accounting period, and GL_distrib_status.
Please check with the individual PeopleSoft subsystem products to determine whether they use this update service from General Ledger.
Commitment Control Budget Update Service
These steps describe how commitment control budget update messaging works.
For example, HCM Northern Payroll enters and generates commitment control budget data and sends it to General Ledger using the COMMIT_CNTRL_BUDGET_UPDATE service.
Upon receiving the request message, the subscription process runs automatically and updates the budget journal tables, and then initiates the FS_BP budget posting process to update the commitment control ledgers.
See Understanding Entering and Posting Commitment Control Budget Journals.
Realtime Budget Checking for HCM and Third Party Applications
The main purpose of realtime budget checking is to alert the user at transaction time within the HCM application whether there are sufficient funds available (for example, at the time of hiring, transfer, or salary changes). The option to enforce the valid budget check prior to saving a transaction resides within HCM setup.
PeopleSoft provides realtime budget checking of position data from PeopleSoft HCM. Requisitions for positions are validated against budgetary rules in the Financials database. Position offers are booked as Encumbrances. Position data changes, such as bonuses and salary changes, are validated and booked against the budget appropriately. Request services invoke the budget processor and response services send validation or error messages to HCM, which can be viewed (and corrected or overridden) through the HR Enc Exceptions page or the HR Exp Exceptions page. This provides immediate feedback with a link from HCM directly into the Commitment Control Inquiry or Exceptions (if setup and security is enabled).
To implement realtime budget checking, complete the following:
Activate the services that are listed for the GL_BUDGETCHECK queue.
For non-PeopleSoft applications, complete the Service Configuration page (Integration Broker, Configuration, Service Configuration).
Make sure that the application server is active (Integration Broker, Configuration, Quick Configuration).
Add the HR node to the single sign-on for FMS (PeopleTools, Security, Security Objects, Single Signon).
Specify for each source transaction type whether overrides are allowed , disallowed, or automatic. You can, therefore, enable or disable the automatic overrides in payroll and other transactions.
See PeopleSoft Enterprise Human Capital Management documentation: Manage Commitment Accounting
The real-time integration with HCM stores the accounting entries in the record, HP_KK_EXP_LN (rather than HR_ACCTG_LINE). When using journal generator to create the journals from this data, use the new Accounting Entry Definition, HPPAY, which uses the correct Record Update value.
HCM Account Code Integration
HCM maintains its account code table with data from the Financials ChartField combination data table and the Financials SpeedTypes. HCM uses account codes extensively in its systems to represent a combination of ChartField values. Do not confuse these account codes with the account ChartField in Financials.
Financial users access the Build Combination Data page to initiate the build process and to publish ChartField combination data to HCM and Learning Solutions using the HR_ACCT_CD_LOAD service. A service operation publishes data from a selected process group and sends it to HCM to convert it into its account codes. For further details, please read the HCM documentation on account codes.
See PeopleSoft Enterprise Human Resources documentation: Manage Commitment Accounting, "Setting Up Commitment Accounting Processing Control Tables"
When you add or update a user SpeedType and you selected the Publish check box, the ChartField combinations of that SpeedType publish to HCM and convert to their account code.
Note: You use the Publish Data check box to control whether to send the ChartField values of the new or updated SpeedType to PeopleSoft HRMS, which uses the SpeedType to update its Account Code table. The check box is visible and available if the SpeedType is a user SpeedType and the HCM installation option is selected. If the check box is visible but unavailable for entry on the page, the service HR_CHARTFIELD_COMBO_SYNC is not activated. When available, this check box is always deselected by default. This option is not part of the SpeedType data and thus is not saved with your SpeedType definition.