Search This Blog

PeopleSoft HCM 9.1 Feature Pack

As you’re all aware of, in December, the first PeopleSoft HCM Feature Pack became generally available, providing the following functionality.

- Company Directory
- Talent Management Integration: ePerformance 9.1 to HR 9.0
- Talent Management Integration: Career & Succession Planning 9.1 to HR 9.0
- Talent Management Integration: eCompensation Manager 9.1 to HR 9.0
- Talent Management Integration: Recruiting 9.1 to HR 9.0
- Talent Management Integration: Career and Succession Planning 9.1 to HR 8.9
- Talent Management Integration: eCompensation 9.1 to HR 8.9
- Talent Management Integration: ePerformance 9.1 to HR 8.9
- Clairvia (previously AtStaff) Healthcare Scheduling to HCM
- Effective Dated Configurable Sections for Family Leave
- AWE for Federal
- High priority reports converted from Crystal to XMLP
- IBM Cobol Delivery - Certification of Windows and AIX Platform

While many of these are new capabilities are delivered via off-cycle bundles or maintenance packs, they are now rolled up into the PeopleSoft HRMS 9.1 Feature Pack - December 2010



New People Tools Feature - PeopleSoft Test framework in People Tools - 8.51

People Tools 8.51 has new interesting feature – Test framework as part of people tools objects.

It will be an interesting feature for Testing/Functional and Development teams.

Find out how it works - demo videos.







Visual page compare and merge feature in Application Designer.

Visual way of comparing pages between source and target instances.

Visual Page compare and merge feature in Application Designer. – One of not more widely known feature in Application designer. It is available since People Tools - 8.46.


1) Easier/Visual way to find the differences between the pages in different instance.

2) Compare page without need to include them in any project.

3) Move or Merge the changes in the pages easily.

4) Easy to find the field properties differences.


In Application Designer select Tools -> Diff/Merge Page. This menu item only appears when you have a page definition open (which is probably part of the reason that this feature is not more widely known). You'd then select your target; either another database or an Application Designer project export file.

Pages from both the source and target instance is shown side-by-side and differences are marked in red. Very easily to analyze.

The PeopleSoft Application Designer displays a Property Value panel to show details about every difference or each changed page control. To the right, each page is displayed side-by-side enabling the visual comparison.

Ganesh Muralidhar

Pace-soft - Peoplesoft Trace file analyzer

PeopleSoft SQL Trace file analyzer. New version of Pace-soft trace both *.trc files and *.AET files.

Easily filter the SQL statements in the trace file.

Extracting the useful information from this file can be a significant hurdle. Loading the file in Pace-Trace, this information is made available to you in a clear format. Dramatically speeds the process toward your eventual solution.

e-learnings - a functional point

PAY_ONE_TIME - You would have heard about this table for making adjustments after pay run first calc. Point is, if you are adjusting by (an app engine for example) process, the adjustment entries may be not of PAY_CHECK's. Technically what I am trying to say is, "When you are making entries into PAY_ONE_TIME, dont join PAY_CHECK, just join PAY_EARNINGS with SINGLE_CHECK_USE in P or N. The Pay Calc will take care of pulling it off in Paycheck".

Peoplesoft Navigation of the setup components. - In simple query.

PS_PTLT_COMP_NAV – Define Components Navigation Setup record. - The record stores the PTLT_TASK_CODE which is the component name followed by the market name “.GBL”/Global extension

There is a catch –It doesn’t work for the transaction components like JOB_DATA.
This record is used in setup manager and hence doesn’t have details for the transactional components.

Ganesh Muralidhar

Below query gives for all tables (including hidden).. based the level of navigation (for example Main Menu --> Careers, for this two tables should be joined.. so if you are not getting the results, you have to keep reducing the no of joins :)) it is configured the self join table's count should be increased/decreased...

Oracle------
SELECT D.PORTAL_LABEL ' -->' C.PORTAL_LABEL' -->' B.PORTAL_LABEL ' -->' A.PORTAL_LABEL
FROM PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C,PSPRSMDEFN DWHERE A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAMEAND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAMEAND C.PORTAL_PRNTOBJNAME = D.PORTAL_OBJNAMEAND A.PORTAL_URI_SEG2 ='JOB_DATA_HIRE'


MSSQL-----
SELECT D.PORTAL_LABEL+ ' -->'+C.PORTAL_LABEL+' -->'+ B.PORTAL_LABEL +' -->' + A.PORTAL_LABEL
FROM PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C,PSPRSMDEFN DWHERE A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAMEAND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAMEAND C.PORTAL_PRNTOBJNAME = D.PORTAL_OBJNAMEAND A.PORTAL_URI_SEG2 ='JOB_DATA_HIRE'


Manivannan Ramar

Enable page Anchor

Just a quick thought of sharing this info. you would have heard about 'Enable page Anchor'. how to achive this.

1. The Anchor fields should be a Push Button or Hyperlink
2. On the General tab, Check the box, Enable as Page Anchor and give the Page Filed Name as 'Anchor1' (upto us)
3. Keep this button at the top of the page
4. Create one more field with the same properties (Give the page field name as Anchor2)

5. On both the fields, change the destination (on the Type tab) to Page Anchor
6. Once done, Action tab will be enabled on the same Type tab
7. Give the Action Type as Page Anchor
8. Give 'Related Control' as Anchor 2 for Anchor1 field and Anchor1 for Anchor2 field

Once done, if you click on Anchor1, the control goes to Anchor2 and vice versa.

Mani

Customizing the Help Link

I have seen one requirement from the client, who needs to have their own custom help documents to be displayed along with the PeopleBooks hyperlink, when clicked on the help link. The only way to do it was to track down, from where the PeopleBooks data is being pulled from and add those client customized docs into the folder.

How to do the same? There is a post in the PeopleSoft pros website, where Derek Tomei explains how to accomplish this task.

His blog post is given below:

Using Custom Documentation as PeopleBooks:

Prior to creating custom PeopleBooks, you need to divide documentation and/or training manuals into logical units. For example, if you have a custom component with three custom pages, and the functionality of all three pages is contained within one training document, three distinct documents would have to be created. The information for each page would be used to create an .htm document (.pdf and .doc documents can also be used but .htm is better for searching). Copying the documentation for a page into a Word Web Page template does this.

If, for example, the three custom pages are Query_1, Query_2 and Query_3, the three .htm documents can be saved as qry01.htm, qry02.htm and qry03.htm. It is important, especially if there are numerous custom pages, to use a naming convention that is easy to keep in the order of the pages you are going to attach them to.

Here are 6 Easy Steps to Create Custom PeopleBooks
The following steps detail how to create custom PeopleBooks:

Step 1: Create a new folder, for example Query817, under the weblogic folder on your Web Server. The navigation for PeopleTools 8.1x should be weblogic\ myserver\public_html \htmldoc\eng. This is the same location as the psbooks folder that holds the delivered PeopleBooks.

Step 2: Create a folder under Query817 called Query. In this folder, create a .htm folder and copy the .htm custom query files here. The PeopleSoft delivered Query PeopleBooks are .htm documents and are located under psbooks\tpsq\htm.

Step 3: Copy the contextids folder from a delivered PeopleBooks folder, with all of it’s content, to the custom Query folder that was just created.

Step 4: Modify the content of Query\contextids\q (javascript file). Use q because all of the pages that will have custom documentation begin with Q. The name of this javascript file must match the first letter of the name of the page that will be accessing the documentation. Open the file in Notepad and use the following format to add the custom PeopleBooks. Delete or comment out the delivered code:

o The item in bold is the page name of the page that you are linking a particular .htm file to. This is easy to find by navigating to your custom PeopleSoft page and clicking the HELP link. Since there is currently no PeopleBooks for this custom page, a message will appear stating the nothing could be found for :

bookmarks[bookmarks.length] = "QRY_CRITERIA_FIELD||Query817/Query/htm/qry03.pdf#F1ID_QRY_CRITERIA_FIELD";

o After the page name, the path to the file that contains the documentation for the page:

bookmarks[bookmarks.length] = "QRY_CRITERIA||Query817/Query/htm/qry03.htm#F1ID_QRY_CRITERIA";

o After the file path, the name of the file containing the documentation for the page:

bookmarks[bookmarks.length] = "QRY_FIELDS_SEC||Query817/Query/htm/qry02.htm#F1ID_QRY_FIELDS_SEC";

o After the file name, #F1ID_ and the name of the page:

bookmarks[bookmarks.length] = "QRY_FIELDS||Query817/Query/htm/ qry 02. htm #F1ID_QRY_FIELDS";

bookmarks[bookmarks.length] = "QRY_PROMPT||Query817/Query/htm/qry 02. htm #F1ID_QRY_PROMPT";
bookmarks[bookmarks.length] = "QRY_PROMPT_SELECT||Query817/Query/htm/qry 02. htm #F1ID_QRY_PROMPT_SELECT";
bookmarks[bookmarks.length] = "QRY_PROPERTIES||Query817/Query/htm/qry 05.htm#F1ID_QRY_PROPERTIES";
bookmarks[bookmarks.length] = "QRY_QUERY_HIERJOIN||Query817/Query/htm/qry 05.htm#F1ID_QRY_QUERY_HIERJOIN";
bookmarks[bookmarks.length] = "QRY_QUERY||Query817/Query/htm/qry 01.htm#F1ID_QRY_QUERY";

arraycount[arraycount.length] = bookmarks.length - 1;

These entries link the online Query pages to the corresponding custom PeopleBooks .htm file in the new folder (as described above).

Step 5: Update the following javascript files under weblogic\myserver\public html\htmldoc\eng\js:

o colltypes
o doctypes
o helptypes

In each of these files add the following (in bold):

helptypes = new Array(
"psbooks||PeopleBooks",
"dftie||Transactional Help",
"Query817||Query"
);


Step 6: Update the following javascript files under weblogic\myserver\public html\htmldoc\eng\psbooks\js:

o booklist
o colllist
o helplist

For example, in colllist, insert the following code:

o colllist[colllist.length]="Query817/Query||PeopleTools 8.17:Query||eng/Query817/Query/coll||";

In booklist, insert the following code:

o booknames[booknames.length]="Query817/Query||PeopleTools 8.17: Query";

In helplist, insert the following code:

o helpnames[helpnames.length]="Query817/Query||PeopleTools 8.17: Query";

Conclusion:
Now, the custom PeopleBooks will be accessible through the HELP link when the user is in the custom Query page. Follow these procedures for any custom PeopleBooks that you want to create for your custom pages.

Auto Saving the PeopleSoft page using JavaScript

It was one year back, while I was working with my previous company, one of my colleague implemented an auto save functionality for Performance appraisal data entry page. The requirement was to provide an auto save in the peoplesoft page after a certain interval, as there happened some instances, which the employees enter big novels about their performance and by mistake they close without saving the page.

Just now I thought of searching for that code around and I got it from will bailey it toolbox thread. Download the code below. This is an example for jQuery implementation also.

iScripts

This is an area which I never worked before. This blog post by Jim gives you the best on iScripts. Go ahead and read the same.


Below screenshot gives you the difference between a regular URL and an iScript URL.




How do I create one?

--Create the PeopleCode in a Weblib

--Add Security for your IScript

--Create the link for your IScript


Create the PeoplCode in a Weblib

--Weblib’s are like Funclibs. They should be Derived Work Records. Usually a single field (Funclib) is enough.

--Place your code in the FieldFormula Event

--Each Iscript Function must begin with the string Iscript_ (i.e. Iscript_HellowWorld)


Add The Security

--Access to Weblibs is granted via Permission Lists

--Special Weblib tab on the Permission List tab

--Access is granular to the Iscript (Function) level


Create the Link

--Where am I accessing the weblib from?

--If from PeopleCode/Page use Button HyperLink type field of at least 254 length!

--Set as External Link, Dynamic URL

--Use deleivered functions to set field value. (i.e. GenerateScriptContentURL)

--Or you can use a Content Reference.


Few points worth to be noted:

--you can generate an IScript URL using the PeopleCode built-in function GenerateScriptContentURL.

--if you just want to view/print the component without the header and menu, then you can use the GenerateComponentContentURL function to create a URL to the component that does not include the portal markup. The GenerateComponentContentURL function creates a URL that matches the CREF's URL but uses the psc servlet rather than the psp servlet.


--"is this a psp or psc URL? I ask because this makes a difference in regards to the URL you see in the browser. If it is psp, then what you are seeing is the URL to your iScript plus the portal information. In this case, the actual URL to the content is in an iframe. If you use the psc URL, then you bypass the portal frameset and go direct to the content."


Anoop Savio

ANALYZE & compute statistics

%Execute(/) ANALYZE TABLE PS_CLASS_TBL compute statistics/ ANALYZE TABLE PS_CLASS_ATTRIBUTE compute statistics/ ANALYZE TABLE PS_CLASS_MTG_PAT compute statistics/ ANALYZE TABLE PS_CLASS_CHRSTC compute statistics/ ANALYZE TABLE PS_CLASS_COMPONENT compute statistics/ ANALYZE TABLE PS_CLASS_ASSOC compute statistics/ ANALYZE TABLE PS_CRSE_OFFER compute statistics/ ANALYZE TABLE PS_CU_CLAS_NBR_STG compute statistics/

I didnt get it first when I saw the above SQL. It had a clue that, its something realted to the performance tuning. Given a search, got the below info from the Stanford site.

ANALYZE
Purpose
--Use the ANALYZE statement to collect statistics, for example, to:
--Collect or delete statistics about an index or index partition, table or table partition, index-organized table, cluster, or scalar object attribute.
--Validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference (REF).

--Identify migrated and chained rows of a table or cluster.

More indepth info on the same.

Lokesh Madnavat