Categories
PeopleCode XML Publisher

Create a Report Using XML Publisher – PeopleSoft

To create a PS Query Based XML Publisher Report we have to do the below steps:

Create a PS Query:

Navigation : Reporting Tool > Query > Query Manager.

PS-Query1

 

 

 

 

 

 

 

 

 

PS-Query2

 

 

 

 

 

Create Data Source:

Navigation: Reporting Tools > XML Publisher > Data Source.

Choose Data Source type as PS-Query and choose Data Source ID from the prompt.

datasource_1

 

 

 

 

 

 

datasource_2

 

 

 

 

 

 

 

 

 

 

Generate XML and XSD files, and save the page.

Create RTF Template:

  • Download the XML file from the newly created data source.
  • Open Microsoft Word, go to Add-Ins > Data > Load XML Data.

word1

 

 

 

 

Go to Add-Ins > Insert > Table Wizard . Perform the below steps.

word2

 

 

 

 

 

 

word3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

word4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click Finish. Below is the template snap.

rtf_temp

 

 

 

 

Create Report Definition:

Navigation: Reporting Tools > XML Publisher > Report Definition. Perform the following steps.

rpt_defn1

 

 

 

 

 

 

 

 

rpt_defn2

 

 

 

 

 

 

rpt_defn3

 

 

 

 

 

 

 

Create Component, Page, Menu:

Create Page, Component, Menu and Register it from Online.

page1

 

 

 

 

 

 

comp1

 

 

 

menu

 

 

 

 

 

Write PeopleCode to Component Record field Field Change event.

pc

 

 

 

 

 

/*===================================
Description:
———————————————————-
Sample XML Publisher Report Where DataSource is a PS-Query.
=====================================*/

import PSXP_RPTDEFNMANAGER:*;

Local string &reportDefnId;
Local string &languageCode, &outputFormat, &templateName, &reportName;
Local date &AsOfDate;

&reportDefnId = “UD_XMLP_DMO1”;
&languageCode = “ENG”;
&outputFormat = “PDF”;
&reportName = “UD_XMLP_DMO1”;
&templateName = “UD_XMLP_DMO1_1”;
&AsOfDate = %Date;

/* Initializing Report Def class Object */
Local PSXP_RPTDEFNMANAGER:ReportDefn &rptDefn = create PSXP_RPTDEFNMANAGER:ReportDefn(&reportDefnId);
&rptDefn.Get();
&rptDefn.ProcessReport(&templateName, &languageCode, &AsOfDate, &outputFormat);
CommitWork();
&rptDefn.DisplayOutput();

Run The Report:

r1

 

 

 

 

 

 

R2

 

 

 

 

 

 

R3

 

 

 

 

 

 

 

 

 

Thanks

Milan Bhattacharjee

Categories
PeopleSoft Customization

New Feature & Guide Line to Create Smart HR Template , PS 9.2

What is PeopleSoft – 9.2 Smart HR Template?

Smart HR templates are a simplified and streamlined approach to completing various transaction processes, such as hiring, updating a person’s personal or job data, or managing a person’s profile data.

New feature of Smart HR template in PS-9.2

Prior PeopleSoft 9.2 by using template based hire (Smart HR Template) end users can hire an employee but PeopleSoft 9.2 introduced some new functionality, by using it end users can hire, rehire, change an employee’s Job & personal data information or change an employee’s profile information.

Below is the new components introduced in PeopleSoft-9.2 (marked in bold).

Components in PeopleSoft – 9.1

  • Create Template Record/Field
  • Template Section
  • Template Creation
  • Copy Template
  • Template Category Table

Components in PeopleSoft – 9.2

  • Create Template Record/Field
  • Template Section
  • Template Transaction Type
  • Template Creation
  • Copy Template
  • Template Category Table
  • Copy Template Transaction Type

1

 

 

 

 

 

 

 

 

What is Template Transaction Type?

PeopleSoft – 9.2 introduced Template Transaction Type to enhance the Smart HR functionality. Use this component to define transaction type (Hire/Rehire, Change Job Data, Change Personal Data etc) for the Smart HR Template. Apart from the delivered transaction type we can create our own custom transaction type.

The Delivered Transaction Types are:
HIRE: Hire/Rehire.
HIREJPM: Hire/Rehire and Profile Data.
HIREUSF: U. S. Federal Hire/Rehire.
JOB: Change Job Data.
JOBJPM: Change Job and Profile Data.
JPM: Change Profile Data.
PERSJOBJPM: Change Personal, Job and Profile Data.
PERSON: Change Personal Data.
PERSONJOB: Change Personal and Job Data.
PERSONJPM: Change Personal and Profile Data.

Steps to Create Smart HR Template:

1A

 

 

 

 

 

 

 

Step-by-Step Guide Line to Create a Smart HR Template

In this example we will create a Smart HR Template; by using it End User (HR) can update employee’s Job Information (Department ID, Location, or Job Code)

Step-1 Create or Use Template Record/Field

In this example we will not create any new Template Record / Field. We will create delivered records NAMES_01 and JOB. We can also add Record Alias into these existing records.

3

 

 

 

 

 

 

 

 

 

Note: Using name of the Record Alias Smart HR will identify the original record.

Step-2 Create or Use Template Section

In this example we will create two new template sections one for employee’s name and other for Employee’s Job Information.

Template Section for Employee’s Name:

4

 

 

 

 

 

 

 

 

Note: Select Name for section type as this section is for employee’s name, and select section type value. We can also use delivered section validation app class to validate the values given by end user.

Template Section for Employee’s Job Information:

5

 

 

 

 

 

 

 

 

 

 

Delivered Section for Job – Compensation:

6

 

 

 

 

 

 

 

Step-3 Add Template Section(s) to Template Transaction Type:

As we will change the employee’s job information using this template, so we will choose “Change Job Data” transaction type.

7

 

 

 

 

 

 

 

 

Step-4 Create a Template:

9

 

 

 

 

 

10

 

 

 

 

 

 

 

 

 

 

Note:
Choose Transaction Type = Change Job Data
Checked all check boxes under general options group box.
Configure fields under Search Page Configuration Tab similar to the above snap.

 

 

 

 

 

 

 

Add the number of pages you want and give a Page Title.

12

 

 

 

 

 

 

 

Add the custom sections which we have created earlier. Select section type Tabular and choose a page number. It indicating which section belongs in which page.

13

 

 

 

 

 

 

Select Search Parameter and Search Result Code. Finally save the component.

After Creating a Template How to Use It?

Open Smart HR Transaction Component using the following navigation.

Main Menu > Workforce Administration > Smart HR Template > Smart HR Transactions

14

 

 

 

 

 

After choosing template type and create template values , click Create Template Button.

15

 

 

 

 

 

 

 

Put and EMPLID, Effective Date & Reason Code similar to the above snap and click Continue button.

16

 

 

 

 

 

 

 

 

 

Give the new Department ID along with the other required field data. Click “Save & Submit” button.

17

 

 

 

 

 

System retrieved the above person’s informations as we have enabled the Search/Match functionality when we have created the template. Click Select button for the Employee which we have given.

18

 

 

 

 

Before Transaction:

19

 

 

 

 

 

 

 

After Transaction:

20