Monday, August 1, 2016

How to enable Signon Tracing option in PeopleSoft

Imagine a situation where you are banging your head trying to debug the PeopleCode to find out the root cause of an error/warning message appeared while doing transaction on a component. When the component is too big like JOB_DATA then its like looking for a needle in a haystack.

Fortunately, PeopleSoft has some sort solution for every problem and this particular case is not an exception. Do this to tackle it:
  1. Enable the Sign on trace options
  2. Sign in and do the same transaction 
  3. Retrieve the trace file generated in the app server
  4. Look for the place where the error/warning message has been produced
Done..!

The sign on tracing can be enabled by just appending trace=y to the URL as shown below:



As soon as the parameter is appended press Enter and the tracing options will be available. 




It is however very important to note that we must not check all the options under each category because:
  • It will cause the portal to become very slow
  • The generated trace file will be excessively huge 
Therefore, If for example you want to debug an error occurred on the page then simply select the options as shown in the above image and go on. You can also change the selection based on the type of debug you want to perform.

Once you are done doing the transaction, its time to locate the trace file that have been generated. The trace file can be found under:

PS_HOME/appserv/INSTANCE_NAME/LOGS

Where PS_HOME and INSTANCE_NAME can be replaced with the appropriate values for the instance you are working on. For example if PS_HOME is pt854 and INSTANCE_NAME is HRDEMO the path on a UNIX server will look like:

xx/xx/pt854/appserv/HRDEMO/LOGS

And the trace file name will be something like: OPRID_xxxxxxxx.tracesql where xxxxxxxxx will be a number.

New Set ID not visible in Control Data Setup pages in PeopleSoft

When we create a new Set ID from PeopleTools - Utilities - Administration - Table Set ID they don't just be available in the control data setup components like Department, Location, Jobcode etc. unless we map it with a Business Unit.

Didn't get it ?

Let's understand with a simple exercise.

  1. Create a new Set ID as SET01 ( PeopleTools - Utilities - Administration - Table Set ID)
  2. Go to Department Setup page ( Setup HCM - Foundation Tables - Organization - Department)
  3. Click on 'Add New Value' 
  4. Click on Set ID prompt and try to search the newly created Set ID SET01
  5. Set ID cannot be found here.

Now do this:

  1. Create a new Set ID as SET01 ( PeopleTools - Utilities - Administration - Table Set ID)
  2. Go go Business Unit setup page (Setup HCM - Foundation Tables - Organization - Business Unit)
  3. Open an existing BU or create a new one
  4. Assign the newly created Set ID SET01 in the Set ID field under the section 'Default Record Group Set IDs'
  5. Go to Department setup page (Setup HCM - Foundation Tables - Organization - Department)
  6. Click on 'Add New Value' 
  7. Click on Set ID prompt and try to search the newly created Set ID SET01
  8. Set ID is visible this time

That's because we have mapped it to a Business Unit and it became a valid one.