Fluid HCM Guided Self Service Video Feature Overview

The PeopleSoft Fluid HCM Guided Self Service video is now available for viewing, here: https://www.youtube.com/watch?v=ywR_twtWxUw

PeopleSoft Fluid HCM Guided Self Service enables your Managers to perform daily HR tasks in a much smarter and efficient way. Your Managers can initiate an employee promotion or location change, using a desktop, laptop or smartphone.

Fluid Candidate Gateway Video Feature Overview

You can now see the Fluid Candidate Gateway VFO on the PeopleSoft Channel: https://youtu.be/uhf6rmF-Lk8

PeopleSoft’s Fluid technology enables the Candidate Gateway pages to render differently on a variety of devices. Unlike many mobile apps, there is nothing for the candidate to download. Your candidates can search for jobs from a mobile phone, mark a job as a Favorite, and return later - on a different device - to complete the application, using the same URL.

How to get a beginning date and ending date of fiscal year with a current date

Here is a simple peoplecode to get a beginning and ending date of fiscal year with a current date

  
   Local string &sCurrYear = String(Year(%Date));
   Local date &dtLastDay = DateValue("06/30/" | &sCurrYear );
   Local date &dtAsOfDate = DateValue(DateTimeToLocalizedString(%Datetime, "MM/dd/") | &sCurrYear); /* You can use %Date instead */
   Local date dtFirstDay;
   
   If &dtAsOfDate < &dtLastDay Then
      &dtFirstDay = DateValue("7/1/" | String(Value(&sCurrYear) - 1));
      &dtLastDay = DateValue("06/30/" | &sCurrYear); /* for easy to read */
   Else
      &dtFirstDay = DateValue("7/1/" | &sCurrYear);
      &dtLastDay = DateValue("06/30/" | String(Value(&sCurrYear) + 1));
   End-If;

PeopleSoft CS 9.2.001 Is Available

Oracle/PeopleSoft Campus Solutions Announcements

April 4, 2016

PeopleSoft CS 9.0 to 9.2 – PeopleTools 8.55 Upgrade

The CS 9.2 Upgrade for PeopleTools 8.55 is available via My Oracle Support, PeopleSoft Campus Solutions Upgrade Home Page (Doc ID 2078564.2).  This MOS site contains documentation and an important video for performing the CS 9.2/PT 8.55 upgrade.  A reminder:  the process of obtaining  the upgrade template has changed with PeopleTools 8.55 so we encourage you to review Getting Started on Your PeopleSoft Upgrade (with PeopleTools 8.55) available on the MOS site Getting Started on Your PeopleSoft Upgrade (using Change Assistant) (Doc ID 739129.1).

PeopleSoft CS 9.2 PUM Update Image 1

The CS 9.2 PUM Update Image 1 is now available from the PeopleSoft Update Manager (PUM) Home Page (Doc ID 1641843.2) by selecting the Update Image Home Pages tab, choosing Campus Solutions Update Image Home Page and expanding the section CS Update Image Link.  The PeopleSoft Campus Solutions 9.2 Documentation Home Page (Doc ID 2013381.1) section on CS 9.2 Release Documentation contains links to the PeopleSoft CS 9.2 Update Image Overview (Doc ID 2116071.1), the PeopleSoft Campus Solutions Cumulative Feature Overview tool, and CS 9.2 Online Help.

How To Get milliseconds Displayed in DateTime Via PeopleCode

In most cases, milliseconds may not matter in your coding, but in few cases, it could make a big difference.

As you know, when you are using %DateTime or %Time, the milliseconds shows .000000, so frustrating...

There are few ways you can do to remedy this issue, some use SQL to get a current_timestamp, some use a java class to get a server time, etc.

Here is one for peoplecode:

Local datetime &NewDateTime = DateTimeValue(Substring(String(%Datetime), 1, Len(String(%Datetime)) - 6) | Substring(String(%PerfTime), Len(String(%PerfTime)) - 5, Len(String(%PerfTime))));

Hope this helps and Happy Coding!

Dynamic Position Title from Jobcode vs Position Data

On a several different occasion, I was asked how we dynamically derive a position title from the position data table when the position number exists in the job data instead of from jobcode table.

So, I wrote this SQL to return emplID, empl record, and dynamic position title (derived from jobcode vs position data).

You can also make this SQL as record view and you can call it using peoplecode to return a dynamic position title you desire.

For this example, I am querying emplID: KU0010.

Note: replace {less than sign} with <
For some reasons, it keeps translating and displaying it to < (If anyone has suggestion to fix the dispay, please let me know.  I just don't have time to research it right now)

Additionally, I am running this in Oracle database, so sysdate will work just fine.  If you are using MSSQL database, you know what to do.

SELECT job.emplid 
 , job.empl_rcd 
 , CASE pos.descr WHEN '' THEN jobcd.descr ELSE pos.descr END 
  FROM ps_job job LEFT JOIN ( 
 SELECT J1.setid 
 , J1.jobcode 
 , J1.Descr 
  FROM ps_jobcode_tbl J1 
 WHERE J1.effdt = ( 
 SELECT MAX(effdt) 
  FROM ps_jobcode_tbl 
 WHERE setid = J1.setid 
   AND jobcode = J1.jobcode 
   AND effdt {less than sign}= SYSDATE)) jobcd ON jobcd.setid = job.setid_jobcode 
   AND jobcd.jobcode = job.jobcode LEFT JOIN ( 
 SELECT P1.position_nbr 
 , P1.descr 
  FROM ps_position_data P1 
 WHERE P1.effdt = ( 
 SELECT MAX(effdt) 
  FROM ps_position_data 
 WHERE position_nbr = P1.position_nbr 
   AND effdt {less than sign}= SYSDATE)) pos ON pos.position_nbr = job.position_nbr 
 WHERE job.effdt = ( 
 SELECT MAX(effdt) 
  FROM ps_job 
 WHERE emplid = job.emplid 
   AND empl_rcd = job.empl_rcd 
   AND effdt {less than sign}= SYSDATE) 
   AND job.effseq = ( 
 SELECT MAX(effseq) 
  FROM ps_job 
 WHERE emplid = job.emplid 
   AND empl_rcd = job.empl_rcd 
   AND effdt = job.effdt)
 AND job.emplid like 'KU0010';

How to add ROWNUM in a Record View

Let's say that I have a table called Y_DISCUSSION with 6 existing columns.  Now, I want to add the 7th column that contains row number.  How do I do that?

It's pretty easy actually...

• 1 - Create a Record View with 7 columns, the last column will be used as a row number.
  
  
  
  
  
  
  
  
  
  
  
  
• 2 - Write the SQL Definition in this format below
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
• 3 - Save and build the view
• 4 - Run the view and get the result below
  
  

Now I have the rownum in the table, I can use the rownum in my selection criteria, such as rownum between 5 and 10.