Categories
- All Categories
- 106 Oracle Analytics News
- 10 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.4K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 59 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Provide Link to Candidate Job Submission in OBIEE Report

Summary
I am looking for a way to include a link to a candidate's job submission within the TEE OBIEE tool.
Content
Is there a way to include a link to a candidate's job submission in the OBIEE reporting tool?
Answers
-
Hi - there is a support doc that provides information on how to do this: 2063826.1. Do you have access to pull this document?
The link for the Submission is going to be: https://%CompanyName%.taleo.net/enterprise/publicurl/viewApplication?applicationNumber={1}
Here were the instructions provided:
- Access Oracle Business Intelligence as BI Author Developer
- Navigate to the analysis and select the link to Edit
- Select the Criteria tab
- If not already present, add "Candidate Identifier" or "Req. Identifier" or "Submission Identifier (RCAPPLICATIONNO)" to the Selected Columns section. If setting up link to submission then edit the "Submission Identifier (RCAPPLICATIONNO)" column formula and replace it with CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR)
- Drop-down to the right of the field and select Column Properties
- Select the Interaction tab
- Under the Value section, drop-down on Primary Interaction and select Action Links
- Select the green plus sign to Add Action Link
- Enter the name for the action next to Link Text
- Next to Action, select the green wheel with the orange star to Create New Action
- Select the option Navigate to a Web Page
- In the Create New Action window, next to URL, enter the appropriate URL
- Remember: replace %CompanyName% with your zone name and do not include the {1} at the end
- Select the button to Define Parameters
- Note the URL is now appended with: @{1}
- Leave the default values for Name and Prompt as is; under Value, drop-down to select Column Value
- Drop-down to select either "Candidate Identification"."Candidate Identifier" or "Requisition Identification"."Req. Identifier" or CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR) column accordingly
- Check the box for Hidden
- Un-check the box for Optional
- Select the Options...button in the bottom left corner
- Check the box for Open in New Window
- Select OK all the way back to the Criteria tab
- Select the Results tab to click on any value within the column; users should now be linked to the record in Recruiting
0 -
Prudence! Thank you so much for those detailed instructions. Do you have anyway to make the links appear on the exported reports (either PDF or Excel)? Right now, while in OBIEE, I can see and access the candidate job submissions. However, when I export the data to a PDF or to Excel, the link disappears.
0 -
OH OK, that's slightly different then! While the option below works for clicking the link and pushing people into the Recruiting tool, it does it within the same window (could not find a way to have it open in a new window) and removes people from reporting. However, if you are only looking for the link in the output, then that won't matter so much.
- Access Oracle Business Intelligence as BI Author Developer
- Navigate to the analysis and select the link to Edit
- Select the Criteria tab
- If not already present, add "Submission Identifier (RCAPPLICATIONNO)" to the Selected Columns section.
- Edit Column Formula with this:
'https://%CompanyName%.taleo.net/enterprise/publicurl/viewApplication?applicationNumber='||CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR)
- Drop-down to the right of the field and select Column Properties
- Select the Data Format tab
- Check the box for Override Default Data Format
- Under Treat Text As, drop-down to select HyperText link
- Select OK
- Select the Results tab to click on any value within the column; users should now be linked to the record in Recruiting and the link will transmit to Excel and PDF outputs
0 -
PRUDENCE!!!!!! You are my hero for the day, even the week! I truly appreciate the assistance today!
0