Peoplesoft Queries Solutions

Peoplesoft Peoplecode Message Catalog Message/Error finding query: Many of us see that some error message is coming in PeopleSoft online pages, and then we need to do the reverse engineering to get that exact code from where the error is coming. So that we can see the exact reason to find the best solution for the problem. Below query is designed to solve the same purpose. Copy and run the same... It will ask for Message Set and Message Number, which you can see from your error message. With Srch As ( Select MsgSet_HexCode, MsgNbr_HexCode,        Substr(MsgSet_HexCode, -2)|| SubStr(MsgSet_HexCode,1,2) MsgSet_HexSrch,        Substr(MsgNbr_HexCode, -2)|| SubStr(MsgNbr_HexCode,1,2) MsgNbr_HexSrch,        Nvl2(MsgSet_HexCode,'500000'||Substr(MsgSet_HexCode, -2)||                            SubStr(MsgSet_HexCode,1,2)||Lpad('3', 30, '0'),Null) ||   ...

How to know the navigation for a particular Oracle PeopleSoft Component or Oracle Peoplesoft Page For knowing the navigation of any page in peoplesoft. Just get the name of its component and place it in the query's last parameter (Component Name) and execute. Then follow the given navigation on PIA to access the Page. SELECT  DISTINCT 'Root > '||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL1_LBL)),'','',  A.PT_IQLEVEL1_LBL||' > ')||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL2_LBL )),'','',  A.PT_IQLEVEL2_LBL||' > ')||  DECODE(LTRIM(RTRIM(A.PT_IQLEVEL3_LBL)),'','',A .PT_IQLEVEL3_LBL||' >  ')||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL4_LBL)),'', '',A.PT_IQLEVEL4_LBL|| ' >  ')||  DECODE(LTRIM(RTRIM(A.PORTAL_LABEL)),'','',A.PO RTAL_LABEL||' >  ')||DECODE(LTRIM(RTRIM(B.PT_IQLEVEL1_LBL)),'', '',B.PT_IQLEVEL1_LBL||' > ')||  DECODE(LTRIM(RTRIM(B.PT_IQ...

Creating a new Application Engine definition Setting program properties Understanding program flow Inserting new sections, steps, and actions Loops/logic State records Adding programs to projects Creating a new Application Engine Definition Application Engine programs are definitions that are created and edited within Application Designer.  So, open Application Designer and log in.  Next, either use the File > New menu, press Ctrl + N, or click on the “New” icon on the toolbar. File > New / Ctrl + N: New icon on the toolbar: After you do that, you should get a New dialog.  There is where you tell Application Designer what type of new object you want to create.  From here, you will want to choose the “App Engine Program” object type. This should give you a new Application Engine program window: You probably want to save your program as you go.  You can use File > Save or Ctrl + S or the Save icon ...

Nodes: If you think about the e-mail analogy, the Node would be like the Domain part of the e-mail addresses. For PeopleSoft-to-PeopleSoft communication, Nodes are (usually) PSFT_EP for Financials, PSFT_HR for HRMS, PSFT_LM for LMS, and PSFT_CRM for CRM. They basically tell which application a message belongs to. The node definition is where you define what messages are valid for that node. Prior to PeopleTools 8.53, you’d define them on the “Transaction” tab. In 8.53 and above, you’d define them on the “Routings” tab. Since you might not want just anybody being able to publish a message to a node, you’ll need to set a node password on the first page of the node definition. This password will have to be the same in all of the environments. For example, if you want to publish a message to PSFT_EP from HRMS, the PSFT_EP node password will have to be the same in both Financials and HRMS. Messages: The message definition is where the developer specifies what data a message will contai...