How do I pull in Linked Requisitions in OTBI reports?

Alexis PJ

How do I pull in Linked Requisitions in OTBI reports?

Nathan CCC

Hi,

This look like something to do with a job requisition. So we are I assume in a work area in talent management in Human Capital Management HCM from "applicant lifecycle" business process "Recruit to Onboard".

If you want to build, an analysis in OTBI or a report in OTBI with data model data source Oracle BI EE/analysis, from subject areas from metadata repository database then consider subject area Recruiting - Recruiting Real Time

Oracle Fusion Cloud HCM
Subject Areas for Transactional Business Intelligence in HCM
F92793-01 24B

https://docs.oracle.com/en/cloud/saas/human-resources/24b/faohb/Recruiting--Recruiting-Real-Time-SA-77.html#Recruiting__Recruiting_Real_Time_SA_77_d1e13840

To see if if a subject area has what you need regards linked requisitions review data lineage mapping

https://us.v-cdn.net/6034893/uploads/J92660XFV47W/r13-24b-hcm-otbi-database-mapping-with-viewobjects.xlsx

If the table of view you need is not in data lineage mapping then build a report in OTBI using data source HCM

https://docs.oracle.com/en/cloud/saas/human-resources/24b/oedmh/ircrequisitionsb-10407.html#ircrequisitionsb-10407

Nathan CCC

FYI Assume this is the action you did to create a "linked requisition"?

Oracle Fusion Cloud Talent Management
Using Recruiting
F92723-02 24B
Create a Standard Job Requisition Linked to a Pipeline Job Requisition

https://docs.oracle.com/en/cloud/saas/talent-management/24b/faush/create-a-standard-job-requisition-linked-to-a-pipeline-job.html#s20081812

so does this query give you the relationship you need

#…/analytics/saw.dll?IssueRawSQL

select all 0 s_0

, cast("Job Requisition - Basic Information"."Requisition Id" as character) as requistion_id

, cast("Job Requisition - Basic Information"."Pipeline Requisition ID" as character) as requistion_id_pipeline

, "Job Requisition - Basic Information"."Pipeline Requisition Number"

, "Job Requisition - Basic Information"."Pipeline Requisition Title"

, "Facts - Requisition Counts"."Number of Job Requisitions" as f

FROM "Recruiting - Recruiting Real Time"

which is I think this parent child relationship in the application database

 SELECT RequisitionBPEO.REQUISITION_ID 
 ,         RequisitionBPEO.PIPELINE_REQUISITION_ID  
 FROM IRC_REQUISITIONS_B RequisitionBPEO  
 WHERE  ((1=1))  AND ( ( (UPPER(RequisitionBPEO.REQ_USAGE_CODE) = UPPER('ORA_REQUISITION') ) ) )

Alexis PJ

I am using the 'Recruiting - Recruiting Real Time' subject area and I am already pulling in the Requisition Type (Standard or Pipeline) but I am not seeing anything about the Linked Requisition even though it's on the req shown on my original screenshot.

Nathan CCC

So my proposal was to add to your query 3 columns which will may link a pipeline to a standard and vice versa

cast("Job Requisition - Basic Information"."Pipeline Requisition ID" as character)
"Job Requisition - Basic Information"."Pipeline Requisition Number"
"Job Requisition - Basic Information"."Pipeline Requisition Title"

Jordan Gariety

Alexis PJ - Have you found a solution for this? I am looking to do the same!

Thanks,

Jordan

Nathan CCC

Jordan, I have provided the solution above. Let us know if it works for you.