Posts

Showing posts from May, 2017

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

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