Fusion Blog

EBS Blog


Contact Us

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive



In one of the previous article (Using Delivered Date Time and System Functions in OBI Analysis) we have seen how to use delivered functions to display Current Date, Current Time, Logged In User and other details. Continuing with the same we will try to show how can one use SUBSTRING function in an OTBI Analysis.


So let’s get started.


Using Substring Function in OTBI Analysis


In order to demonstrate this we would create a very simple OTBI Analysis. For this example we would use “Workforce Management - Person Real Time” Subject Area and the details of the field included are present in table below.

Attribute Name

Attribute Value

Person Number

"Person Details"."Person Number"

National Identifier Type

"Person National Identifiers"."National Identifier Type"

National ID

"Person National Identifiers"."National Identifier Number"

First 3 Characters of NID

SUBSTRING("Person National Identifiers"."National Identifier Number" FROM 1 FOR 3)

4th and 5th Character of NID

SUBSTRING("Person National Identifiers"."National Identifier Number" FROM 5 FOR 2)

Last 4 Characters of NID

SUBSTRING("Person National Identifiers"."National Identifier Number" FROM 8 FOR 4)


The Crieteria Tab would appear as below:



And the results tab would show the desired results


Ashish Harbhajanka


0 #1 Angus 2021-07-12 23:20
Hello , how are you .

if i have a field called "Concat Account"....and it has something like

australia.project xyz.expenses

how would i extract 'expenses' if all three of the components have variable sizes ?

Thanks and kind regards

Add comment

Security code

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


Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2022  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner