Bring Internal Employee Assignment Details into Oracle Recruiting

Introduction

One of the most common requirements during Oracle Recruiting implementations is giving recruiters more visibility into an internal employee’s current assignment details while reviewing a job application.

For example, recruiters may want to see information such as Person Number, Position, Job, Grade or Line Managerwithout leaving the application page.

Although there are different ways to achieve this requirement, they often require recruiters to navigate away from the application or rely on additional customisations. This not only interrupts the hiring process but also creates additional maintenance effort.

In this article, we’ll build a simple and scalable solution using Job Application Computed Fields, allowing assignment information to be displayed directly within the job application and even in the Job Application Grid.

The same approach can be extended to retrieve any assignment-related information based on your business requirements.

Click to Enlarge Images for Detailed Insight

Solution Overview

The solution is simple and uses standard Oracle Recruiting capabilities.

The candidate’s email available in the Recruiting Fast Formula is used to identify the employee record in Core HR. A table-validated value set retrieves the required assignment information, which is then returned by a Recruiting Job Application Computed Field Fast Formula and stored in an EFF segment.

The computed value can then be displayed:

  • Inside the Job Application
  • As a column in the Job Application Grid

Step 1: Create the EFF Context

Create a Single Row context under Person EIT Information and associate it with the Candidate Application usage.

Next, create the required read-only segments, for example:

Person Number, Position Name, Job Name, Grade Name and Line Manager Name.

You can easily extend the same solution to display additional assignment-related information whenever required.


Step 2: Create the Value Set and Fast Formula

To keep this article concise, we’ll use Person Number as an example.

Create a Table Validated Value Set that accepts the candidate’s email address and returns the corresponding Person Number.

Next, create a Recruiting Job Application Computed Field Fast Formula that:

  • Verifies the application is an internal application.
  • Reads the candidate email.
  • Calls the value set.
  • Returns the Person Number.

The same pattern can be reused for Position, Job, Grade, Manager or any other assignment information.

Value Set:

Fast Formula:


Step 3: Configure the Computed Field

Navigate to Job Application Computed Fields Configuration and map the Fast Formula to the corresponding EFF segment.

Once configured, run Calculate Computed Fields for the candidate application or configure the action within the Candidate Selection Process for automatic execution.

Job Application Computed Fields Configuration

Display the Information in the Job Application

After the calculation completes, the assignment information becomes available directly within the candidate application, giving recruiters immediate access to the employee’s current details.


Display the Information in the Job Application Grid

This is where the solution becomes even more valuable.

The computed fields are not limited to the application details page. They can also be added as columns in the Job Application Grid, allowing recruiters to compare multiple internal candidates without opening each application individually.

For example, the grid can display:

  • Person Number
  • Position
  • Job
  • Grade
  • Line Manager

This provides recruiters with the right information exactly where they need it, making the internal hiring process much more efficient.


Key Considerations

  • The candidate email must match the employee email stored in Core HR.
  • External candidates won’t return assignment information.
  • Computed fields are refreshed only after running Calculate Computed Fields.
  • The same approach can be reused for virtually any assignment-related information.

Conclusion

Job Application Computed Fields provide a clean and scalable way to enrich internal candidate applications with valuable employee information.

Instead of navigating between multiple pages or relying on additional customisations, recruiters can view the required assignment details directly within Oracle Recruiting and even from the Job Application Grid.

With just a few configurations, you can significantly improve the recruiter experience while building a reusable framework that can be extended for future business requirements.

Want the Complete Working Solution?

To keep this blog concise, I’ve demonstrated the solution using Person Number as an example.

The complete package includes ready-to-use Value Sets and Fast Formulas for:

  • Person Number
  • Position Name
  • Job Name
  • Grade Name
  • Line Manager Name

…and the same pattern can be extended to almost any assignment-related information.

If you’d like the complete working scripts, feel free to reach out to me on LinkedIn. I’m always happy to connect with fellow Oracle HCM professionals, discuss implementation ideas and share the complete solution.

🔗 Let’s connect on LinkedIn!


Discover more from FusionPathfinder

Subscribe to get the latest posts sent to your email.

Leave a Reply

Categories

FusionPathfinder

Exploring Oracle Fusion HCM – Insights and Journeys in Tech Transformation

Discover more from FusionPathfinder

Subscribe now to keep reading and get access to the full archive.

Continue reading