Tuesday, November 27, 2007

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


  • 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





  •   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.

Friday, November 23, 2007

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

Wednesday, November 21, 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.