Posts

Third-party integration in PeopleSoft

-
Third-party integration in PeopleSoft refers to the process of connecting PeopleSoft applications (like HR, Finance, or Supply Chain) with external systems or services, such as payroll vendors, banks, tax authorities, or custom web applications. PeopleSoft offers several built-in tools and technologies to facilitate this kind of integration, depending on the use case, data format, and real-time vs batch requirements. Here’s a breakdown of how third-party integration typically works in PeopleSoft: 🔧 Common Integration Methods 1. Integration Broker (IB) Purpose: Real-time or near real-time integrations using messages and services. Technologies Used: SOAP, REST, HTTP, XML, JSON. Components: Service operations (define messages and routing) Nodes (represent external systems) Queues (manage message delivery) Example: Sending employee data to a benefits provider in real time. 2. Component Interfaces (CI) Purpose: Provide programmatic access to PeopleSoft...
Post a Comment
Read more

Peoplesoft Peoplecode Message Catalog Error - Find Peoplecode where a message/error is used

-
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) ||   ...
Post a Comment
Read more

Peoplesoft Query - How to know the navigation for a particular oracle peoplesoft component or oracle peoplesoft page

-
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...
Post a Comment
Read more

PeopleSoft Application Engine Creation

-
Image
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 ...
Post a Comment
Read more

Building Blocks of Integration Broker

-
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...
Post a Comment
Read more