Recruiting
Discussion List
-
Generate candidate list for incomplete submissionsSummary: how do i generate a list of candidates that did not complete their application? Content (required): Hi we are in process of migrating from Taleo to ORC 22A and …MarkHodges 46 views 3 comments 0 points Most recent by Harika.Viswanatham Reporting and Analytics for HCM -
Recruiting Audit Report neededSummary: Recruiting Audit report needed Content (please ensure you mask any confidential information): We are looking for a Recruiting Audit report. Showing Requisition-… -
Asking for some tips for these column in OTBI to BIPSummary: Hi there!. May I ask some idea where I could find these columns in https://docs.oracle.com/en/cloud/saas/human-resources/24c/oedmh/hcm-tables-and-views.html#Pri… -
OTBI excluding the requisitions that are in any other phase other than "Open"I am creating a report using "Recruiting Real Time". The report works fine when i run with the basic attributes like Requisition number, name etc. But as soon as i inclu…Girish Bhatia 20 views 5 comments 1 point Most recent by Alice Gouzy Reporting and Analytics for HCM -
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …Shanna Oppenheim 114 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
I am looking for the field.Summary: Hi, I am looking for the column/field of "Does not meet the required criteria for the role" in ORC. Content (please ensure you mask any confidential information…Robb 64 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to get Requisition Template name in ORCHi, I have requirement to get Requisition Template name from Basic Information. navigation --> My Client Group - Hiring - Requisition (number) - Details - Basic Informat…Rajdeep Chavda 274 views 10 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
SQL to Show Which Pay Frequency is Associated to Which Legal EntitySummary: I am tasked with producing a mapping document of which Pay Frequencies are associated to each legal entity. I can find the Legal entities in "HR_LEGAL_ENTITIES"…Mickey James 55 views 2 comments 0 points Most recent by Mickey James Reporting and Analytics for HCM
-
ORC - Candidate Details Report with phone numberSummary: Looking for the column or field phone number that has both country code area code and phone number rather than displaying it in separate columns In the UI, its …ikc 50 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need table name for Business Object Type and its associated actionsSummary: Need table name for Business Object Type and its associated actions, as we are working on deep link for Job Requisitions page. So we are searching for actions u…GajavalliKoteswararao 15 views 0 comments 0 points Started by GajavalliKoteswararao Reporting and Analytics for HCM
-
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…AjayKumar Maddipati 5 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Exclude 'Days Suspended' in Recruiting Dashboard Time to Hire data?Summary: Exclude days suspended in Recruiting Dashboard 'time to hire' metrics Content (please ensure you mask any confidential information): Our client wishes to exclud… -
Could it be possible any way to Expiration date of SIN to be mandatory also.Summary: For Canada Location The SIN No is mandatory.Could it be possible any way to Expiration date to be mandatory also. Content (please ensure you mask any confidenti…swarup ghosh 17 views 1 comment 0 points Most recent by Joey O-Oracle Recruiting, Opportunity Marketplace -
How internal candidates can apply for Hiring events?Summary: How internal candidates can apply for hiring events? After being added to the event, candidates are receiving bell notification to register, they are able to op…
-
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…Evelina Hobson 29 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Recruiting Real time Subject Area - Candidate Pool missing data?Summary: Hi Experts, I’m wanting to create a Candidate Pool analysis report using the Recruiting Real time Subject Area. I cannot find a data field to capture the start …
-
Recruiting Custom Posting Description Fields Query / SQLHello Experts We need to fetch in a query posting descriptions, for internal and external posting, that were entered by the Manager on Job Requisition Creation > Recruit…Pedro Teixeira 202 views 1 comment 0 points Most recent by Ben Baumes-Oracle Reporting and Analytics for HCM -
Trans ID is null for Approval Notification Archive Real Time when business process=Approve Job RequiSummary: We are trying to combine requisition subject area(Recruiting - Recruiting events real time) with transaction console(Human Capital Management - Approval Notific…SHRUTI PRIYA 30 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Candidate address is getting uploaded without zip code value via HDLHi Team, We are trying to create candidates in HCM using HDL data load. I have observed While loading candidate address using HDL , address is getting loaded without Pos…Saurabh_Mharolkar 15 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …Jacqueline GRANDIN 20 views 3 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table… -
Not possible to use the phase/state name joining other subject area in OTBI analysisHi all, We are trying to create an Analysis in OTBI with Recruiting data. For this, we are joining the "Recruiting - Recruiting Events Real Time" and the "Recruiting - R…
-
Remove assignment 'O' and 'OT'Summary: We have a internal candidate who is in Offer-Draft status, an assignment has been starting with 'O' we wish to remove this assignment and withdraw the offer, ho…Tara Samari-237472 42 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Recruiting, Opportunity Marketplace
-
In BI Report we have date parameters when we apply morethan one year we get time exceeds errorSummary: Hi Team, Hope all are doing great! In Onbaording BI Report we have date parameters when we apply more than one year we get time exceeds error if we apply less t…AjayKumar Maddipati 83 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
ORC Offers Transactions Report but need to add Requsition Number in BI it is possible ?Summary: Hi Team, ORC Offers Transactions Report but need to add Requsition ID in BI it is possible ? if how can i add this , I'm new to ORC. PFA of query. https://us.v-…AjayKumar Maddipati 104 views 24 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
We have ORC Offers Transactions Report but need to add country column for below query ?Summary: Hi Team, We have ORC Offers Transactions Report but need to add country column for ? Content (please ensure you mask any confidential information): select a.OBJ…AjayKumar Maddipati 25 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 54 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…Giuseppe Iacono 5 views 0 comments 0 points Started by Giuseppe Iacono Reporting and Analytics for HCM -
How do I query Estimated Time To Hire from ORC using BI Publisher?Summary: I need to query data on Estimated Time To Hire for existing requisitions. Any information is greatly appreciated. Content (please ensure you mask any confidenti…
-
Creating Recruiting Support ReportsSummary: We need to create support reports for our mapping operations in the recruiting module. Specifically, we need to extract the following data: The list of Candidat…Giuseppe Iacono 15 views 2 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM