Here is some SQR code that will enable you to read a file. The code will also track # of records being read and will print out how many records have been rejected as well as total records read.
I have used Oracle CASE in one of my previous articles and this is an attempt to explain how it works.
CASE expressions let you use
ELSE logic in SQL statements without having to invoke procedures.
Here is a simple CASE example from Oracle documentation:
There have been times where I needed to document objects included in an Application Designer. The process could get very time consuming if you have a project with hundreds of PeopleSoft objects in it. PeopleSoft doesn't provide a "copy paste" type of approach to ease things, so I came up with my own!
The query below will return all the objects inside of an Application Designer project. You can then copy the rows and paste them where ever you'd like.
Here is an SQR code to close a file that has been opened for reading. Check my other article if you would like to see how to open a file for reading using SQR.
While back, I've created an SQL to find the exact same thing but with some level limitations. I have came across another query written by Jim's PeopleSopft Journal blog that works a little bit better and thought to share it with my visitors.
Jim's query however requires the developer to know the content reference of a component before the query could be used. What I really wanted is the ability to find the path by just knowing the component and not the content reference. Chances are, if you know the component reference you know the path to that component as well. So, to find the component path without knowing the content reference, follow the steps below:
1) Run the below SQL to get the content reference name for your component
Update: You might want to check my new post to find the path with no level limitations.
I had fun trying to figure this one out at work today. I wanted to
associate a link in PeopleSoft Portal to open an external URL (website)
in a new window and without the portal frame (template) around it. To
do so, follow the steps below:
Navigate to PeopleTools >
Portal > Structure and Content. Chose the folder you would like your
link to be in or you can add a new folder just for this new link if
Now scroll all the way to the bottom and click "Add Content Reference".
Here is a good sample of how to launch an SQR from within PeopleCode. You can use the peoplecode function called “ScheduleProcess”. Here is the example:
The PeopleCode below will show you how to call an Application Engine from PeopleCode. Some refer to this as “Real-Time Application Engine Processing.” For example, when a user save’s a page, you may want a specific App engine program to run. You can also execute this code in a field change event.
The following code calls the Application Engine program named YouAppEngProg, and passes it the necessary initialization values.
The select statement below is preformed by AP Voucher Build (AP_VCHRBLD) Application Engine to validate an AP Business Unit:
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|