Posts

Showing posts with the label example

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

PeopleCode MessageBox function | Using PeopleCode MessageBox Features

-
A. The Basic Version The ‘MessageBox’ function is such a handy piece of code for troubleshooting that you often find yourself using the ‘basic version’ without giving much thought to how the statement really works: MessageBox(0, "", 0, 0, "Display message here"); This post will take a closer look at some of the additional features of ‘MessageBox’, beyond its basic usage above. In particular, we consider each of the parameters in more detail. B. Parameter 1: Message Type The first parameter specifies the type of message you wish to display. In most cases, the parameter is set to a value of ‘0’, which displays a message with an ‘OK’ button only. However, the function comes with a number of other options for setting the message type. These can be entered as either a numeric value (‘0’) or a constant (‘%MsgStyle_OK’): 0 – %MsgStyle_OK 1 – %MsgStyle_OKCancel 2 – %MsgStyle_AbortRetryIgnore 3 – %MsgStyle_YesNoCancel 4 – %MsgStyle_YesNo 5 – %MsgStyle_RetryCancel This means ...
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