Contact Us

  • Register

Search Courses

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive


As most of you must know by now that OTBI is one of the most simple yet one of the most effective reporting tool in Oracle HCM Cloud Application. Apart from being a self-service tool which allows drag and drop feature to create your analysis it also takes care of security features. What this means essentially is that individuals running the report would only have access to records that they are entitled to view (based on the roles assigned to the user). Exactly for this reason at times it becomes necessary to display the current logged in username in the Report.

In this article, we would try to add the Logged in Username field for an OTBI Report.


We would need to have a pre-existing report (say Person Basic Details for this example). The report contains Person Number and Person Name


Displaying Current Logged In User

Now for this report, we would like to display the Current Logged in User as a header. To accommodate this change we would need to make following changes:

  1. Include a Session Variable which will hold the current session user detail in the OTBI Analysis

  2. Make changes in the associated data model to include this change

  3. Edit the RTF Template to map the new field in the layout

Adding Session Variable to the OTBI Analysis

We need to open the Analysis and under criteria add the session variable


Once we add the field, we should ‘Save’ the Analysis.

Adding the User Field on the Data Model

Before we add the field to the data model it would appear as shown below:

We need to click on the ‘Edit Data Set’ option and point to the OTBI Analysis


Once done the Data Model would appear (Notice the new column ‘Column2’ is visible now)


Once done we need to save the Data Model.

Adding the New Field in the RTF Layout

As a last step, we would need to add the new field in the RTF Layout. We would need to add the below fields in the Layout

Item Type

Item Value

Text Item


Data Field



We need to save this template.

Running the Report

We would now try to run the Report and confirm whether the changes are as expected. We would need to click on the “View Report” Button


And this brings up the below screen

Which now has the Current Logged in User Details displayed?

With this, we have come to the end of the article. Thank You! For your time and have a nice day ahead.

Ashish Harbhajanka

About the Author

Ashish Harbhajanka


Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK


Overall Rating (0)

0 out of 5 stars
  • No comments found

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Nov 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner