Fusion HCM RTF Layout Guide

Create Fusion HCM BI RTF Layout from Scratch

Creating a Fusion HCM BI RTF Layout from scratch is one of the most essential skills for any Oracle HCM technical consultant. Whether you are building payslips, employee letters, or HR analytics reports, mastering RTF template development in Oracle Fusion HCM using Oracle BI Publisher is critical for real-world project delivery.

In almost every HCM implementation, clients expect customized report outputs—not just raw XML data. That’s where RTF layouts come into play.

What is Fusion HCM BI RTF Layout?

A BI RTF Layout is a formatted template (created in Microsoft Word) that transforms XML data into a readable report format such as PDF, Excel, or Word.

In simple terms:

• Data Template / Data Model → Provides XML data
• RTF Layout → Defines how the data looks
• Output → Final report (PDF, Excel, etc.)

RTF layouts use BI Publisher syntax (XDO tags) embedded in Word documents to display dynamic data.

Why RTF Layout is Critical in Fusion HCM

From a consultant’s perspective, RTF templates are used in:

• Payslip generation
• Offer letters
• Experience certificates
• Headcount reports
• Payroll summaries

Without RTF layouts, reports remain raw and unusable for business users.

Key Features of BI RTF Layout

1. Dynamic Data Rendering

You can display employee data dynamically using XML tags.

2. Conditional Formatting

Show or hide sections based on logic:

3. Looping Structures

Repeat sections like employee lists:

4. Multi-format Output

RTF layouts can generate:

• PDF
• Excel
• Word

5. Localization Support

Supports multiple languages for global implementations.

Real-World Implementation Use Cases

Use Case 1: Employee Payslip Report

A payroll client required:

• Earnings & deductions breakdown
• Net pay calculation
• Company branding

RTF layout handled:

• Tables for salary components
• Conditional display for deductions
• Currency formatting

Use Case 2: Offer Letter Automation

HR wanted:

• Auto-generated offer letters from system data

RTF layout enabled:

• Dynamic employee name, salary, joining date
• Conditional clauses (probation vs permanent)

Use Case 3: Headcount Report

Management required:

• Department-wise employee count

RTF layout used:

• Grouping
• Subtotals
• Page breaks per department

Architecture / Technical Flow

Here’s how the reporting flow works:

1. Data Model fetches data from Fusion tables
2. BI Publisher converts data into XML
3. RTF Template applies formatting
4. Output generated (PDF/Excel)

Important Insight (Consultant Tip):
Always validate XML before starting layout design—90% of layout issues originate from incorrect XML structure.

Prerequisites

Before creating RTF layout, ensure:

• BI Report (Data Model) is created
• Sample XML is available
• Microsoft Word installed
• BI Publisher Desktop Plugin installed

Step-by-Step: Create Fusion HCM BI RTF Layout from Scratch

Step 1 – Download Sample XML

Navigation:

Steps:

1. Open your report
2. Click Edit
3. Go to Data
4. Click View Data
5. Download XML file

Step 2 – Install BI Publisher Plugin

Download BI Publisher Desktop (Word Plugin)

This adds a BI Publisher tab in Word.

Step 3 – Load XML in Word

1. Open Word
2. Go to BI Publisher tab
3. Click Sample XML → Load XML Data
4. Select downloaded XML

Step 4 – Design Basic Layout

Start simple:

Example:

Step 5 – Create Table for Multiple Records

For repeating data:

1. Insert table in Word
2. Add BI tags:

Step 6 – Add Formatting

Currency Format

Date Format

Step 7 – Add Conditional Logic

Example:

Step 8 – Grouping Example

Step 9 – Preview Report

1. Go to BI Publisher tab
2. Click Preview
3. Select output (PDF/HTML)

Step 10 – Upload Layout to Fusion

Navigation:

Steps:

1. Upload RTF file
2. Assign to report
3. Save

Testing the RTF Layout

Test Scenario

Example:

• Employee: John
• Salary: 60000
• Department: Finance

Expected Output

• Name displayed correctly
• Salary formatted
• Department grouping applied

Validation Checklist

• No blank fields
• Proper formatting
• No XML tag errors

Common Errors and Troubleshooting

1. XML Tag Not Displaying Data

Cause: Incorrect tag name
Fix: Verify XML structure

2. Loop Not Working

Cause: Wrong hierarchy
Fix: Check parent-child nodes

3. Formatting Issues

Cause: Incorrect syntax
Fix: Use proper BI functions

4. Blank Output

Cause: Missing XML data
Fix: Re-download XML with data

Best Practices from Real Projects

1. Always Start with XML Analysis

Understand:

• Node structure
• Repeating elements

2. Use Table-Based Layouts

Avoid free text for large reports.

3. Keep Layout Modular

Break sections:

• Header
• Body
• Footer

4. Use Meaningful Naming

Instead of:

Use:

5. Avoid Hardcoding Values

Always use dynamic tags.

6. Test with Multiple Scenarios

• Single record
• Multiple records
• Edge cases

Advanced Consultant Tips

• Use sub-templates for reusable components (like headers)
• Implement page breaks using:

• Use charts in BI Publisher for dashboards
• Combine RTF + Excel templates for complex reporting

Summary

Creating a Fusion HCM BI RTF Layout from scratch is not just about designing a Word document—it’s about understanding XML data, applying BI Publisher logic, and delivering business-ready reports.

A strong consultant focuses on:

• Clean XML structure
• Logical grouping
• Efficient formatting
• Real-world usability

Mastering RTF layouts significantly improves your ability to deliver end-to-end reporting solutions in Oracle Fusion projects.

FAQs

1. What is the difference between RTF and Excel templates in BI Publisher?

RTF is used for formatted documents (PDF/Word), while Excel templates are used for data-heavy reports.

2. Can we use RTF layout for bursting reports?

Yes, RTF layouts are commonly used in bursting scenarios like payslip distribution.

3. How do I debug RTF template issues?

• Check XML structure
• Validate BI tags
• Use preview option in Word

For more details, refer to Oracle documentation:
https://docs.oracle.com/en/cloud/saas/index.html