Oracle Transactional Business Intelligence

Products Banner

Days on Hold Calculation

36
Views
2
Comments

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? 

Comments

  • 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