Fast Formulas for Candidate Selection Processes

You can create fast formulas of the Recruiting Candidate Selection Process formula type and use them as conditions in a candidate selection process. Conditions are used to determine if an automated action will be performed to move job applications.

Note: When a job application is moved, the system processes the actions configured on the destination phase or state before updating the job application status with the new phase and state. For this reason, if within a Fast Formula associated to an action on the destination phase or state you make use of the job application’s current phase and state, this will reflect the phase and state the job application was on before moving.

This table presents the areas where fast formulas of the Recruiting Candidate Selection Process type can be used.

Recruiting Area	Purpose	Example
Candidate Selection Process Action Condition	Defines a condition that must be met for the action to be executed. The action is executed or not depending on the formula's return value.	A formula used as a condition on a Move action. The job application is moved only if the job application is from an internal candidate.
Candidate Selection Process Move Condition	Defines a condition that must be met for a job application to be allowed to move out of its current state (move to a different state). The job application can move or not depending on the formula's return value.	A formula used as a Move Condition on the Offer - Accepted state. Users can move the job application only if a background check has been requested and completed.

The return value of Recruiting Candidate Selection Process formulas must be set in the CONDITION_RESULT variable.

Formulas of the Recruiting Candidate Selection Process 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 Candidate Selection Process, you can use information related to a specific job application within this formula. For example, the job application itself, the job requisition to which the candidate applied, assessments initiated for the job application, the prescreening score of the candidate for the job application.

Sample Formula

Here's an example of a fast formula to determine if a candidate is external.

DEFAULT FOR IRC_CSP_JOBAPP_INTERNAL IS 'N'
CONDITION_RESULT = 'N'
...
RESULT = IRC_CSP_JOBAPP_INTERNAL

IF (RESULT = 'N' THEN
CONDITION_RESULT = 'Y'

return CONDITION_RESULT

Here's an example of a fast formula based on assessment result.

DEFAULT_DATA_VALUE FOR IRC_CSP_ASSMNT_PARTNER_NAME IS 'N/A'
DEFAULT_DATA_VALUE FOR IRC_CSP_ASSMNT_PACKAGE_CODE IS 'N/A'
DEFAULT_DATA_VALUE FOR IRC_CSP_ASSMNT_PACKAGE_NAME IS 'N/A'
CONDITION_RESULT = 'Y'

i = 1
WHILE IRC_CSP_ASSMNT+PARTNER+NAME.EXISTS(i) LOOP
(
    partner_name = IRC_CSP_ASSMNT_PARTNER_NAME[i]
    package_status_code = IRC_CSP_ASSMNT_PACKAGE_CODE[i]

    /* ORA_INITIATED, ORA_REQUESTED, ORA_COMPLETED_PASS, ORA_COMPLETED_FAIL */
    IF package_status_code != 'ORA_REQUESTED' THEN
    CONDITION_RESULT = 'N'

    i = i + 1
)
return CONDITION_RESULT

Here's an example of a fast formula based on a candidate interview being completed.

CONDITION_RESULT = 'N'
CONDITION_MESSAGE = 'Debug: '
 
l_interview_operation  = get_context(IRC_INTRVW_OPERATION, 'UNDEFINED')
 
CONDITION_MESSAGE = CONDITION_MESSAGE || l_interview_operation 
  
IF(l_interview_operation = 'INTERVIEW_COMPLETED') THEN
  CONDITION_RESULT = 'Y'
  
return CONDITION_RESULT, CONDITION_MESSAGE

Contexts

The following contexts are available to the Recruiting Candidate Selection Process formula type:

SUBMISSION_ID
- ID of the job application
LANGUAGE
- Language for which to retrieve multilingual information

For fast formulas used on actions performed as part of the Interview Updated event, additional context information is available to describe what interview update caused the event to be triggered. The available context information is:

IRC_INTRVW_SCHEDULE_ID: The ID of the interview schedule related to the interview update.
IRC_INTRVW_ID: The ID of the interview related to the interview update.
IRC_INTRVW_REQUEST_ID: The ID of the interview request related to the interview update.
IRC_INTRVW_OPERATION: The interview operation which triggered the event. The possible values for IRC_INTRVW_OPERATION are:
- INTERVIEW_REQUEST_SENT
- INTERVIEW_SCHEDULED
- INTERVIEW_CANCELLED
- INTERVIEW_RESCHEDULED
- INTERVIEW_UPDATED
- INTERVIEW_COMPLETED

Database Items

Database items related to requisitions, job applications, candidate profiles, interview feedback, assessments, background checks, tax credits, rehire eligibility, request information flow, prescreening are available for the formula type Recruiting Candidate Selection Process.

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).

Some database items are associated to multilingual values. Multilingual database items will return their value based on the job application language. If you need to retrieve a value in a specific language, you can change the context of the formula accordingly:

DEFAULT FOR IRC_CSP_REQ_BUSINESS_UNIT_NAME IS 'NONE'
l_locale = 'US'
CHANGE_CONTEXTS (LANGUAGE= l_locale)

name = IRC_CSP_REQ_BUSINESS_UNIT_NAME

Functions

These functions are available to support more complex calculations.

Function Name	Description	Parameters	Returned Values
IS_REQ_BELOW_IN_GEO_HIERARCHY	Determines if a job requisition's locations are at a lower or equal level of a geography in the geography hierarchy. For example, New York location is within the country US. The formula will return a Y if the geography of the requisition is the same as the possible location levels. For example, if a requisition's geography is Germany and you call the function with only the Germany geography (as in the example below), this will return Y.	Parameter 1: IRC_CSP_REQ_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. Parameters 2 to 11: Possible location levels. Level 1 is always the Country; the other levels represent sub-levels. If you don't want to define the sub-levels, you can use ANY. Parameter 12: Y/N if you want to consider the requisition's other locations (Y) or only the primary location (N). Parameter 13: The locale to use for loading the location names.	String Result (Y/N)

Function Name

Description

Parameters

Returned Values

IS_REQ_BELOW_IN_GEO_HIERARCHY

Determines if a job requisition's locations are at a lower or equal level of a geography in the geography hierarchy. For example, New York location is within the country US.

The formula will return a Y if the geography of the requisition is the same as the possible location levels. For example, if a requisition's geography is Germany and you call the function with only the Germany geography (as in the example below), this will return Y.

Parameter 1: IRC_CSP_REQ_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.

Parameters 2 to 11: Possible location levels. Level 1 is always the Country; the other levels represent sub-levels. If you don't want to define the sub-levels, you can use ANY.

Parameter 12: Y/N if you want to consider the requisition's other locations (Y) or only the primary location (N).

Parameter 13: The locale to use for loading the location names.

String Result (Y/N)

DEFAULT FOR IRC_CSP_REQ_NUMBER IS 'NONE'
CONDITION_RESULT = 'N'

l_locale = 'US'
CHANGE_CONTEXTS(LANGUAGE=l_locale)

CONDITION_RESULT = IS_REQ_BELOW_IN_GEO_HIERARCHY(IRC_CSP_REQ_NUMBER, 'Germany', 'ANY','ANY', 'ANY', 'ANY', 'ANY', 'ANY', 'ANY', 'ANY', 'ANY', 'N',l_locale) 

return CONDITION_RESULT

Function Name	Description	Parameters	Returned Values
IS_REQ_BELOW_IN_ORG_TREE	Determines if a job requisition's organization is at a lower or equal level of an organization in the organization tree. The formula will return a Y if the organization of the requisition is the same as the parameter 2 value.	Parameter 1: IRC_CSP_REQ_ORGANIZATION_NAME: Name of the organization used in the requisition. It's not required to use this database item to provide the name of the organization. As long as the name of the organization is provided. Parameter 2: The name of the organization which you want to know if the organization in parameter 1 is below or equal to. Parameter 3: The locale to use for loading the organization names.	String Result (Y/N)

Function Name

Description

Parameters

Returned Values

IS_REQ_BELOW_IN_ORG_TREE

Determines if a job requisition's organization is at a lower or equal level of an organization in the organization tree.

The formula will return a Y if the organization of the requisition is the same as the parameter 2 value.

Parameter 1: IRC_CSP_REQ_ORGANIZATION_NAME: Name of the organization used in the requisition. It's not required to use this database item to provide the name of the organization. As long as the name of the organization is provided.

Parameter 2: The name of the organization which you want to know if the organization in parameter 1 is below or equal to.

Parameter 3: The locale to use for loading the organization names.

String Result (Y/N)

DEFAULT FOR IRC_CSP_REQ_ORGANIZATION_NAME IS 'NONE'
CONDITION_RESULT = 'N'

l_locale = 'US'
CHANGE_CONTEXTS(LANGUAGE=l_locale)

CONDITION_RESULT = IS_REQ_BELOW_IN_ORG_TREE(IRC_CSP_REQ_ORGANIZATION_NAME, 'Vision Administration',l_locale) 

return CONDITION_RESULT