Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 1 Preparing PeopleSoft : Loading the Adapter PeopleSoft Project

Loading the Adapter PeopleSoft Project
The adapter software includes a pre-built PeopleSoft project (TIB_PS8_ADAPTER) that contains the server side adapter code, to be used in PeopleTools 8.4x and above. The project also contains Component Interfaces, components, fields, menus, pages, and records. For detailed project information, see Adapter PeopleSoft Project
You must set up the project in your PeopleSoft database before using the adapter. The TIB_PS8_ADAPTER project to be imported into PeopleTools is located in the TIB_ADPSFT8_HOME\data\TIB_PS8_ADAPTER_PT84x folder. Follow Loading the TIB_PS8_ADAPTER Project to load the project.
Adapter PeopleSoft Project
The following table describes all the items in the TIB_PS8_ADAPTER project.
A - Add.
U - Update.
L - Update All.
C - Correction.
N - Not processed.
I - Intermediate stage.
P - Processed successfully.
E-Error.
Calls a function to write the message to the MQUEUE table after an event has been processed.
This event is fired in more than one context but primarily it is used to declare and store functions to be used to by PeopleCode of other events. Hence the adapter uses this particular record's FieldFormula event to host the PeopleCode defining various functions, which do the processing required to capture and write the data to the MQUEUE table.
Loading the TIB_PS8_ADAPTER Project
To load the project to the PeopleSoft server, you need to finish these tasks in sequence:
For more information on PeopleSoft configuration, see PeopleSoft (Enterprise PeopleTools) Documentation Library.
 
Task A Back Up and Delete the Existing TIB_PS8_ADAPTER Project in the PeopleSoft Database
Before loading the TIB_PS8_ADAPTER project, you need to check whether the project is already in the PeopleSoft database. If there is an existing TIB_PS8_ADAPTER project in the database, you must delete it and load the project from the adapter with the version you want to use.
To check whether the TIB_PS8_ADAPTER project is already in PeopleSoft Database:
1.
2.
Verify that there is no existing TIB_PS8_ADAPTER project already in the database:
a.
b.
3.
If there is an existing TIB_PS8_ADAPTER project, continue to step 4.
4.
Back up any contents of the TIB_CI_MQUEUE table associated with the project.
5.
Delete the existing TIB_PS8_ADAPTER project:
From the menu, select File > Delete. In the Delete Definition dialog, delete all of the items in the TIB_PS8_ADAPTER project in the following order:
a.
b.
c.
d.
e.
f.
6.
Delete the TIB_PS8_ADAPTER project itself and close the Delete Definition dialog.
7.
8.
Task B Copy the TIB_PS8_ADAPTER Project
To load the project:
1.
2.
From the menu, select Tools > Copy Project > From File.
3.
In the displayed dialog, browse to the following directory: TIB_ADPSFT8_HOME\data\TIB_PS8_ADAPTER_PT84x.
4.
Select the TIB_PS8_ADAPTER project from the displayed list and click Select.
5.
6.
The following sample screen shows the structural view of the TIB_PS8_ADAPTER project in the PeopleTools 8.4x Application Designer.
Figure 1 View of the Adapter’s PeopleSoft Project in the 8.4x Application Designer
Task C Oracle Only: Create a Tablespace for Adapter Records
If you are using an Oracle database, you need to create a separate tablespace for the following adapter records:
To create a tablespace and assign records:
1.
2.
3.
4.
From the menu, select Tools > Data Administration > Set Tablespace.
5.
Select Oracle from the Platform drop-down list.
6.
7.
8.
9.
Repeat step 3 to step 8 to add the tablespace to the five records.
10.
Task D Build the TIB_PS8_ADAPTER Project
To build the project:
1.
2.
Open the TIB_PS8_ADAPTER project using PeopleTools Application Designer.
3.
From the menu, select Build > Project.
4.
a.
Click the Settings button and in the displayed Build Settings dialog, select all the options that will regenerate tables, views, and indexes, and click OK.
b.
In the Build Options group box, check the Create Tables checkbox and the Create Views checkbox.
c.
In the Build Execute Options group box, select Execute And Build Script radio button.
5.
Click Build to build the project.
6.
Task E Grant Permissions for Working with CI and IB
To grant permissions for an adapter working with CI and IB:
1.
2.
Log in to PIA and navigate to PeopleTools > Security > Permissions & Roles > Permission Lists.
3.
Find the permission list with a description containing "all pages" and open it. The name of the permission list is different for varied PeopleSoft applications. For example, find HCCPCSSA1000 CS Administration - All Pages in the Permission List, as shown in Figure 2.
Figure 2 Find the All Pages Permission List
4.
a.
Click the Pages tab, add or find the TIBCO_MAINT_MENU menu and grant all permissions to the related components. Then save the change.
b.
Click the Component Interfaces tab, grant Full Access permissions for the following Component Interfaces. If they do not exist, insert them into the Component Interfaces list first.
- TIB_CI_COMPINTFC
- TIB_MQUEUE_DATA_CI
- TIB_MQUEUE_SRCH_CI
- TIB_MSGDET_CI
- TIB_MSGREC_CI
- TIB_MSGVER_CI
- TIB_PUB_COMPINTFC
5.
6.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved