Deep Links for Project Management
Project managers use Oracle Transactional Business Intelligence (OTBI) to gain real-time insights into their projects. You can enable a column in an analysis as a deep link to drill down to a transaction page.
Here's the syntax to create an action link in OTBI to create a deep link.
https://hostname/fscmUI/faces/deeplink?objType=@{1}&objKey=ObjectId=@{2}&action={3}&returnApp=@{4}&returnAppParams=PortalGo%26path=/users/@{5}/@{6}
Use this syntax if you don't want to use the return feature.
https://hostname/fscmUI/faces/deeplink?objType=@{1}&objKey=ObjectId=@{2}&action={3}
Parameter |
Details |
---|---|
{1} |
Name of the object type. |
{2} |
Name of the object key. |
{3} |
The action on clicking the link. The name of the page or work area where you want to navigate from the analysis. |
{4} |
Name of your analytics application. |
{5} |
Logged in user. |
{6} |
Name of the analysis. |
For example, to navigate to the Project Overview page in context of a project from your analysis, the action link is as follows:
https://hostname/fscmUI/faces/deeplink?objType=@{Project}&objKey=ObjectId=@{"Project"."Project Key"}&action={OVERVIEW}&returnApp=@{AnalyticsApp}&returnAppParams=PortalGo%26path=/users/@{USER}/@{Project Drill Down}
Here's the list of pages you can access using deep links. Use the relevant object type, object key, and action values in the syntax to navigate to the corresponding page in the application.
Object Type |
Object Key |
Object Id |
Action |
Navigates to Application Page |
---|---|---|---|---|
PROJECT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
NONE |
The default page, that's the Project Overview page |
PROJECT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
OVERVIEW |
Project Overview |
PROJECT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
MANAGE_FIN_PLAN |
Manage Financial Project Plan |
PROJECT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
MANAGE_BUDGET |
Manage Project Budget |
PROJECT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
TRACK_PROGRESS |
Track Financial Project Progress |
PROJECT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
MANAGE_FORECAST |
Manage Project Forecast |
PROJECT_ACTION_ITEM |
"Task"."Task Key" |
objKey=projElementId=@{2} |
EDIT |
Edit Action Item |
PROJECT_BUDGET |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
NONE |
NManage Project Budget |
PROJECT_BUDGET |
"Project"."Project Key"; “Param1”.”Budget version Key” |
objKey=ProjectId=@{2} |
VIEW |
View Project Budget |
PROJECT_DELIVERABLE | "Deliverable Details"."deliverableId" | objKey=deliverableId=@{2} | EDIT | Edit Deliverable |
PROJECT_FORECAST |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
NONE |
Manage Project Forecast |
PROJECT_FORECAST |
"Project"."Project Key"; “Param1”.”Forecast version Key” |
objKey=ProjectId=@{2} |
VIEW |
View Project Forecast |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
MANAGE_FINANCIAL_PROJECT |
Manage Financial Project |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=ProjectId=@{2} |
MANAGE_PROJECT_BUDGET |
Manage Project Budget |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
MANAGE_PROJECT_CALENDAR |
Manage Project Calendar |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
MANAGE_PROJECT_FORECAST |
Manage Project Forecast |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
NONE |
NManage Project Plan |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
MANAGE_PROJECT_RESOURCE_REQUESTS |
NManage Project Resource Requests |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
MANAGE_PROJECT_RESOURCES |
Manage Project Resources |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
MANAGE_TASK_EXCEPTIONS |
NManage Task Exceptions |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
MANAGE_WORK_ITEMS |
Manage Work Items |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectId=@{2} |
TRACK_FINANCIAL_PROJECT_PROGRESS |
Track Financial Project Progress |
PROJECT_MANAGEMENT |
"ChangeOrder"."ChangeOrder Key" |
objKey=changeDocumentId=@{2} |
MANAGE_CHANGE_ORDERS |
Manage Change Orders |
PROJECT_MANAGEMENT |
"Project"."Project Key" |
objKey=projectID=@{2} |
VIEW_ONLY_PLAN |
View Project |
PROJECT_MANAGEMENT |
"Issue Details"."Issue Id" |
objKey=issueId=@{2} |
EDIT |
Edit Issue |
PROJECT_RESOURCE |
"Resource"."Resource Key" |
objKey=resourceId=@{2} |
EDIT |
Resource Details |
PROJECT_RESOURCE_ASSIGNMENT |
"Project Assignment"."Assignment Number" |
objKey=assignmentId=@{2} |
EDIT |
Edit Project Resource Assignment |
PROJECT_RESOURCE_REQUEST |
"Project Request Details"."Request Number" |
objKey=requestId=@{2} |
EDIT |
Edit Project Resource Request |
PROJECT_MILESTONE_TASK |
"Task"."Task Key" |
objKey=projElementId=@{2} |
EDIT |
Edit Milestone |
PROJECT_TASK |
"Task"."Task Key" |
objKey=projElementId=@{2} |
EDIT |
Edit Project Task |
PROJECT_TO_DO_TASK |
"Task"."Task Key" |
objKey=projElementId=@{2} |
EDIT |
Edit To-do Task |
UNPROCESSEDTXNDETAILS | "Unprocessed Transaction Details"."Transaction Interface Id" | none | Drill | Manage Unprocessed Project Costs |
Grants Management
You can enable an Action link on a column in your analysis, such as Award Number, to enable the drill down to the Award Overview page. Here's the syntax to create an action link in Grants Management.
https://hostname/fscmUI/faces/deeplink?objType=@{1}&objKey=ObjectId=@{2};searchInd=@{3}&action={4}&returnApp=@{5}&returnAppParams=PortalGo%26path=/users/@{6}/@{7}
Use the following syntax if you don't want to use the return feature.
https://hostname/fscmUI/faces/deeplink?objType=@{1}&objKey=paraAwardId=@{2};searchInd=@{3}&action=@{4}
Parameter |
Prompt | Type | Value |
Details |
---|---|---|---|---|
{1} |
ObjType | Value | Awardoverview |
Name of the object type. |
{2} |
ObjKey | Column Value | "Award"."Award ID" |
Name of the object key. |
{3} | SearchInd | Value | 0 | Search index value. |
{4} |
Action | Value | EDIT |
The action on clicking the link. The name of the page or work area where you want to navigate from the analysis. |
{5} |
returnApp | Value | AnalyticsApp |
Name of your analytics application. |
{6} |
Logged in User | Session Variable | USER |
Logged in user. |
{7} |
Report Name | Value | Award Drill Down* |
Name of the analysis. |
*Change parameter 7 and put the name of the report you created.
Ensure that the data format for Award ID has no decimal places.
When you create a deep link, include these steps:
- Replace the "hostname" with the name of the environment.
-
If you don't click the return icon, remove lines 5 through 7. The URL should be:
https://hostname/fscmUI/faces/deeplink?objType=@{1}&objKey=paraAwardId=@{2};searchInd=@{3}&action=@{4}
-
Enable the option Do not display in a popup if only one action link is available at runtime.