1. Implementing Recruiting
  2. Fast Formulas for Job Requisitions

Fast Formulas for Job Requisitions

You can create fast formulas of the Recruiting Job Requisition formula type and use them as conditions in job requisitions. Conditions are used to determine if job requisitions will be automatically unposted from career sites.

This table presents the area where fast formulas of the Recruiting Job Requisition type can be used.

Recruiting Area

Purpose

Example

Job Requisition Unpost Condition

Defines a condition that must be met for the job requisition to be unposted from the internal career site, the external career sites, or both.

A formula used as a condition to automatically unpost a job requisition. The job requisition is automatically unposted when a given number of job applications have been received.

The return value of Recruiting Job Requisition formulas must be set in the CONDITION_RESULT variable.

Formulas of the Recruiting Job Requisition type must return a value indicating if the condition is met or not. Use the following variables in the return statement:

CONDITION_RESULT variable contains the result of the formula, which indicates if the condition is met or not.

  • To indicate that the condition is met, the CONDITION_RESULT variable must contain one of the following values (case insensitive):

    • y

    • yes

    • true

    • 1

  • Any other value will consider the condition as not being met.

CONDITION_MESSAGE is an optional part of the result, it doesn't have to be returned. Maximum size is 255 characters.

  • The message is used for logging purposes only.

CONDITION_RESULT = 'N'
CONDITION_MESSAGE = ''

...

return CONDITION_RESULT, CONDITION_MESSAGE

When you create a fast formula of type Recruiting Job Requisition, you can use information related to a specific job requisition within this formula. For example, the requisition's recruiting type, organization, number of confirmed job applications.

Sample Formula

Here's an example of a fast formula to automatically unpost a job requisition based on the number of confirmed job applications on the requisition.

DEFAULT FOR IRC_REQ_JOBAPP_COUNT_CONFIRMED IS 0
CONDITION_RESULT = 'N'
...

COUNT = IRC_REQ_JOBAPP_COUNT_CONFIRMED

IF (COUNT > 500) THEN
CONDITION_RESULT = 'Y'

return CONDITION_RESULT

Contexts

The following contexts are available to the Recruiting Job Requisition formula type:

  • IRC_JOB_REQUISITION_ID

    • ID of the job requisition.

  • IRC_JOB_LANGUAGE

    • Language for which to retrieve multilingual information.

Database Items

Database items related to requisitions are available for the formula type Recruiting Job Requisitions.

For a complete list of database items, see the spreadsheet Database Items for Oracle Recruiting Cloud Fast Formulas on My Oracle Support (MOS ID 2723251.1).

Functions

These functions are available to support more complex calculations.

Function Name

Description

Parameters

Returned Values

COUNT_JOBAPPS_ACTIVE_IN_PHASE_STATE

Counts the number of active job applications which are currently in a given phase or state for a job requisition.

Parameter 1: IRC_REQ_REQUISITION_NUMBER: Number of the requisition. It's not required to use this database item to provide the requisition number. As long as a requisition number is provided.

Parameter 2: Phase name. The name of the phase for which to count the active job applications.

Parameter 3: State name. The name of the state, within the phase provided as the previous parameter, for which to count the active job applications. If you want to count the job applications for all states within the phase, you can use ANY.

Parameter 4: The locale to use for loading the phase and state names.

Number of job applications

 
DEFAULT FOR IRC_REQ_REQUISITION_NUMBER IS 'none'
CONDITION_RESULT = 'N'
...

COUNT = COUNT_JOBAPPS_ACTIVE_IN_PHASE_STATE(IRC_REQ_REQUISITION_NUMBER, 'New', 'To be Reviewed', 'US')

IF (COUNT > 300) THEN
CONDITION_RESULT = 'Y'

return CONDITION_RESULT

Function Name

Description

Parameters

Returned Values

COUNT_JOBAPPS_PAST_PHASE_STATE

Counts the number of job applications which were previously or are currently in a given phase or state for a job requisition.

Parameter 1: IRC_REQ_REQUISITION_NUMBER: Number of the requisition. It's not required to use this database item to provide the requisition number. As long as a requisition number is provided.

Parameter 2: Phase name. The name of the phase for which to count the number of job applications.

Parameter 3: State name. The name of the state, within the phase provided as the previous parameter, for which to count the job applications. If you want to count the job applications for all states within the phase, you can use ANY.

Parameter 4: The locale to use for loading the phase and state names.

Number of job applications

 
DEFAULT FOR IRC_REQ_REQUISITION_NUMBER IS 'none'
CONDITION_RESULT = 'N'
...

COUNT = COUNT_JOBAPPS_PAST_PHASE_STATE(IRC_REQ_REQUISITION_NUMBER, 'New', 'To be Reviewed', 'US')

IF (COUNT > 300) THEN
CONDITION_RESULT = 'Y'

return CONDITION_RESULT

Related Topics