1
Introduction to Oracle Application Server Integration Adapter for PeopleSoft 8

Oracle Application Server ProcessConnect connects to a PeopleSoft system through the Oracle Application Server Integration Adapter for PeopleSoft 8. The Oracle Application Server Integration Adapter for PeopleSoft 8 provides connectivity and executes interactions on a PeopleSoft system. This chapter discusses the following topics:

• Architecture: Oracle Application Server Integration Adapter for PeopleSoft 8

• PeopleSoft Component Interfaces

• Required Software

• Supported Platforms

• Postinstallation

• Importing the Custom Component Interface

Architecture: Oracle Application Server Integration Adapter for PeopleSoft 8

The Oracle Application Server Integration Adapter for PeopleSoft 8 is a JCA-based component that plugs in to Oracle Application Server ProcessConnect. Using Oracle Application Server ProcessConnect, you can access Component Interfaces. The Oracle Application Server Integration Adapter for PeopleSoft 8 communicates with the PeopleSoft system using the PeopleSoft psjoa classes which connects to the PeopleSoft system through the BEA System, Jolt Transaction Protocol. As shown in Figure 1-1, the Oracle Application Server Integration Adapter for PeopleSoft 8 runs on the machine running Oracle Application Server ProcessConnect.

Figure 1-1 Architecture

Text description of the illustration xipps001.gif

To use the Oracle Application Server Integration Adapter for PeopleSoft 8, a modification to the PeopleSoft environment is required. A custom component must be imported into the PeopleSoft system.

See Also: "Importing the Custom Component Interface"

PeopleSoft Component Interfaces

The Oracle Application Server Integration Adapter for PeopleSoft 8 supports outbound interactions. The interactions have both request and reply records. Each record has one record element associated with it. The following naming convention is used for the records:

• Request records

  AEProtocolName_interactionGroupName_interactionName_Request 
  
  

• Reply records

  AEProtocolName_interactionGroupName_interactionName_Reply 
  

  See Also: Chapter 3, "Defining an Interaction"

PeopleSoft Component Interfaces contain tables and data formats for specific tasks. A Component Interface declares the set of interactions that a Component Interface supports, but it does not implement the behavior. The Oracle Application Server Integration Adapter for PeopleSoft 8 provides standard interactions for Component Interfaces:

• Create

• CreateEx

• DeleteOnly

• Find

• Get

• Update

• UpdateEx

  See Also: Chapter 4, "Component Interface Interactions"

Required Software

The Oracle Application Server Integration Adapter for PeopleSoft 8 connects to the PeopleSoft Component Interface, Version 8.17.02.

The following PeopleSoft 8 jar file must be accessible:

• psjoa.jar

Before using Component Interfaces, you must import a custom Component Interface into the PeopleSoft environment.

See Also: "Importing the Custom Component Interface"

Supported Platforms

Oracle Application Server Integration Adapter for PeopleSoft 8 is supported on:

• Solaris 8 (2.8)

• HP-UX 11.0

Postinstallation

Verify you are using PeopleSoft, Version 8.17.02.

Copy the following jar file from your PeopleSoft installation and place it in
ORACLE_install/ip/adapters/lib:

• psjoa.jar

Verify you have imported a custom Component Interface into the PeopleSoft environment.

The files in ORACLE_install/ip/adapters/config/PeopleSoft are provided to create a custom component interface on the PeopleSoft system. The custom component interface must be created on the PeopleSoft system before the Oracle Application Server Integration Adapter for PeopleSoft 8 can be used. Refer to the detailed instructions in
ORACLE_install/ip/adapters/config/PeopleSoft/readme.html.

See Also: "Importing the Custom Component Interface"

Importing the Custom Component Interface

You must modify the PeopleSoft environment to use Oracle Application Server ProcessConnect with the PeopleSoft system. The custom component, GET_CI_INFO, must be imported into PeopleSoft. After importing the custom Component Interface, you can browse Component Interfaces within PeopleSoft. This task is only required on the initial setup of the PeopleSoft system to interact with Oracle Application Server ProcessConnect.

The following instructions explain how to import the custom Component Interface.

Creating the Component Interface

The following steps provide a brief overview of how to use a PeopleSoft application to create the Component Interface.

Using PeopleSoft's Application Designer:

1. Select Start > Programs > PeopleSoft > Application Designer.

2. Select a 3-tier connection type and click OK.

   For example, select Application Server from the list.

3. Select File > New in the Application Designer.

4. Select Component Interface and click OK.

5. Click Select in the Select dialog.

   A list of Component Interfaces is displayed.

6. Select any simple component, for example, SIMPLECALENDAR, and click Select.

   The custom interactions to be installed do not use any properties of the Component Interface.

7. Select File > Save As.

8. Type GET_CI_INFO in the Save Name As field and click OK.

9. Right-click any interaction of your new Component Interface.

10. Select View PeopleCode.

    A text editor window is displayed.

11. Access the ORACLE_HOME/ip/adapters/config/PeopleSoft directory and copy the contents of get_ci_info.pc into the text editor window.

12. Select File > Save to save the new Component Interface, GET_CI_INFO.

    See Also: PeopleSoft online help for complete instructions

Setting Security

After importing the custom GET_CI_INFO Component Interface into PeopleSoft, set the security settings for the GetCINamespace, GetDetails, and GetCollections interactions for Oracle Application Server ProcessConnect.

Using PeopleSoft's Application Designer:

1. Select Go > PeopleTools > Maintain Security.

2. Select Use > Permission Lists > Component Interface > Update/Display.

3. Type an applicable permission list item in the Permission List text box, for example, ALLPNLS, and click OK.

   You can also click OK to retrieve a list of possible permission lists if you do not know which items are available.

4. In the list of Component Interfaces, find the following line:

   Click On This Row To Enter Data

5. Select this row and type GET_CI_INFO to add a new Component Interface in the Maintain Security - Use - Permission Lists dialog box.

6. Select Edit from the menu.

   A dialog box containing the permissions for this Component Interface is displayed.

7. Click Full Access (All) to set full access to all interactions.

8. Click OK to exit the Designer.

The PeopleSoft server is set. You can now use Oracle Application Server ProcessConnect and select PeopleSoft Component Interfaces interactions.