Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
More Solutions
Oracle Transactional Business Intelligence Forum

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.