PeopleSoftCodeSharingOverview

PeopleSoftCodeSharingOverview  : https://www.youtube.com/watch?v=hfFgxY5FHeI

This is an overview of the PeopleSoft Sample code sharing site at http://peoplesoft-samples.java.net

Convert Tab file to CSV and Load - From PeopleSoft Blog

If you got a tab limited file and want to read it as a CSV file, using the file layout, use the below code snippet.

Local File &TABFILE, &CSVFILE;
Local string &FILE_NAME, &DATA, &NEWDATA;

&FILE_NAME = "Test.txt";
&TAB = Char(9);

&TABFILE = GetFile(&FILE_NAME, "r");
&FileName = &TABFILE.Name;
&POS = Find(".", &FileName);
&NEWFILE_NAME = Substring(&FileName, 1, &POS) | "dat";
&CSVFILE = GetFile(&NEWFILE_NAME, "N", %FilePath_Absolute);
If &TABFILE.IsOpen And
&CSVFILE.IsOpen Then
While &TABFILE.ReadLine(&DATA);
&NEWDATA = Substitute(&DATA, &TAB, ",");
&CSVFILE.WriteLine(&NEWDATA);
End-While;
&TABFILE.Close();
&CSVFILE.Close();
End-If;

Will be handy...

Oracle PeopleSoft Publishes User Experience Guidelines

Those who are highly interested in US principles of PeopleSoft, refer the below link. Very interesting...

https://blogs.oracle.com/peopletools/entry/oracle_peoplesoft_published_user_experience

PeopleSoft In-Memory Project Discovery

The PeopleSoft Blog | Stay Updated: PeopleSoft In-Memory Project Discovery : PeopleSoft In-Memory Project Discovery

PeopleSoft 9 2 HTML Email Approvals

The PeopleSoft Blog | Stay Updated: PeopleSoft 9 2 HTML Email Approvals: PeopleSoft 9 2 HTML Email Approvals

PeopleSoft Update Manager - Posted by Oracle blogs

Oracle and the PeopleSoft team have changed the way all maintenance and functionality is being delivered starting in PeopleSoft 9.2  using the new PeopleSoft Update Manager (PUM).
PUM transforms the way customers manage their PeopleSoft applications.  Customers have the ability to determine what maintenance to apply, when to apply it, and at any point can create a single change package to get current.  The cost savings and strategic benefits this enables are significant.
While PUM delivers transformative value to customers and feedback from customers has been very positive, it represents a change in approach from how PeopleSoft has historically delivered maintenance.  To avoid disruptive impact to upgrade and implementation plans, it is critical to understand and plan for the hardware, software, and procedural change that PUM represents.
If you are planning or executing a PeopleSoft 9.2 upgrade or implementation, it is important that you include PUM in your plans.  Use the following resources:

1. The PUM Home Page.  Single site that contains all PUM related content, training, and image schedules, as well as links to all information mentioned below.
2. PUM Video Feature Overview:  If you don’t know what PUM is, start here. 
3. PUM Hardware and Software Requirements: See the Quick Start Guide (#9) and Using VirtualBox Images (#10) on the PUM Home Page.   These two documents outline the hardware and software requirements for PUM. 
4. PUM Instructions and Best Practices: See all other documents and trainings on the PUM Home Page.

There are many additional documents available that provide training and detailed install and usage instructions.  We strongly recommend reviewing the PUM Best Practices and Maintenance Strategy document (#6) for guidance on the procedural implications of PUM.

Paycheck Printing – Dynamic Signature Using Word 2007 Oracle BI Plugin - Posted by PeopleSoft.in

Pay003.sqr Modifications

Pay003.sqr creates an XML file which is processed by App engine to Fill up values in to Specific RTF template and Produce paychecks. Pay003.sqr should be customised to retrieve / set Signature URL as per business logic and should be assigned to a variable say SIGNATURE_URL.

Pay003.sqr should process this Variable as XML tag, Following Code will Process this as an XML Tag,

$signature_url = ‘c:\temp\signature.gif’

let $xmltag = ‘SIGNATURE_URL’

let $xmlcontent = $Signature_URL

do Process-SSP-XML-Tag-Content

Remember this code should be added Under Procedure Get-Paychecks so every Paycheck have an XML Tag,

<SIGNATURE_URL>c:\temp\signature.gif</SIGNATURE_URL>

Now Pay003.sqr is ready to send a URL of signature to Template. No Schema Modification is required for this XML tag in Peoplesoft 9.1 as schema is created runtime automatically.

RTF Template Modification: After Modification of Pay003 all you have to do is Update RTF template for Required Report Definitions.

Generally PRTCACHK report definition used for Paycheck Printing which is compatable of TAX11c Update and Prints Paychecks as per legal requirments of NY and CA (New York and California) .

Current Reoprt Definition can be verified / Tested from Navigation Set Up HRMS -> Product Related -> Payroll for North America -> Payroll Processing Controls -> Paycheck Options Table.

First we need to download delievered Template from navigation Main Menu -> Reporting Tools -> XML Publisher -> Report Definition and from the same navigation corresponding updated templates needs to be uploaded.

To Modify Template first Install Oracle BI Plugin in System, which enables a Add In tab in Micrsoft Office Menu Bar.

Open Template with Microsoft word and double click on signature image, under Format tab click on arrow to open picture properties as shown in figure,

Paycheck Template Modification

Properties window should open, Update XML Tag name here and save.

Modifying Properties of Signature Image

And You are done. Upload this template and Run PYCHKUSA process job and check signature should appear as per URL passed runtime.