← PeopleSoft Job Interception and Monitoring Configuration

Using the PeopleSoft Plug-In

The PeopleSoft plug-in allows you to install Web Services into your PeopleSoft system to automatically add or edit fields.

Installation

  1. Navigate to Configuration > Software and locate PeopleSoft Transports, choose Download from the context-menu.
  2. Unzip the zip file to a specific folder, such as C:\Users\jdoe\Desktop, folder you want is RAI_RUNREMOTE, it should contain RAI_RUNREMOTE.ini and RAI_RUNREMOTE.xml.
  3. Start the PeopleSoft Application Designer.
  4. Log on to the appropriate database, then select Tools > Copy Project > From File and browse to the folder, such as C:\Users\jdoe\Desktop\rai_runremote.
  5. Choose project RAI_RUNREMOTE (upper-case), select All items and choose Copy.
  6. Choose Build > Project.

Configuration

  1. Navigate to Environment > Process Servers.
  2. Choose Stop from the context menu of your PeopleSoft process server.
  3. Choose Edit from the context menu of your PeopleSoft process server.
  4. On the Parameters tab, choose Add and add parameter PeopleSoft_WSDLRequests.
  5. Fill EODI_SYSTEM, PROCESSREQUEST, RAI_RUNREMOTE, QAS_QRY_SERVICE into the Value field, choose Save & Close.
  6. Choose Start from the context menu of your PeopleSoft process server; note that the process server might take a little longer to start as it loads all calls.

Updating Tables

You update tables to set job or report parameters, and attach attach files to journals.

Syntax

<section1>
[<section2>
...
<sectionN>]

section =
"["<table_name>"]"
*<column1>=<value1>
[*]<column2>=<value2>
[[*]<column3>=<value3>
...
<columnN>=<valueN>]

You specify the table name update/insert you need to specify within the source text the table name (defined as section name) and the table columns that need to be updated/are key columns. The key columns (unique row identification columns) are prefixed with a star (*). These columns are used to identify a unique row, if none is found, a row is added. You update one column per section. Process parameters to be used in the Source field of your process definition must carry the PeopleSoft_ prefix, you specify process parameters as ${<parameter_name>} in the Source field. Any process parameter without the PeopleSoft_ prefix will be sent to the PeopleSoft system.

Example

Submit

[PS_QUERY_RUN_CNTRL]
*OPRID='${PeopleSoft_UserName}'
*RUN_CNTL_ID='${RunControlId}'

[PS_QUERY_RUN_PARM]
*OPRID='${PeopleSoft_UserName}'
*RUN_CNTL_ID='${RunControlId}'
*BNDNUM=1
BNDVALUE=TO_DATE('${PeopleSoft_FROMDATE}', 'YYYY-MM-DD')

[PS_QUERY_RUN_PARM]
*OPRID='${PeopleSoft_UserName}'
*RUN_CNTL_ID='${RunControlId}'
*BNDNUM=2
BNDVALUE=TO_DATE('${PeopleSoft_TODATE}', 'YYYY-MM-DD')

[PS_QUERY_RUN_PARM]
*OPRID='${PeopleSoft_UserName}'
*RUN_CNTL_ID='${RunControlId}'
*BNDNUM=3
BNDVALUE='${PeopleSoft_BUSINESS_UNIT}'

See Also

PeopleSoftConnector

← PeopleSoft Job Interception and Monitoring Configuration