1.15 Installing PeopleSoft PayBill Management

In this section, you activate the required service operations to integrate with the PeopleSoft FSCM 9.2 database. Oracle only supports the PeopleSoft PayBill Management product on the following database platforms:

  • Oracle

  • Microsoft SQL Server

Important:

For the Oracle database platform only: Run the following statement against the PeopleSoft HCM 9.2 database using SQL*PLUS before running the SQL script:

ALTER SESSION set NLS_Date_Format = 'YYYY-MM-DD'

To activate the required service operations to integrate with the PeopleSoft FSCM 9.2 database:

  1. Using a database query tool (such as iSQL, SQL*Plus, or DB2 Command Window), log on to the target PeopleSoft HCM database.

  2. Run the following script from the <PS_APP_HOME>/scripts directory: 

    activate_all_hcm.sql

The script reads a project contained in your PeopleSoft HCM 9.2 database named FO_MESSAGES. Based on this, the script activates service operations, routings and handlers, starts queues, and creates or activates Full Data Publish Rules.