Posts

Showing posts from 2015

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 to print a BI Publisher report on the click of a push button

-
Here, I am sharing peoplecode which is to be used for printing report using a push button from the page. All you need to do is to give the following constraints like- &MyReportName="Name from Report Definition in PIA" &MyTemplate="Template name from Report definition/template tab "  e.g., REPORT_NAME_1 and query prompts to filter the data in the report- &rcdQryPrompts e.g.,&rcdQryPrompts.PO_DT.Value = PO_HDR.PO_DT.Value; --------------------------------------------------------------------------------------------------------------------- import PSXP_RPTDEFNMANAGER:*; &LanguageCd = "ENG"; &AsOfDate = %Date; &OutFormat = "PDF"; &MyReportName = "REPORT_NAME"; &MyTemplate = "REPORT_TEMPLATE_NAME"; Local PSXP_RPTDEFNMANAGER:ReportDefn &oReportDefn = create PSXP_RPTDEFNMANAGER:ReportDefn(&MyReportName); &oReportDefn.Get(); Local Record &rcdQryPrompts...
6 comments
Read more