Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion Blog
  • 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

Search Courses

Introduction

I hope and assume that most of you by now are already well versed with creating a BIP Report based on SQL Data Source. In this post we would try to explain how to use Deep-Link in the “URL” properties to ensure when one clicks on data value he gets redirected to person management screen

So without further ado let’s get started.

Pre-Requisite

We have already created a BI Data Model and BI Report which we will utilise for this purpose.

The BI Data Model can be downloaded from here

The BI Report can be downloaded from here

The Report when ran will have data as shown below

 

One important point to note here is that for the Employee# data column we need to add a endpoint-url value for URL property which would appear as:

 

Here you would notice that there are 3 parameters used as breadcrumbs in the URL namely:

pEffectiveDate gets data from {/DATA_DS/G_1/CURRENT_DATE}

pAssignmentId gets data from {/DATA_DS/G_1/ASSIGNMENT_ID}

pPersonId gets data from {/DATA/G_1/PERSON_ID}

all these three attributes are part of data model and the Group Name is G_1

Also, one important point to note here is that the URL Link should be as below:

https://<yourpod>/hcmUI/faces/FndOverview?pEffectiveDate={/DATA_DS/G_1/CURRENT_DATE}&_afrLoop=8103129331815164&fndGlobalItemNodeId=itemNode_workforce_management_person_management&pAssignmentId={/DATA_DS/G_1/ASSIGNMENT_ID}&pPersonId={/DATA_DS/G_1/PERSON_ID}&fnd=/WEB-INF/oracle/apps/hcm/Femployment%252Fmanage%252Fui%252Fflow%252FManageEmploymentTF.xml%2523ManageEmploymentTF%2523ManageEmploymentTF;assignmentId={/DATA_DS/G_1/ASSIGNMENT_ID}&effectiveDate={/DATA_DS/G_1/CURRENT_DATE}&BManage%2BEmployment%3Bfalse%3B256%3B%3B%3B&pageParams=pPersonId={/DATA_DS/G_1/PERSON_ID};pAssignmentId={/DATA_DS/G_1/ASSIGNMENT_ID};pEffectiveDate={/DATA_DS/G_1/CURRENT_DATE}

 

Where you would need to replace yourpod with the application login link of your pod.

With this we have completed the setup steps and should now proceed to verifying results.

Verification

We will run the report which will download an excel output as shown below:

 

Now if we click on any of the data-column value for Employee# it will take us to the person management screen (for this example we will click on Emp# 1014)


Ashish Harbhajanka

Add comment


Security code
Refresh

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

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner