Recruiting
Discussion List
-
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 144 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 23 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 11 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 11 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 31 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 71 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. Thanks, Ajay …AjayKumar Maddipati 102 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 22 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 35 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 1 view 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 11 views 2 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
Fact Definitions - Candidate Tracking Real TimeSummary: Content (required): Where can I find the definitions of facts in the Candidate Tracking Real Time Subject Area? I'm looking for the difference between 'Number o…Susan Anderson 92 views 11 comments 0 points Most recent by User_MN692 Reporting and Analytics for HCM -
How can we change BI report name dynamically while downloading as per selection parameter.I have created a BI report as 'Job Application Report' and in this report I have created many parameters. One of them is the parameter name 'Requisition Name'. And After…Anjali_Jaiswal 121 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Trying to invoke candidate attachment REST API through PL SQL procedure giving errorSummary: Trying to invoke candidate attachment REST API through PL SQL procedure giving error " PLS-00306: wrong number or types of arguments in call to '||' " v_buffer1…
-
Requisition: Is it possible to create a report to see who deleted a candidate from a requisition?Hello, Is it possible to create a report/analysis to see who deleted a candidate from a requisition? If so, could you please tell me how? I am not so familiar yet with O…Michael Schweizer 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 95 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Issue getting most recent/max date for "Offer Extended" Recruiting EventSummary I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows retu…User_2025-02-04-23-22-13-274 112 views 9 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM -
Oracle Recruiting Internal and External Selected Canidates - OTBI ReportSummary: We have requirement to show selected internal and external candidates in an OTBI report. Please advise. Please provide a sample report. Content (please ensure y…MadhuLekkala 34 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 131 views 20 comments 1 point Most recent by Kyle Norris Reporting and Analytics for HCM
-
move to HR then the candidate will automatically be a part of auto convert process of employee.Summary:Is there any option in recruting cloud that when recruiter moving a candidate to move to HR then the candidate will automatically be a part of auto convert proce…swarup ghosh 14 views 2 comments 0 points Most recent by swarup ghosh Recruiting, Opportunity Marketplace -
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working for Recruiting - Recruiting RealtimeSummary: For my OTBI analysis, I applied the prefix mentioned in the documentation for the Recruiting - Recruiting Real Time subject area under the Time Reporting headin…A.J. 25 views 3 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Move to HR blank in analysisSummary: Move to HR blank in analysis Content (please ensure you mask any confidential information): Hello experts, we are creating a custom OTBI analysis where we need … -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
Where is the LONG URL stored for candidate source tracking?Summary: I am trying to locate the LONG URL that is captured as part of Source information mentioned in the second paragraph of this oracle help document. Does anyone kn…MarkHodges 3 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na…
-
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than…