How do I pull in Linked Requisitions in OTBI reports?
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
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') ) ) )
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.
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"
Alexis PJ - Have you found a solution for this? I am looking to do the same!
Thanks,
Jordan
Jordan, I have provided the solution above. Let us know if it works for you.
