1. Implementing Recruiting
  2. Use Fast Formulas to Calculate Job Application Computed Fields

Use Fast Formulas to Calculate Job Application Computed Fields

You can use fast formulas to calculate computed fields based on the data collected on job applications. Computed fields are displayed in job application grid views and on the Extra Info tab within the job applications.

  1. Create Fast Formulas of Type Recruiting Job Application Computed Field
  2. Create Extensible Flexfields to Store Values
  3. Configure Job Application Computed Fields
  4. Add the Calculate Computed Fields Action to a Candidate Selection Process

Create Fast Formulas of Type Recruiting Job Application Computed Field

You create fast formulas using the fast formula type Recruiting Job Application Computed Field.

Before you start

  • You can use all the database items supported for fast formulas of type Recruiting Candidate Selection Process. For a complete list of database items, refer to the spreadsheet Database Items for Oracle Recruiting Cloud Fast Formulas on My Oracle Support (ID 2723251.1).
  • You need to store the returned values of the fast formula in CONDITION_MESSAGE.

Here's what to do

  1. In the Setup and Maintenance work area, use the Fast Formulas task.
  2. On the Fast Formulas page, select Create in the Actions menu.
  3. On the Create Fast Formula page:
    1. Enter a name for the formula.
    2. For the Type field, select Recruiting Job Application Computed Field.
    3. Complete the other fields as needed.
  4. Click Continue.
  5. Enter formula details in the Formula Text section.
  6. Click Compile.
  7. Click Save.

Related Topics

Create Extensible Flexfields to Store Values

You use extensible flexfields (EFFs) to store computed field values.

When you create a context for the EFF:

  • Set the Behavior field to Single Row.
  • It’s recommended to set the context usage to Usage code for candidate application.

When you create a context sensitive segment for the EFF:

  • Set the Data Type field to Character (VARCHAR2).
  • Set the Value Set field to a minimum of 5 characters and a maximum of 150 characters. This is the maximum number of characters that can be displayed in an EFF column in the job application grid view.
  • In the Display Properties section, select Read-only so that recruiting users can’t edit computed fields in the job application’s Extra Info tab.
  • It's not recommended to have any validation on flexfield segments.
  1. In the Setup and Maintenance work area, search for the task Manage Extensible Flexfields.
  2. On the Manage Extensible Flexfields page, search for the name Person EIT Information.
  3. In the Search Results section, click the Edit icon.
  4. On the Edit Extensible Flexfield: Person EIT Information page, click the Manage Contexts button.
  5. On the Manage Contexts page, click the Create icon in the Search Results section.
  6. On the Create Context page, configure the context.
    1. Enter values for Display Name, Code, API Name, Behavior. You need to set the behavior to Single Row.
    2. On the Context Usages tab, click the Create icon to define the usage of the context. It’s recommended to select Usage Code for Candidate Application to display the information to recruiters in job applications.
  7. Click Save.
  8. In the Context Sensitive Segments section, click the Create icon to add attributes to the context.
    1. For the Data Type field, select Character.
    2. For the Value Set field, the maximum is 150 characters.
    3. In the Display Properties section, select Read-only.
  9. Click Save and Close.
  10. On the Edit Context page, click Save and Close.
  11. On the Manage Context page, click Save and Close.
  12. When the context is created, you need to attach it to the Person Extra Information category.
    1. On the Edit Extensible Flexfield: Person EIT Information page, select the Person Extra Information category.
    2. On the Associated Contexts tab, click the Select and Add icon.
    3. Search for the context you created.
    4. Click OK.
  13. You then need to add the context to an existing page or a new page.
    1. On the Edit Extensible Flexfield: Person EIT Information page, click the Pages tab.
    2. Select a page or create a new one.
    3. Click Save.
    4. In the Associated Context Details section, click the Select and Add icon to associate the context to the page.
    5. Click OK.
  14. You need to deploy the flexfields to make them available.
    1. On the Manage Extensible Flexfields page, search for the Person EIT Information name.
    2. Click Deploy Flexfields.

Configure Job Application Computed Fields

You need to configure computed fields by mapping the Recruiting Job Application Computed Field fast formula to the EFFs you created. Only the mapped fields are calculated.

Only the mapped fields are calculated.
  1. In the Setup and Maintenance work area, go to:
    • Offering: Recruiting and Candidate Experience
    • Functional Area: Candidate Job Applications
    • Task: Job Application Computed Fields Configuration
  2. On the Job Application Computed Fields Configuration page, select the flexfield context you created.
    Only single-row contexts for job applications are displayed in the Flexfield Context field.
  3. Map the fast formula to the flexfield segment.
  4. Click Save and Close.

Add the Calculate Computed Fields Action to a Candidate Selection Process

You can add the Calculate Computed Fields action to a candidate selection process. This will automatically calculate computed fields in job application grid views when candidates reach the phase and state of the selection process where you added the action.

The Calculate Computed Fields action is available when entering a phase, leaving a phase, and for specific states within a phase.

The Calculate Computed Fields action is asynchronous and the scheduled process Perform Recruiting Candidate Selection Process Actions must be run for the calculation to be done. When the process is completed, the calculated values appear on the job applications list.

Recruiting users with the privilege Manage Candidates Lists (IRC_MANAGE_CANDIDATE_JOB_APPLICATION_LISTS) can manually calculate computed fields by using the Calculate Computed Fields action available on the job applications list and within job applications. When recruiting users add the Calculate Computed Fields action from the job application list, they can select up to 10 job applications for the action to be performed in real time. If they select more than 10 job applications, the action will be processed in the background and they'll be notified when the action is completed.