Skip to main content

Posts

Useful PeopleSoft SQL

 Over the years, I've accumulated some SQL that I use frequently. Here are some ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Find Portal Menu for Component SELECT A.PORTAL_URI_SEG1, A.PORTAL_URI_SEG2, A.PORTAL_URI_SEG3,RTRIM(E.PORTAL_LABEL)|| ' >> '  || RTRIM(D.PORTAL_LABEL) || ' >> ' || RTRIM(C.PORTAL_LABEL) || ' >> ' || RTRIM(B.PORTAL_LABEL) || ' >> ' || RTRIM(A.PORTAL_LABEL) FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE A.PORTAL_URI_SEG2 LIKE '%COMPONENT_NAME%' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Find permission ...
Recent posts

Simple PeopleSoft No Code SOAP Web Service

What is a Web Service Simply put a web service is  a method of communication between devices over the World Wide Web (WWW) Characteristics: Uses Request/Response messages over HTTP/S  Hypertext Transfer Protocol The foundation of data communication over WWW Used to send and receive webpages and files on the internet. Messages are text readable such as XML and JSON XML - Extensible Markup Language (rules for encoding documents that are both human and machine readable) JSON – JavaScript Object Notation (file format that uses human readable text)  What is SOAP Simple Object Access Protocol Lightweight protocol for exchanging structured information Use HTTP POST to send XML (Extended Markup Language)\ Provides both Asynchronous and Synchronous  Asynchronous – Doesn’t wait for a response; it is NOT immediate; callbacks happen only when the requested resource is ready Synchronous – Expects an immediate return of data; waits for a response SOAP Example - Web Service from a ...

Event Mapping Application Package

PeopleSoft has been increasingly adding new ways to modify it's software without intrusive customization. One was is Event Mapping. This allows code to be placed in a application package and change the behavior of pages. These "maps" are tied to components.  Here's a simple example.  1. Create a custom Application Package From Application Designer. Go to File -> New -> Application Package Save it and give it a name Right click on the package and select Insert App Class   Give the class a name Double click to enter PeopleCode Editor Create a class the extends PT_RCF:ServiceInterface An application class for event mapping must import and extend the PT_RCF:ServiceInterface class. In addition, it must define a single method named execute . In this example the class is named make_links_clickable import PT_RCF:*; class make_links_clickable extends PT_RCF:ServiceInterface    method execute(); end-class; Now create the method method execute    /+ Extends...

Application Package Application Class Coding

PeopleSoft is moving more and more to developing in application packages. Event Mapping uses application packages, REST services use application packages, Fluid pages use application packages, and work centers use application packages. So it is prudent that developers know how to code classes and methods. This blog is to help you get started. A Class An extensible program-code-template for creating objects. It's where you define initial values for state (member variables) and implementations of behavior (member methods).  Class Wikipedia It defines a set of properties and methods that are common to all objects of one type. It short, describes the contents of the objects that belong to it. Class simple English Wikipedia For example a class could be a mountain bicycle. It could have color fields, speed fields, break fields, tire fields, etc. A road bike could be related to the mountain bike class. A road bike would have similar fields to a mountain bike class but not exactly the same...

Scanning Barcode and QR Code with JavaScript in PeopleSoft

Creating a mobile app with JavaScript is simple and common. Simply find a JavaScript Library and write the code to use it. But how do we do that with PeopleSoft This Blog will give you an example. 1st we need JavaScript Library to Scan both QR and Barcode InstaScan (only did BarCode) https://github.com/schmich/instascan Zxing (did both)  https://github.com/zxing-js/ Great libraries exist, but how do we get that into PeopleSoft? We'll need to add video/camera to Mobile Inventory Pages.  Can this be added? Will the page be able to access the camera? The answer is in PeopleSoft PeopleTools Tips & Techniques by Jim Marion Chapter 6 JavaScript for the PeopleSoft Developer JavaScript Libraries, pages 240-241 IScript/Messages Step 1 Get mimified version of Zxing https://unpkg.com/@zxing/library@0.14.2/umd/index.min.js PeopleTools -> Utilities-> Administration-Message Catalog Add Minified Code to Description Yes, you are correctly seeing that. Store the code in the message c...

PeopleSoft REST services

PeopleSoft Rest Service     Here is a step by step example of how to create a REST service in PeopleSoft.  The first example passes one row of data via the URL. The response includes multiple po lines.  The second example passes JSON in the body with no parameters in the URL. The response is one row per row in the request.   1)     Create template document for inbound parameter(s) (the request). 1)     One or more element names. 2)     Create a view record of the outbound data (the response). 3)     Create template document. 1)     Element names, Collections and Compounds. 2)     Map the document elements to fields in your view 4)     Link messages to document 5)     Create your response message which structures ...