My Oracle Support Banner

Can Not Search Future Dated Re-Hire Employee (Doc ID 2103368.1)

Last updated on APRIL 09, 2021

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to search future dated re-hiring employee under dynamic security profile, the following error occurs

FRM-40212: Invalid value for field NUMBER


Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1. Use dynamic security profile and set up the profile option "HR: Access Non-Current Employee Data" as the value "Yes"
  2. Alter Effective Date as future dated like 05-FEB-XXXX (Sysdate is 04-FEB-XXXX)
     (N) People -> Enter and Maintain
  3. Select the "Create Employment" in "Action" field to re-hire ex-employee as a future dated
  4. After closing application and re-open and then try to search the employee
  5. can see above error messages
  6.  Please note that we can search the employee if sysdate becomes 05-FEB-XXXX


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.