Reporting
Discussion List
-
Candidate while filling the form added email and name of an employee for referral bonus to employeehi I am creating inbound HCm extract to Load the referral bonus element entries for eligible employees. and taking the details from IRC_RF_Referrals for the referral. Bu… -
Need to report out on Candidates who has opted for Job AlertsSummary: Query or table and column information to report out which candidate has opted for Job Alets to receive updates about new job opportunities. Content (required): …Surabhi Kumari 86 views 5 comments 0 points Most recent by Shanna Oppenheim Recruiting, Opportunity Marketplace
-
SQL Query to fetch the Job Application IDI am looking for SQL query to fetch the Job Application ID of a Requisition. Which tables can be used here? Please share the query if anyone has already tried to fetch t…Keerthi Chinthapatla 10 views 4 comments 0 points Most recent by Nivya Mathire Recruiting, Opportunity Marketplace -
Change the Start Date of the Candidates SQL exampleSummary: Change the Start Date of the Candidates SQL example Content (please ensure you mask any confidential information): Hi Experts, I need to compile a list of candi…Volodymyr Faranosov 3 views 1 comment 0 points Most recent by Volodymyr Faranosov Recruiting, Opportunity Marketplace -
Audit Requirement for DFF Fields in Job Requisition FormHello Oracle Community, We have a requirement to audit the Descriptive Flexfields (DFFs) that are configured under the Job Requisition form. However, when we navigate to…Jasbir_336630 1 view 0 comments 0 points Started by Jasbir_336630 Recruiting, Opportunity Marketplace
-
Contingent (Recruiter) Workers Unable to Access Recruit-to-Hire Dashboard SecuritySummary: What hidden security role or privilege grants access to the “Recruit to Hire Dashboard” function? Observation: When I assigned the following seeded roles, the R…SANDYACOSTA 34 views 2 comments 0 points Most recent by Denise N-Oracle Recruiting, Opportunity Marketplace
-
Issue with Subject Area - Recruiting - Recruiting Real TimeSummary: Hi Team, We have identified an issue in the "Recruiting - Recruiting Real Time" subject area related to the Internal Employee Number field. Specifically, the fi…Anupam Rana-Oracle 1 view 0 comments 0 points Started by Anupam Rana-Oracle Recruiting, Opportunity Marketplace -
What is the correct join of per_allocated_tasks table with per_allocated_checklists table ?What is the correct join of per_allocated_tasks table with per_allocated_checklists table ?when to join with per_allocated_checklists.ALLOCATED_CHECKLIST_ID=per_allocate…sdas 22 views 1 comment 0 points Most recent by Patricia-S-Oracle Recruiting, Opportunity Marketplace
-
Req approval reportingSummary Feasibility of OTBI report on workflow approval of requisitionsContent We have a requirement to create a report of requisitions pending req approvals with req de…Sandra Barr 89 views 9 comments 0 points Most recent by MarkHodges Recruiting, Opportunity Marketplace -
Is there a report or best practice to identify notifications currently in use?Summary: Looking to see if there is a BIP report or easy way to identify what notifications are currently in use and how they are triggered (e.g. part of the Candidate S…
-
ORC - What is the table name to get the candidate labelSummary:ORC - What is the table name to get the candidate label Content (required): ORC - What is the table name to get the candidate label Version (include the version …Uday Kiran Kareti 205 views 6 comments 0 points Most recent by Dona Das Recruiting, Opportunity Marketplace -
DFF Values Not Appearing in OTBI Report – IRC_REQUISITIONS_B TableSummary: Hi Oracle Community, We recently added two Descriptive Flexfields (DFFs) to the Job Requisition form using the following configurations: One field with a List o…Jasbir_336630 15 views 2 comments 0 points Most recent by Jasbir_336630 Recruiting, Opportunity Marketplace
-
Can I customize the data model for job application report to include employee esignature and date?Summary: I have a client requirement to display employee signature and corresponding date and time in the employee job application report template. However the data mode…DiptimayeeParida18 1 view 1 comment 0 points Most recent by Alan L-Oracle Recruiting, Opportunity Marketplace
-
Which Reporting Subject Area should be used to capture recruiter comments for a candidate?Redwood – 25C Oracle Recruiting We are looking to create a report that allows us to see comments from a recruiter regarding a candidate who may reject a manager intervie…Tyler Buczynski 1 view 1 comment 0 points Most recent by Alan L-Oracle Recruiting, Opportunity Marketplace -
Job Requisition Folder under Recruiting. Recruiting Real time subject area is not bringing results.Summary: The Attributes under Job Requestion is not bringing any results in Recruiting Real time Subject Area. I am able to retrieve output from the BIP Reports. I have …Thiakeswaraa 11 views 4 comments 0 points Most recent by Yahya Khan Recruiting, Opportunity Marketplace
-
Date formatting doesn't work in Job offer letter templateSummary: Hi All! We are using format-date-nt expression for start date and end-date to avoid date discrepancy due to time zone conversion. Expression used: It is making…Balazs Grajczar 3 views 0 comments 0 points Started by Balazs Grajczar Recruiting, Opportunity Marketplace -
Internal Job Application IssueHi Team, We have observed that when customer tries to apply for Internal Job application then they are receiving email notification with Job application details along wi…Chanikya Neelam-Oracle 11 views 1 comment 0 points Most recent by PranayN Recruiting, Opportunity Marketplace
-
How to get questionnaire response for external candidatesHi Team, I am not able to find questionnaire response for external candidates. Please check the attached query & help me to get response for external candidates. Regards…Sneha Sarkar 15 views 0 comments 0 points Started by Sneha Sarkar Recruiting, Opportunity Marketplace
-
ORC Redwood: Possible to add custom reports in Recruiting DashboardHi! We are preparing to transition to Redwood, and during our initial testing in the lower environment, we noticed that the Recruiting Dashboard is currently unavailable…Kristine P. 82 views 6 comments 0 points Most recent by Kammasavala Ramadevi Recruiting, Opportunity Marketplace
-
Blind Recruitment (Anonymized Functionality) Candidate Name Shown when using Print Action in ORCSummary: Blind Recruitment (Anonymized Functionality) has been applied to ORC environments as per Doc ID 2734017.1 (Name-Blind Recruitment Implementation Guide). Current…Khadir Ahmed 311 views 9 comments 0 points Most recent by Matthew Hancock Recruiting, Opportunity Marketplace
-
Possibility to Create Reports on Job Application AI Rating Data for Custom ExportHello, I would like to ask if it is possible to create reports based on the data generated by the Job Application AI Rating functionality. Our goal is to understand whet…Ilaria Petrosino 1 view 0 comments 0 points Started by Ilaria Petrosino Recruiting, Opportunity Marketplace
-
How to get questionnaire response from external candidates using BIP?Hi Team, I am not able to add questionnaire response in below query. Could anyone please help me? SELECT distinct paam.person_id --,pd.name ,to_char(paam.person_id) PERS…Sneha Sarkar 11 views 0 comments 0 points Started by Sneha Sarkar Recruiting, Opportunity Marketplace
-
SQL query to get succession plan detailsNeed a sample query to fetch total count of active and inactive succession plans Content (please ensure you mask any confidential information): Version (include the vers…
-
Is there a way to see if a new applicant converted from a prospect on a requisition?Summary: How can we tell if a new applicant was first a prospect on a requisition. IS there a way on the candidate view grid to see this information? Content (required):…Kristina Poston 31 views 5 comments 0 points Most recent by RupalKanojia Recruiting, Opportunity Marketplace
-
We are unable to find the excat backend details of interview feedbackOur Business requirement is to get a link for the interview feedback details, where can we get the link from backend tables. Please find attached screenshot for referenc…Support 11 views 1 comment 0 points Most recent by Girish Kushibi Recruiting, Opportunity Marketplace
-
How to enable this kind of requirement in ORC audit policyHi, We have a requirement that wants to have an audit report for recruiting and candidates. Requirement below. Ability to audit all recruitment activities, including act…User_6RUAW 11 views 1 comment 1 point Most recent by BrianLawrence.G-Oracle Recruiting, Opportunity Marketplace
-
SQL Query for Create job requisition for replacement ID for value setSummary: On the Create Job Requisition page, When we try to replace the person from the Recruiting replacement on current position, By SQL on the Replacement id DFF by V…JayaramK_yash 1 view 0 comments 0 points Started by JayaramK_yash Recruiting, Opportunity Marketplace
-
Is there any way to add Custom OTBI Dashboard in Recruiting activity Center?Summary: Is there any way to add a custom OTBI Dashboard in the recruiting activity center, or can we add any embedded link? If yes, can anyone Please share the steps ho…Sidhartha Wadhwa 51 views 6 comments 1 point Most recent by mgupta6 Recruiting, Opportunity Marketplace -
How to map a customized Job Offer Letter Template to the Job OfferHow do I map the RTF file created a custom Offer Letter using the BI Publisher plugin with Microsoft Word to my job offer letters in Oracle Recruiting Cloud (ORC)Ben Baumes-Oracle 151 views 6 comments 0 points Most recent by Michj Recruiting, Opportunity Marketplace
-
How to fetch Recruiter Name and Hiring Manager Name on the basis of Position.Summary: I need to fetch the Incumbent Name, Hiring Manager Name and Recruiter name on the basis of Position. It needs to be joined with HR_ALL_POSITIONS table. Can anyo…ANNU10 32 views 1 comment 0 points Most recent by Sunder.Velagala-Oracle Recruiting, Opportunity Marketplace