Posts

Showing posts from June, 2016

PeopleSoft - PeopleTools Configurations Records or Meta Tables

PeopleSoft - PeopleTools Configurations Records or Meta Tables PeopleSoft records/metadata tables, often referred to as "meta tables," store information about various PeopleSoft objects and configurations.  1. Object Definition Tables: PSRECDEFN : Contains definitions of records (tables) used in the application, including details like record type and description. PSDBFIELD : Stores field definitions, detailing the attributes of each field such as data type and length. PSPNLGROUP : Holds information about components, which are collections of pages that function together. PSPNLDEFN : Contains definitions of pages (interfaces) within the application. PSMENUDEFN : Stores menu definitions, organizing how components are presented to users. 2. Security Tables: PSOPRDEFN : Maintains user profile information, including user IDs and associated roles. PSROLEDEFN : Defines roles that group together permissions for easier security management. PSCLASSDEFN : Holds permission li...

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 ...

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...