Oracle AI and Analytics

Chris Shaver - HEB

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? 

Prudence K

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:

1. Access Oracle Business Intelligence as BI Author Developer
2. Navigate to the analysis and select the link to Edit
3. Select the Criteria tab
4. 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)
5. Drop-down to the right of the field and select Column Properties
6. Select the Interaction tab
7. Under the Value section, drop-down on Primary Interaction and select Action Links
8. Select the green plus sign to Add Action Link
9. Enter the name for the action next to Link Text
10. Next to Action, select the green wheel with the orange star to Create New Action
11. Select the option Navigate to a Web Page
12. 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
13. Select the button to Define Parameters
    • Note the URL is now appended with: @{1}
14. Leave the default values for Name and Prompt as is; under Value, drop-down to select Column Value
15. 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
16. Check the box for Hidden
17. Un-check the box for Optional
18. Select the Options...button in the bottom left corner
19. Check the box for Open in New Window
20. Select OK all the way back to the Criteria tab
21. Select the Results tab to click on any value within the column; users should now be linked to the record in Recruiting