Friday 28 December 2012

How to generate XMLP reports in PeopleSoft with desired file name?

In People Tools version 8.49 and earlier, XMLP generates reports with some random names. There is no delivered option for the user/developer to specify desired output report name. However, this can be achieved easily by tweaking the code in the Application Package - PSXP_RPTDEFNMANAGER, Class -ReportDefn, Method  - ProcessReport

Below is the code for the 'method ProcessReport' with the changes highlighted in red:                  
Ø  In the method declaration, add one additional parameter for setting up the report name as shown below:
 method ProcessReport(&TemplateID As string, &LanguageCd As string, &AsOfDate As date,     &OutputFormat As string, &sCustomRptName As string);

Ø  In the method definition, include the below shown code changes:
  method ProcessReport
CreateDirectory(&sOutputDir | &sDirSep | "RptInst" | &sDirSep | String(&i),     %FilePath_Absolute);
 /*This code is to generate the report with a custom name */
  If %This.UseBurstValueAsOutputFileName Then
          &sOutFileName = &sBurstValue | &sCustomRptName;
          &sOutFileName = &ID;
   &oReportOut = create XX_RPTDEFN:ReportOutput(&sBurstValue, String(&i),    &sOutFileName | "." | Lower(&sFileExt), &sBurstDataFile);       
  /*******Include report name here if you want to change******/
  If &sCustomRptName <> " " Then
        &ID = &sCustomRptName;
  &sLocalOutputFile = %This.GetLocalOutputFile(&ID | "." | Lower(&sFileExt), "", 1);

Below is the sample code to generate the XMLP report where 'method ProcessReport' is invoked with additional parameter:
&CustomRptName_prefix = "User Report";
 &ReportDef.ProcessReport(&sTemplateId, "ENG", %Date, &OutputFmt, &CustomRptName_prefix);
 &ReportDef.publish("", "", "", 0);

We implemented this at one of our customer site. It is tested and works fine. We recommend you to test it with various options.

In PeopleTools Version 8.50 and later, PeopleSoft has delivered the option to generate XMLP reports with customized names.
Navigation:  Main Menu > Report Tools>XML Publisher> Report Definition
File Name: Specify a file name template that gets translated at runtime to a physical file name. This field accepts a combination of output variables and plain text. Output variables are enclosed within percent signs (%). More details on PT8.50 report outpput option feature is available at

Saturday 22 December 2012

Kovaion Consulting Stepping Into 3rd Year

We began our journey on December 22, 2010 and have spent the past 2 years continuing to build our brand and improving in every area of our business. 

Year 2012 has been a fabulous year for Kovaion. Here is the quick summary of 2012:
Despite of the challenging global economy, we managed to improve steadily with added HR service offering division, 100% increase in revenue, 5 time increase in resource headcount, 2 new clients addition, 5 new partners and developed many new innovative products. We moved to new office premise with more space and enhanced infrastructure. We launched Kovaion Inception Lab and experts forum that mainly focuses on developing innovative products and value added services. We managed to achieve a lot in 2012 with contribution from everyone. Besides, we learnt a lot from the challenges we faced in 2012 and determined to do better.

“IT Metrics: IT Spending and Staffing Report, Jan 2012 by Gartner - In 2012, organizations will spend 63% of their IT resources to run the business, 21% to grow the business, and 16% to transform the business.”
We are investing more on inception lab primarily focused on pioneering People, Process & Technology to help our customers and partners in growing & transforming the business with effective IT solutions(esp ERP services).

We aim year 2013 as a business building year. Looking ahead to assist our customers and partners, we are focused on accelerating to build on the strength of our brand - 'innovation' and cost effective solutions. We have a good pipeline of projects and activities lined up for 2013. We are working under a grand vision of becoming an 'ERP Servicing Market Leader' by 2020. We are really excited about this journey and truly believe we will turn up our challenges to opportunities and meet them with determination and novelty. We wish to travel on this journey with your support.

We value the community where we work and live and we pledge to be a good corporate citizen. At Kovaion, we are committed to conduct our businesses in an environmentally responsible manner.

Finally I would like to thank all our esteemed clients, partners, associates and well wishers for the business and support. I hope to see continued support from all of the stakeholders to make 2013 as another successful year.

Wish you and your family a merry Christmas and a very Happy New Year.

Best Regards,
Nanda Kumar
Director - Kovaion Consulting