nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Days on Hold Calculation

Will Murphy

Summary

Need a days on hold formula for Legacy environment

Content

Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment?

Find more posts tagged with

Reporting

SQL

Answers

Comments

Kiran Shenvi

Hi,

If you are looking for Req. Total Days on Hold then in OBI Recruiting its as below :

EVALUATE('RL_REQTIMEBETWEEN_FNC(%1,LOCALTIMESTAMP,%2,0,0,0,NULL)' AS DOUBLE,"Requisition Dates"."Req. Creation Date","Requisition Identification"."Req. Identifier")-EVALUATE('RL_REQTIMEBETWEEN_FNC(%1,LOCALTIMESTAMP,%2,1,0,0,NULL)' AS DOUBLE,"Requisition Dates"."Req. Creation Date","Requisition Identification"."Req. Identifier")

Regards,

Kiran Shenvi

Will Murphy

Thank you, Kiran.

New Announcements

New Events

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Salesforce Connector. Unlock the full value of the Salesforce CRM Connector with out-of-the-box subject areas that deliver immediate business insights, and discover how easily they can be extended to meet your unique reporting and analytics needs. Through "art of the possible" demonstrations, explore…
AIDP - Building an AI-Ready Enterprise (Europe and Middle East Time Zones)
Description: Join Oracle and ISG Research to explore what the ISG Buyers Guide™ reveals about the requirements behind successful enterprise AI deployments. ISG will share key findings on the trends shaping buyer priorities, and Oracle will show how Oracle AI Data Platform helps organizations bring AI closer to trusted…
AIDP - Building an AI-Ready Enterprise (Americas Time Zones)
Description: Join Oracle and ISG Research to explore what the ISG Buyers Guide™ reveals about the requirements behind successful enterprise AI deployments. ISG will share key findings on the trends shaping buyer priorities, and Oracle will show how Oracle AI Data Platform helps organizations bring AI closer to trusted…