Alternative to SendMail Function : PT_MCF_MAIL

You can use Application package PT_MCF_MAIL (PeopleTools 8.46 or higher only) to generate emails instead of using SendMail peoplecode function.

Go to the PeopleBooks to get the complete description.

Home > PeopleBooks > Enterprise PeopleTools 8.48 PeopleBook: PeopleCode API Reference > Mail Classes

Go to Mail Classed Example section to see How to use these classes. Following examples are provided.

• Creating Text Email
• Creating Email and Overriding SMTP Settings
• Creating HTML Email
• Creating Multi-Part Email With Both Text and HTML Parts
• Creating HTML Email with Images
• Creating Email with Attachments
• Creating Email Attachments Specifying a URL
• Creating Multiple Emails
• Authenticating Email While Sending

Advantages

• Structured Code
• Can generate HTML Email
• Can override Default SMTP Parameters
• Better Error Handling
• Send emails  return receipt request (email reception notification)
• Ability to set Message priority

 

Reference

• Rich emails using SendMail()

 

Issues

•   You might not be able to use GetHTMLText in Application Engine program run using process scheduler or in 2 tier mode, as this function does not support bind variables in 2 tier mode. PeopleBooks list the following constraints for this function.
  
  Restrictions on Use

Use this function with the PeopleSoft Pure Internet Architecture. If run from a 2 tier environment, the parameter substitution does not take place.

Oracle Openworld 2007 PeopleSoft Conference Sessions

You can download pdf file of the conference presentations for PeopleSoft at the following link.

PeopleSoft Sessions - Oracle Openworld 2007

Microsoft Oracle and PeopleSoft White papers

This site provides the white papers specifically targeting Oracle PeopleSoft Enterprise Customers using Microsoft technologies for e.g. Share Point server, SQL Server. It also offers tips and techniques and provided a step by step instruction for integrating share point portal with PeopleSoft using web services.

Microsoft - Oracle - PeopleSoft white papers

Following are some of the interesting white papers that customers can take advantage of.

• Connecting Microsoft Office InfoPath 2003 to PeopleSoft
• Connecting PeopleSoft and Microsoft Excel using the Information Bridge Framework
• Integrating Microsoft Office SharePoint Portal Server 2007 with PeopleSoft Enterprise Applications
• Peoplesoft Performance Tuning on Microsoft SQL Server
• PeopleSoft Red Paper: Microsoft SQL Server Tuning Tips for PeopleSoft 8.x
• Connecting to PeopleSoft Web Services with Microsoft Visual Studio .NET
• Connecting Microsoft Office InfoPath 2003 to Peoplesoft

 

You may also want to look at following Oracle Open World 2007 Session PDF file.

Integrating PeopleSoft Applications with Microsoft Oracle. (Steve Fox from Microsoft presented the session).

He demonstrated how to use Microsoft Visual studio 2008 Office programming to connect outlook with PeopleSoft back end data. Demo showed a form in outlook that displayed recruitment information from PeopleSoft in outlook.

Determine Languages installed for your PeopleSoft Application.

You can use this SQL to find out which languages are already installed for your installation.

select * from PSLANGUAGES where installed = 1

Find if the current user has been assigned the named role

You can use this in your peoplecode to determine if the current logged in user has role assigned to him.

&IND = %Roles.Find("MYROLENAME");

IF &IND <> 0 Then

     /* User has this Role */

or 

   /* User does not have this Role */

end-if

You can also use the peoplecode function IsUserInRole("ROLENAME") to find the same.

Export to PDF Fix for Crystal Report 8.5

If you try to run Export to PDF from Crystal Report 8.5 Report designer, it does not work. To resolve this, download this hot fix from businessobject web site and install it. Click here to get list of all downloads available for 8.5

Crystal Report Tip: Know the height and width of a object

In Crystal Report, you can right click on any field or object and select Object Size and Position.

This can help you align two objects horizontally or vertically using same x and y coordinate and also allow you to set the same height and width. Very useful, when you need to delete one field and add another from different source. Just note down the all the values before deleting and set the values after adding the new object.