Tuesday 2 December 2014

Peoplesoft Outlook Integration

What is Outlook Integration?
Outlook Integration enables integration between PeopleSoft and Microsoft Outlook to schedule meetings and appointments. It makes things easy for organizations predominantly engaged with MS Outlook to schedule meetings driven by PeopleSoft data.
Utility Benefit:
·         Keeps communications and schedules in an organised way.
·         Simple and easy to configure & maintain.
·         Increases the productivity by tightly coupling PeopleSoft data and Outlook schedule.
·         Fast, effective and two-way integration keeps processes simple and reduces duplication
Sample Business Scenarios:
·         In Talent Acquisition Manager (TAM) manage interview schedules, interview directly in MS Outlook with updates applied on candidate records. Quickly link emails, schedules interview and adds attachments to candidates
·         MS Outlook can be integrated with PeopleSoft HR Notification to schedule meetings.
·         Absence takes can be requested by entering absence requests through Microsoft Outlook.
Implementation Steps for outlook plug in:
·         Install the PeopleSoft Outlook Plug in
·         Configure outlook menu in PeopleSoft settings and option add on menu. (Refer fig 1 for configuration details)
·         Make Setups based on each module (TAM, Absence Management, ePerformance etc.)
Prerequisites for PeopleSoft outlook Plugin:
To enable the communication and interaction between Microsoft Outlook and the PeopleSoft system, following are required:
·        The Microsoft Add-In—Represented in the PeopleSoft Outlook menu and handles all of the communication and information within Microsoft Outlook.
·        The PeopleSoft Outlook URL Handler—An external Windows application that allows you to drill into Microsoft Outlook directly from the PeopleSoft system.
How to get the PeopleSoft Outlook Plug-in?
The plug-in can be found as compressed files in the PeopleSoft path: "<<PeopleSoft Installation HomeDirectory>>\src\DesktopIntegration". Users can extract the various integration objects (Outlook Add-In, Outlook URL Handler or Word Add-In) and install.

PeopleSoft Outlook Menu:

After installing the PeopleSoft Outlook plug-in, user can see in the outlook, a new menu option PeopleSoft as shown in below screen.



Configuration: User can define the integration options with PeopleSoft and the other required setups like server details, User ID, Email Account, etc.



Based on the features selected, the relevant appointments, tasks, scheduling etc. will be possible from outlook. All the features that can be used from PeopleSoft to Outlook are covered under Enterprise components-Desktop Integration

}  Task- A task is a way for something to be queued up and put into the user’s tasks.
}  Task Queue- You can use the queue to manually add tasks to a user's Microsoft Outlook task list.
}  Appointment- Define the defaults for the user's appointments, invitations, and calendar.
}  Appointment Queue- To review the appointment queue, monitors integration transactions, or manually adds/updates meetings and appointments.
}  File Transfer- Set up file transfer registration.
}  File Transfer Queue- To review what you previously defined as defaults in your file transfers.
}  Address Book- To Register your address book.
}  Dynamic Displays- Dynamic Displays allow the display of information from your PeopleSoft system alongside items in Microsoft Office. You can use Dynamic Displays to show any information contained within the PeopleSoft system and those displays can optionally be shown automatically alongside the Microsoft Office items.

PeopleSoft and Outlook Integration Solutions

Out of Box integrations
   Out of the box, Oracle-PeopleSoft calendar integrations are available for modules like Absence      Management, ePerformance, Talent Acquisition Manager.
Let’s look at the calendar Integration with TAM.

Calendar integration with TAM: PeopleSoft delivered the setup for integrating TAM with    outlook. Three options are provided to user: Full Integration, Partial Integration and No   Integration.
Navigation: Setup HCM > Install>Product Specific>Recruiting Installation



  • Full Integration: It is a two way integration between Microsoft Outlook and PeopleSoft which updates data changes in PeopleSoft when changed from Outlook.
  • Partial Integration: Sends two notifications to the applicants: .ics attachment and regular notification. Send’s regular notification to Interviewers.Below screen shots show the mails received by the applicant triggered by selecting Partial Integration while scheduling the interview of the applicant.

Below screen shots show the mails received by the applicant triggered by selecting Partial Integration while scheduling the interview of the applicant.


  • No Integration: Disables calendar integration with outlook
  • Customization: It is possible to integrate Outlook with People code using Icalendar.Icalendar is a file format which allows Internet users to send meeting requests and tasks to other users. Below is the sample code 

import PT_MCF_MAIL:*;
/*Declare variables*/
Local string &dateStr = DateTimeToLocalizedString(%Date, "MM/dd/yyyy");
Local string &dateStamp = DateTimeToLocalizedString(%Datetime, "MM/dd/yyyy hh:mm:ss");
/*Receiver and sender email id*/
Local string &mail_to = "susan.silvia@kovaion.com";
Local string &organizer = "Madhur.mohini@kovaion.com";
Local string &desc = "TEST";
&dateStr1 = DateTimeValue(&dateStr | " 2:00 PM");
&dateStr2 = DateTimeValue(&dateStr | " 5:00 PM");
/*Prepare date formats required for .ics format*/
&tempTime = DateTimeToTimeZone(&dateStr1, "Local", "UTC");
&dtstart = DateTimeToLocalizedString(&tempTime, "yyyyMMdd'T'HHmmss'Z'");
&tempTime = DateTimeToTimeZone(&dateStr2, "Local", "UTC");
&dtend = DateTimeToLocalizedString(&tempTime, "yyyyMMdd'T'HHmmss'Z'");
&tempTime = DateTimeToTimeZone(%Datetime, "Local", "UTC");
&dtstamp = DateTimeToLocalizedString(&tempTime, "yyyyMMdd'T'HHmmss'Z'");
Local string &str = Char(13);
Local string &icalstr = "BEGIN:VCALENDAR" | &str;
&icalstr = &icalstr | "PRODID:-//Prod ID//PeopleCode vCal 1.0//EN" | &str;
&icalstr = &icalstr | "VERSION:2.0" | &str;
&icalstr = &icalstr | "METHOD:PUBLISH" | &str;
&icalstr = &icalstr | "X-MS-OLK-FORCEINSPECTOROPEN:TRUE" | &str;
&icalstr = &icalstr | "BEGIN:VEVENT" | &str;
&icalstr = &icalstr | "ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:" | &mail_to | &str;
&icalstr = &icalstr | "ORGANIZER:MAILTO:" | &organizer | &str;
&icalstr = &icalstr | "DTSTART:" | &dtstart | &str;
&icalstr = &icalstr | "DTEND:" | &dtend | &str;
&icalstr = &icalstr | "LOCATION:Conference Room" | &str;
&icalstr = &icalstr | "TRANSP:OPAQUE" | &str;
&icalstr = &icalstr | "DTSTAMP:" | &dtstamp | &str;
&icalstr = &icalstr | "CATEGORIES:Meeting" | &str;
&icalstr = &icalstr | "DESCRIPTION:Meeting Request" | &str;
&icalstr = &icalstr | "SUMMARY:" | &desc | &str;
&icalstr = &icalstr | "X-MICROSOFT-CDO-BUSYSTATUS:BUSY"| &str;
&icalstr = &icalstr |  "X-MICROSOFT-CDO-IMPORTANCE:1"| &str;
&icalstr = &icalstr |  "X-MICROSOFT-DISALLOW-COUNTER:FALSE"| &str;
&icalstr = &icalstr | "X-MS-OLK-AUTOFILLLOCATION:TRUE"| &str;
&icalstr = &icalstr | "X-MS-OLK-CONFTYPE:0"| &str;
&icalstr = &icalstr | "PRIORITY:5" | &str;
&icalstr = &icalstr | "BEGIN:VALARM" | &str;
&icalstr = &icalstr | "TRIGGER:PT15M" | &str;
&icalstr = &icalstr | "ACTION:DISPLAY" | &str;
&icalstr = &icalstr | "DESCRIPTION:Reminder" | &str;
&icalstr = &icalstring | "END:VALARM" | &str;
&icalstr = &icalstr | "END:VEVENT" | &str;
&icalstr = &icalstr | "END:VCALENDAR";
Local PT_MCF_MAIL:MCFOutboundEmail &email = create PT_MCF_MAIL:MCFOutboundEmail();
&email.From = &organizer;
&email.Recipients = &mail_to;
&email.Subject = "Task " | &desc;
&email.AddHeader("", "method=PUBLISH");
&email.AddHeader("", "charset=UTF-8");
&email.AddHeader("", "component=VEVENT");
&email.ContentType = "multipart/alternative";
rem &email.ContentType = "text/calendar";
Local PT_MCF_MAIL:MCFBodyPart &text = create PT_MCF_MAIL:MCFBodyPart();
&text.Text = " ";
&text.ContentType = "text/calendar";
Local PT_MCF_MAIL:MCFBodyPart &iCal = create PT_MCF_MAIL:MCFBodyPart();
&iCal.Text = &icalstr
&iCal.AddHeader("content-class", "urn:content-classes:calendarmessage");
&iCal.AddHeader("content-ID", "calendar_message");
&iCal.ContentType = "text/calendar;method=PUBLISH; charset=UTF-8";
Local PT_MCF_MAIL:MCFMultipart &mp = create PT_MCF_MAIL:MCFMultipart();
&mp.SubType = "alternative; differences=Content-type";
rem &mp.AddBodyPart(&text);
&mp.AddBodyPart(&iCal);
&email.MultiPart = &mp;
&resp = &email.Send();



Limitations of PeopleSoft Outlook Integration:
  • The integration is compatible with Microsoft Outlook 2007 or higher.
  • Not compatible with all type of calendars like lunar calendars.(Icals).
  • The debugging options are limited with Icals as the errors messages generated are generic. In-depth Icals knowledge along with PeopleSoft skillset is required to debug. 

Author,
Susan Silvia
Kovaion-Peoplesoft Consulting Practice

41 comments:

  1. This is very informative post with very affordable rates thanks sharing..worpress plugins

    ReplyDelete
  2. I was looking for something like this and I am very glad to see such amazing information here. I'll be looking forward to your suggestions. microsoft excel training malaysia

    ReplyDelete
  3. This blog is so nice to me. I will keep on coming here again and again. Visit my link as well.. www.hotmail.com

    ReplyDelete
  4. This is a terrific article, and that I would really like additional info if you have got any. I’m fascinated with this subject and your post has been one among the simplest I actually have read.
    python training Course in chennai
    python training in Bangalore
    Python training institute in bangalore

    ReplyDelete
  5. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.

    rpa training in chennai
    rpa training in bangalore
    rpa course in bangalore
    best rpa training in bangalore
    rpa online training

    ReplyDelete
  6. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.
    Best AWS Training in Chennai | Amazon Web Services Training in Chennai
    AWS Training in Bangalore | Amazon Web Services Training in Bangalore
    Amazon Web Services Training in Pune | Best AWS Training in Pune

    ReplyDelete
  7. online stumbled upon online casino advertising, all kinds of slot machines And I was glad to click on the link to see such a cool design and everything is clear where and how to play and what to press merely new online casino games now this is my favorite site

    ReplyDelete
  8. Treasurebox is an online store which provide their customers all the latest household items, outdoor furniutre,electronic gadgets nz, Pop up gazebos nz and much more.
    YOu will be easily buy all the items on a single click

    ReplyDelete
  9. Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts.

    sap hybris training in bangalore

    sap scm training in bangalore

    sap pm training in bangalore

    sap crm training in bangalore

    sap ewm training in bangalore

    ReplyDelete
  10. Thanks for this valuable information keep doing on...

    https://www.acte.in/angular-js-training-in-chennai
    https://www.acte.in/angular-js-training-in-annanagar
    https://www.acte.in/angular-js-training-in-omr
    https://www.acte.in/angular-js-training-in-porur
    https://www.acte.in/angular-js-training-in-tambaram
    https://www.acte.in/angular-js-training-in-velachery

    ReplyDelete
  11. Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts. LEGO Toys

    ReplyDelete
  12. Cool stuff you have and you keep overhaul every one of us.

    Data Science Course

    ReplyDelete
  13. Thanks for the informative and helpful post, obviously in your blog everything is good..

    Data Science Training

    ReplyDelete
  14. This article is good enough for someone to understand this amazing thing, and I'm sure everyone will appreciate these cool things.

    Data Science Certification

    ReplyDelete
  15. This is a terrific article, and that I would really like additional info if you have got any. I’m fascinated with this subject and your post has been one among the simplest I actually have read.
    angular js training in chennai

    angular js training in omr

    full stack training in chennai

    full stack training in omr

    php training in chennai

    php training in omr

    photoshop training in chennai

    photoshop training in omr

    ReplyDelete
  16. Amazing knowledge and I love to share this kind of information with my friends and hope they like it, why I am doing it.

    Business Analytics Course in Bangalore

    ReplyDelete
  17. I want to thank you for your time in this wonderful read! I really appreciate every moment and I put you in your favorites to see new things on your blog, a must-have blog!

    Data Analytics Course in Bangalore

    ReplyDelete
  18. Good Post! , it was so good to read and useful to improve my knowledge as an updated one, keep blogging. After seeing your article I want to say that also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts like this.
    Salesforce Online Training

    ReplyDelete
  19. This post is really wonderful. I enjoy reading your blogs and your thoughts. The way its all out together is really amazing! keep blogging, eagerly waiting for your posts! thanks for making it available to the public view.
    Selenium Training in Chennai

    Selenium Training in Velachery

    Selenium Training in Tambaram

    Selenium Training in Porur

    Selenium Training in Omr

    Selenium Training in Annanagar

    ReplyDelete
  20. Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts.
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    Spoken english classes in chennai | Communication training

    ReplyDelete
  21. I like this post and there is obviously a lot to know about this. I think you made some good points in Features also i figure that they having a great time to peruse this post. They might take a decent site to make an information, thanks for sharing it to me Keep working, great job!
    Braces in Bangalore

    ReplyDelete
  22. From this post I know that your good knowledge of the game with all the pieces has been very helpful. I inform you that this is the first place where I find problems that I look for. You have a clever but attractive way of writing.
    Data Science In Bangalore

    ReplyDelete
  23. Now is the perfect time to plan for the future and now is the time to be happy. I have read this article and if I can I want to suggest some interesting things or suggestions to you. Perhaps you could write future articles that reference this article. I want to know more!
    Best Data Science Courses in Bangalore

    ReplyDelete
  24. Thank you for sharing such a informative information with us. Keep on sharing the blog like this.
    DevOps Training in Hyderabad
    DevOps Course in Hyderabad

    ReplyDelete
  25. Nice post. Thanks for sharing! I want people to know just how good this information is in your blog. It’s interesting content and Great work…

    Data Science Training in Hyderabad

    ReplyDelete
  26. This blog is very informative and excellent post gained a lot of information. good job..
    Data Science Training in Hyderabad
    Data Science Course in Hyderabad

    ReplyDelete
  27. Embark on a journey to achieve your professional goals by enrolling in the Data Scientist course in Bangalore. Learn the skills of collecting, extracting, analyzing, preparing, visualizing, and presenting results to make valuable decisions. Master the concepts of data science through hands-on projects and case studies to learn the latest trends and skills in this field.
    Data Analytics Course in Calicut

    ReplyDelete