Author: digitaleagle

Configuring Integration Broker for PTF

Before you can start using the PeopleSoft Testing Framework, you have to get Integration Broker setup.  The last post walked you through installing the PTF client.  This one shows how I configured Integration Broker so that I could login with the client.

Much of this information is from PeopleSoft Test Framework Installation Guide.  PeopleBooks is also another good resource if you are looking for more help.

Read More

PTF Startup Error

This is a nice introduction to PTF as I have started playing with it.  Fortunately, the fix turned out pretty simple, so I thought it would make a nice simple blog post.

Here’s the error message:

If you have trouble viewing the image, it reads:

Unhandled exception has occurred in your application.  If you click Continue, the application will ignore this error and attempt to continue.  If you click Quit, the application will close immediately.

Could not find a part of the path ‘C:\Documents and Settings\psadmin\Application Data\PeopleSoft\PeopleSoft Test Framework\localoptions.xml’.

When I looked for the directory, the folder does not exist:

The simple fix: Create the path manually:

Now, it starts (and, it creates the localoptions.xml):

Review: Oracle PeopleSoft Enterprise Financial Management 9.1

I have been working my way through “Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation“, and it has been a great experience for me.  For once, I get a beginner’s introduction to the system rather than trial by fire.  The book does a great job describing how PeopleSoft Financials works and how the modules fit together.  It is a first of its kind in the area of PeopleSoft Financials books.

While this book does not or could not ever give you all you need know about PeopleSoft Financials, it does give you a strong foundation.  No book nor person could contain everything about this system because it is so large, but this book is a definite starting point.  I would recommend it to anyone who is either starting a job where they will use PeopleSoft Financials or anyone going through a Financials implementation.  This book will give you the fundamentals that you need and provide a reference to understand why things work the way they do.

This book is definitely up to date as you can tell by the screen shots.  The book has plenty of graphics to let you know what the various pages look like as you read.  All of the shots reflect the new look delivered by PeopleSoft 8.5x.  The one thing I didn’t see is specific mention of new features delivered in Financials 9.1.  So, the book is geared toward a person new to financials or someone looking for a system overview rather than a person looking for new features after an upgrade from an older PeopleSoft release.

Chapter one did a great job providing an overview and foundation for the rest of the book.  I felt it was a bit long, but there was a lot to cover.  Next the security chapter gives you a good view of how security works in PeopleSoft applications and it also explains the preferences settings that go along with security.  The following chapters walk through the key modules: Billing, Accounts Receivable, Asset Management, Accounts Payable, General Ledger, Expenses, and Commitment Control.  Each chapter tied the module in with the rest of the system, explained the main setup options, and showed the pages used to make it work.

One of the key features of this book was the real-world examples and situations.  The author did a good job of explaining situations in which one would use these features.  You can always go to PeopleBooks and read about what the pages do, but the author provides additional value by showing you how you use the pages of the application to accomplish a business goal.  Throughout the book, you will find “Implementation challenges” where you apply what you have just read in a read-world situation.

The book seemed thorough to me.  It covered many of the functional areas where I have done development work, and I was glad to understand the functional side of those areas much better.  For example, the Expenses module was very interesting to me.  Purchasing and Pay Cycle information was something I was looking for, and while they were mentioned, I learned from a friend that those are more Procurement topics which are outside the scope of the book.  So, the book did a tremendous job at covering such a huge system.

In conclusion, I would highly recommend this book to anyone wanting to learn the basics of PeopleSoft Financials.  It will give you a great overview of the system and is the best starting place I know. Check it out!

Installing Gobal Payroll Rules

This post is a follow up to this thread that I opened.  Unfortunately, at this point, I haven’t figured out what I am doing wrong.  If you see something, please comment either here or on the thread at Oracle Forums.

I am trying to install the  Global Payroll Rules for 856737 and 857845 (both Non-Rule + Rule).

I found that I do this at this navigation: Set Up HRMS > Product Related > Global Payroll & Absence Mgmt > Elements > Manage Global Payroll Packages > Apply Rule Package:

Applying Rule Package

I found a little documentation in PeopleBooks.

Then, I put in the path to my scripts directory, saved, and clicked process.

Adding Scripts Directory

It said the scripts were not found:

Script Not Found Message

But, as far as I can tell, the scripts are in the directory!

Scripts directory

Just for kicks and grins, I copied the DAT files into the same directory:

Scripts Directory with Dat files

Still no luck!

My next attempt is the try to see if case matters.  The files are in lower case in the directory, but on the page the Package ID is uppercase.

Using Lowercase Package ID

That still doesn’t work because it must be an uppercase field:

Rule Package ID made Uppercase

Update:

My problem was the “/” at the end of path.  Once I added the “/” it worked!

Missing Slash

Then, when I clicked process, it ran the data mover script:

Data Mover Script Running

 

 

How to Edit PTIBUpgrade.DMS

While upgrading PeopleTools, one of the steps you have to go through is running this PTIBUpgrade Data Mover script.  It took me a bit to figure out what the values are for the script.

This ITToolbox Thread helped a little bit.

There are 3 values that you have to change in this script.  These are the values that I used:

  • Specified Default User ID: PSEM
  • Specified Default Service Namespace: <your login URL or:> http://xmln.oracle.com/enterprise/tools/service
  • Default Permission List: PTPT1000

The namespace is the option that confused me the most.  According to PeopleBooks, “The namespace field on the Service pages provides qualification for attributes and elements within a WSDL document.  The value defined in the Service Namespace field in the Service Configuration page is used as the default service namespace on the Services page. The default value is http://xmln.oracle.com/enterprise/tools/service.”

If you have better suggestions for the values to use, please comment!

Resources

 

Finding TNSNames Path

Thanks to this post on StackOverflow, I learned a new trick with diagnosing TNS Names issues.  First, you need to download this tool called Process Monitor from SysInternals.

Installing the program is pretty easy.  Simply unzip the program and place it in a good location such as the Program Files directory:

Process Monitor Installed

I always like to create a shortcut in the Start Menu.  If you right click on the Programs menu in your Start Menu, you can choose the open option to open it.  Then, drag with your right mouse button, and you can drop a shortcut in your start menu:

Shortcut for Process Monitor

Once you have Process Monitor installed, you can use the filter to narrow it down to show where it is looking for tnsnames.  Here is what I found that works:

Process Monitor Filter

Add the process name for the process that you want to check.  Use psdmt for Data Mover.  pside for App Designer.  PrcsAppSrv for the App Server launched by psadmin.

Then, if you put tnsnames in for the Path it will show where it is looking for the tnsnames file.

This tool works great for all kinds of situations.  I have also used it to diagnose other connection issues.  I found it was loading the wrong Oracle client on one installation.  I found it was looking in the registry in the wrong place for Tuxedo settings because I had the wrong version.

So, this is a great tool that will help with troubleshooting.

Resources