Automate HR Email Notifications with Oracle BI Publisher: How to Create an RTF Template

Consistent, well-formatted email notifications help HR teams act on key events, like an employee reaching the end of probation. In Oracle Fusion HCM, BI Publisher uses an RTF template to turn report data into a formatted email or document. The template is built in Microsoft Word with the BI Publisher plug-in, where sample XML data from the data model is loaded and fields are mapped as placeholders such as manager name, employee name and probation end date. Once uploaded as a layout, the report can be scheduled and the emails are delivered to the right people automatically. Watch this Quick Read video to see how to build one from scratch. 

What are Kovaion’s highlights in this Quickreads video? 

Let’s take a look at the key highlights from the Quickread video. 

  • Introduction to the report and data model in the BI Publisher catalog, and generating sample data for the template. 
  • Reviewing the report properties, including enabling bursting to send personalized output. 
  • Designing the template in Word using the BI Publisher plug-in: loading the sample XML and inserting fields and tables. 
  • Uploading the RTF file as a layout in the report, with a layout name, type and locale. 
  • Scheduling the report job and checking its status in Report Job History. 
  • Verifying the final email in the recipient’s inbox with the data populated. 

Business Benefits of the Quickreads video: 

Check out the essential benefits of the Quickread “How to Create an RTF Template”. 

  • Standardized Communication: Every notification follows the same approved format and wording. 
  • Personalized Output: Fields pull employee and manager details automatically from the data. 
  • Time Savings: Bursting sends emails to many recipients in a single run. 
  • Reusable Design: One template can be reused and updated without rebuilding the report. 
  • Easy Monitoring: Report Job History shows whether each run succeeded.