Contact Us

 Email me at: shaanksingh90@gmail.com

Comments

Post a Comment

Popular posts from this blog

PeopleSoft Meta Tables

Application Engine Meta Data PSAEAPPLDEFN AE header record; 1 row per app engine PSAEAPPLSTATE AE state records (shows which one is the default) PSAEAPPLTEMPTBL AE temp tables assigned PSAESECTDEFN AE sections: public or private PSAESECTDTLDEFN AE section: descriptions, market, DB Type, EFFDT, EFF_STATUS, and auto commit PSAESTEPDEFN AE steps within section: description, market, DB Type, EFFDT, EFF_STATUS PSAESTMTDEFN AE actions within AE step: Step type (SQL, Do Select, etc.) with SQLID. PSAESTEPMSGDEFN AE message (parameters in each step) AEREQUESTPARM AE request parameters table behind the AE run control page. Find All Records Referenced in App Engine 1. Find the Temp Records (TAO) that are used: SELECT RECNAME FROM PSAEAPPLTEMPTBL WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME' 2. If there are records, find the number of instances: SELECT TEMPTBLINSTANCES FROM PSAEAPPLDEFN WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME...
Read more

Fluid Attachment in newer PeopleSoft versions (9.2+ using Tools 8.55+)

  In newer PeopleSoft versions (9.2+ using Tools 8.55+), the Fluid Attachments Framework has been significantly enhanced for easier configuration and mobile-friendly use. Here’s a full overview tailored to the latest version: 🧩 1. Core Framework Pages & Setup In the latest Fluid-compatible releases, configuration is done entirely through delivered setup pages (no custom code needed unless advanced): Define Authorization ( HR_ATT_AUTH ): Create attachment authorization IDs to control access. Define Authorization Entries ( HR_ATT_AUTH_ENT ): Map attachment IDs to roles and access levels. Define Attachments Configuration ( HR_ATT_CNFG ): Specify available document types, URL links, notes, and attachments for each configuration ID. Configure Keys – Header/Store ( HR_ATT_KEYS_HDR / _S / _C ): Set which record fields act as context keys that group attachments by transaction (e.g. employee ID, transaction number). Maintain Definitions ( HR_ATT_DEFN ): Manage con...
Read more

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