While browsing through various sites to find some information on IB, I found the following executable.
It is a nice tutorial on how to do basic setup for Integration Broker.
Just open the following link , save the exe and run it.
The PeopleSoft Internet Architecture (PIA) is a server-centric component architecture that enables secure end user access to PeopleSoft applications. Its components include the following:
• Internet Access Device
• Web Server
• Application Server
• Database Server
Each component fulfills a unique niche within the system, all of which are described in the PeopleSoft Internet Architecture Components lesson of this course.
Process scheduler status is stored as numeric values behind the RUNSTATUS field. So, here are the values corresponding to each value.
FIELDVALUE XLATSHORTNAME ---------- ------------- 1 Cancel 2 Delete 3 Error 4 Hold 5 Queued 6 Initiated 7 Processing 8 Cancelled 9 Success 10 No Success 11 Posted 12 Not Posted 13 Resend 14 Posting 15 Generated 16 Pending
I thought this might be handy tool to use. I had created for my use. I thought someone else might need it too.
This tools pickups any file and spits out "formatted" SQL (tables that begin with PS_ only) from it. I use it to run through my trace files and pick up the sql.
There are better tools out there, but this one is FREE! Cant beat that ah! I hope to make improvements as time permits. Feel free to pass it on.
In this post I will attempt to explain how to dynamically assign a prompt table depending on a drop down value (see image below)
The table behind the grid is PORTAL_SECDYVW and as you can see from the image below, the PORTAL_AUTHNAME field has %EDITTABLE defined as a prompt table. The PORTAL_AUTHNAME is the "Name" column you see on the grid.
A very simple yet very useful code to give users the option to delete all grid rows on a page at once. I've implemented such a requirement by placing a "Delete all" button above a grid to give PeopleSoft users the option to delete all rows at once instead of clicking the "-" grid button. If the gird has, lets say, 20 rows, then a user will have to click the "-" delete grid button 20 times to delete all rows, compared to one click on the "Delete all" button.
Place the code below behind a field change event.
A straight forward SQL to get edit tables behind field(s) for a specific record. The SQL execludes any edit tables that start with "%" as those are dynamic edit tables with values populated by PeopleCode at run time and thus will not be of a good use in this query.
SELECT R.FIELDNAME , R.EDITTABLE FROM PSRECFIELDDB R , PSDBFIELD F WHERE R.RECNAME = :RecordName AND SUBSTR(R.EDITTABLE,1,1) <> '%' AND R.EDITTABLE <> ' ' AND R.FIELDNAME = F.FIELDNAME AND F.FLDNOTUSED = 0;
A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page. Example, Add Update/Display and so forth.
If you use APP ENGINE to report the data from the temp table /staging table on to CSV file using excel format, there is a known issue with fields that have leading zeros. For ex:You have a field of length 6 characters. If the field value is 002123, the excel file removes the leading zeros. But if the requirement is to preserve those leading zeros, we can do something like this.
Update the temp table right before you write out into a file.
|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|