mardi 21 juin 2011

new PeopleBooks with 9.1 Feature Pack

PeopleSoft Financials 9.1 was delivered in March in new release called Feature Pack.
This new release is now packaged with PeopleTools 8.51 instead of PeopleTools 8.50.
This also introduced new features for PeopleBooks that are now using ODLA (Online Documentation Library Application).
So if you need to install PeopleBooks the new release CD set (V24808-01 for Finance, and V23416-01 for HRMS) requires PeopleTools 8.51 with a PIA already up and running.

How to unzip PeopleBooks CD on AIX

If you simply want to unzip a PeopleBooks without installing any additional software, you can use the jar executable provided in your Java SDK. Jar is the Java archive tool.

For example, to unzip the PeopleBooks CD, run the following commands:

mkdir psbooks-fscm91-V24808-01
cd psbooks-fscm91-V24808-01
/usr/java6_64/bin/jar -xvf ../psbooks-fscm91-V24808-01.zip

jeudi 9 juin 2011

How to install Oracle SOA Composite Editor for JDeveloper 11.1.2


Be aware, if you install JDeveloper 11.1.2.x that Oracle SOA Composite Editor for JDeveloper is only available yet for release 11.1.1.5.0.01.74

mercredi 1 juin 2011

How to run Solaris 11 Package Manager Updates with a Proxy

If you try to update the Solaris catalog for Package Manager you might face the following issue:

Error:
Catalog refresh error:
Only 0 out of 1 catalogs successfully updated.
Unable to contact valid package repository
Encountered the following error(s):
Unable to contact any configured publishers.
This is likely a network configuration problem.
Framework error: code: 6 reason: Couldn't resolve host 'pkg.oracle.com'
URL: 'http://pkg.oracle.com/solaris/release'. (happened 4 times)

In most cases this is due to the Proxy you are sitting behind …

A possible workaround to this is the following:
 - connect as root
 - start a Terminal
 - execute:
export http_proxy="http://TSF\myaccount:mypwd@proxy.3sixtyfive.net:8080"
    Where
          TSF is your domain
          myaccount is your user account
          mypwd is your user password
          proxy.3sixtyfive.net is your proxy
          8080 is your proxy port
    ie:

 - execute:
/usr/bin/packagemanager

The Package Manager will start and you can get updates.

Convert PeopleSoft Excel files to native Excel format

PeopleSoft is delivered in standard with XML Publisher for reporting.
Most reports are generated to PDF or Excel format, but the Excel format is MHTML1 not Excel native BIFF2 format.
If you have the requirement to include some page setup, or some dynamic formulas, you need to convert your MHTML files to BIFF format.

I would recommend to use ExtenXLS 10 Java Spreadsheet SDK, by Extentech:


This library has the availability to read (and write) MHTML and to instanciate them as an Excel WorkSheet.

This library was enhanced for one of my customer and it works fine with PeopleSoft XMLP MHTML files.

Generate PeopleSoft Compare Reports in HTML