Contact Us 1-800-596-4880

Oracle PeopleSoft Connector Release Notes - Mule 3

Support Category: Premium

Anypoint Connector for Oracle PeopleSoft (PeopleSoft Connector) provides real-time connectivity to query and update any PeopleSoft module using a common integration interface known as the Component Interface.

2.2.1

December 3, 2019

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

You can now log requests and responses with PeopleSoft. To view this information, add a Logger of the class org.mule.modules.peoplesoft.runtime.JoaClientImpl at DEBUG level in the log4j2.xml file of the Mule app.

You can set the Logger class with this log4j2.xml statement:

<AsyncLogger
    name="org.mule.modules.peoplesoft.runtime.JoaClientImpl"
    level="DEBUG"
    additivity="false">

Fixed Issues

None

2.2.0

November 14, 2019

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

You can now customize the date and time format for the connector. The default value is MM/dd/yyyy K:mm:ssa. K is the hour in AM or PM, and ssa is seconds with an AM indicator. See Java SimpleDateFormat Online Tester for date and time formats.

Fixed Issues

You can now use a different dateTime format than the default. This allows the connector to work when the format has been changed in the server. (SE-13355)

2.1.2

October 23, 2019

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

None

Fixed Issues

An error message occurred forĀ a required PeopleSoft connector field, even though a field value was specified. (SE-7156)

2.1.1

January 26, 2018

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

None

Fixed Issues

  • Find operation - The FIND operation failed when at least one returned field was not listed as searchable. The connector filters those fields instead of failing.

  • List values - The connector was not handling requests with list values properly, often taking just the first value of the list.

  • Auto-generated IDs - When using the SAVE operation to create an object with the ID set as NEW, the connector did not return the ID generated by PeopleSoft.

  • TPESVCFAIL error - Under some scenarios, the connector would throw this error on SAVE operations with multivalued list attributes.

2.1.0

October 13, 2016

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

Domain Connection Password - The present version allows the use of the property "DomainConnectionPwd" to be set in the Global Element settings of the PeopleSoft connector. In the XML, the new attribute displays as follows:

<peoplesoft:config name="PeopleSoft"
    server="${config.server}"
    username="${config.username}"
    password="${config.password}"
    domainConnectionPwd="${config.domainConnectionPwd}"
    ...
</peoplesoft:config>

Oracle recommends the use of Domain Connection passwords on all the new releases. The domain connection password adds an extra layer of security between the PeopleSoft application server domain and any connections made to it. It is recommended to use PSADMIN to update this value. All domains, PeopleSoft Internet Architecture, and three-tier workstations used for a particular database, must use the same domain connection password. The default value is PS.

Fixed Issues

N-Level iteration for GET operation - When retrieving information from a CI (Component Interface), if a field of the CI response contained an array list, the connector didn’t perform an 'n'-level iteration, it only retrieved the first element of the list. The new version of the connector correctly displays all levels of nested objects.

2.0.1

April 8, 2016

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Fixed Issues

Support for effective-dated components when performing a creation or an update. Key fields sent along the payload got lost in the process, resulting in the misleading error message "No rows exist for the specified keys".

2.0.0

September 7, 2015

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

  • Improvement of Test Connectivity. This includes validation for every interface declared in the Component Interface list.

  • Support for Multi-Level DataSense. Previously, the list of available components and operations was contained within a single dropdown menu and each item was displayed in the form of Component#Operation. Now, that list has been split in two: one dropdown for the component names and the other for the available operations. Additionally, the redundant operation label Invoke Operation has been renamed to Invoke Component Interface.

  • DataWeave integration in demo examples

1.1.0

March 31, 2015

Compatibility

Software Version

Mule

3.6.0 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

  • Added native library support for Mule projects created in Anypoint Studio without Maven. It enables you to add the required PeopleSoft Java Object Adapter (psjoa.jar) library from the Global Element configuration, without having to use Maven or to install the JAR locally and add the dependency to the Project Object Model (POM).

  • Included new demo examples for invoking Find, Get, and Save operations on your Component Interfaces.

1.0 (Public Beta)

February 17, 2015

Compatibility

Software Version

Mule

3.5.2 and later

Java

7

PeopleSoft

9.2

PeopleTools

8.53.02

Features

Based on the Component Interface list provided in Connection Management, PeopleSoft connector exposes the PeopleSoft components through the Invoke operation. Using DataSense, the connector automatically populates the Record fields and methods defined by the Component Interface. Record fields on the component are mapped to the keys and properties of the component interface. Both Standard and User-defined methods created in the PeopleSoft Application Designer on the component are retrieved by the connector using DataSense feature of Mule Devkit.

Usage Information

Because of the complex nature and the underlying limitations of PeopleSoft and its integration interfaces, you may encounter the following while using the PeopleSoft connector.

Issue Type Description

Compatibility

PeopleSoft connector works only in Java 1.7.0_x environment. You need to make sure that AnyPoint Studio, Mule Standalone, CloudHub deployment, or any associated software is using Java 1.7.0_x for the connector to work properly.

The connector supports integration with PeopleSoft v9.2 and PeopleTools v8.53.02 or higher.

Component Interface Configuration

Since Component Interfaces provide an API that is identical to the business Component they provide an interface to, the input data is also bound by all of the defaults, codes and required values that would be required to use the Component in a Web browser. Values provided must match the values provided to the component, which may require looking up. (For example, drop downs may contain "US Dollars" as a value visible to the user, but the code "USA" is provided to the Component Interface.)

When you try to use the connector with a PeopleSoft Component Interface, you may receive errors related to the functional validity of the data. You need to work with a PeopleSoft functional specialist to resolve the reason for these errors.

Due to the design of Component Interfaces, the names of some operations can be misleading. For example, Create operations only returns a handle to a new instance (logically equivalent to clicking New for a given component), but does not update the data in PeopleSoft. If you want to make changes to the PeopleSoft data, you must use the Save operation.

Mule Application Configuration

You must provide a Component Interface list in your Mule flow for DataSense and the connector to work correctly.

You must provide a psjoa.jar file, which is compiled with your PeopleSoft instance, in your Build path. Without the file, Mule applications throw a ClassNotFound exception. The psjoa.jar file is provided by your PeopleSoft administrator(s).

PeopleSoft 9.2 includes several modules, such as: Human Capital Management (HCM), Financial Management (FM), Enterprise Services Automation (ESA), Supplier Relationship Management (SRM), Customer Relationship Management (CRM) and Campus Solution (CS).