Oracle Transactional Business Intelligence Forum

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

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Days on Hold Calculation

51
Views
2
Comments
Will Murphy
Will Murphy Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

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? 

Tagged:

Comments

  • Kiran Shenvi
    Kiran Shenvi Rank 4 - Community Specialist

    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
    Will Murphy Rank 1 - Community Starter

    Thank you, Kiran.