Below is a tip that will allow you to view your project Peoplecode through your browser. Let’s assume that you exported your project to a file. There are two main project files created; an .XML file and a .INI file. 1. Place the following file named PeopleCodeViewer.xsl into your Project folder along with the project [...]

Step 1: if $prcs_oprid=” ! SECURITY CHECKING goto exit-pgm end-if Step 2: !SECURITY CHECKING STARTS HERE do Stdapi-Init if $prcs_oprid=” display ” display ‘REPORT CAN NOT BE EXECUTED OUTSIDE PIA,PLS USE PROCESS SCHEDULER.’ display ” goto exit-pgm1 end-if do Security-Param if $prcs_process_instance = ” !No Prompt else do Process-Get-Parameters-SRYHR027 ! Getting Run Control Parameters end-if [...]

Introduction: Peoplesoft Global Payroll is an innovative system which gives control over all aspects of payroll operation in a multinational environment. The main advantages of GP are. Specifies all business application logic in terms of Payroll Rules. Does not embed payroll-specific logic in application code. The two components of GP are Core Application. – Rules [...]

For initial developers of SQR, this is one of the topics which causes confusion that how an SQR program retrieves run control parameters and uses them and in this topic I will concentrate on this point. There are two methods of running an SQR which are: 1. Running through process scheduler: In this case SQR [...]

Problem: In our project we’ve encounter an issue regarding Text Catalog Language Translation. We’ve used SQL EXEC function to get Text Catalog value. This method will only work if customer is using only English Language. When Customer is using multi language in various countries then language translation will not work for Text Catalog Language Translation. [...]

SQR’s are already setup and defined as a Process Definition inside of your PeopleSoft application, so we will deal with how to launch an SQR. There are two ways of launching a program from within your PeopleCode programs. The first way is to make a system call to launch the SQRW.exe if you are on [...]

Sometimes a situation in project work arises to have a dynamic prompt table for record fields on PeopleSoft pages. In PeopleSoft itself dynamic prompt table functionality is utilized to a great extent. So, the question is: How to achieve the same?? We can accomplish dynamic prompt table in 2 ways: Using EDITTABLE fields for Prompt [...]

The following is a list of 9 habits of highly effective PeopleSoft developers, which promote successful migrations. 1. Always set your PeopleSoft Application Designer Tools Options to:             a. Insert object into project when modified and saved.             b. Prompt for related objects             The benefit of setting these Tools parameters is that the work [...]

You might have faced this issue with Message Catalog explanation text when we pass bind variables. This is PeopleSoft delivered issue with 8.44 tools version. I am not sure if this has been taken care in the latest releases. When we pass bind variables to Message Explanation Text, it is obvious to show repeated message, [...]

Sometimes we may need to develop Inline queries using PS Query Tool.  It’s difficult until we know how to do this. What is INLINE query? An inline query is a SELECT statement in the FROM-clause of another SELECT statement SELECT emplid , (SELECT deptid                    FROM dept_tbl)  AS “Department Id”   FROM emp  WHERE [...]