Ex-employees Are Not Appearing In 'Assignment Process Results' Form, Error FRM-40212: Invalid value for field D_ASSIGNMENT_NUMBER

(Doc ID 1525249.1)

Last updated on MARCH 27, 2018

Applies to:

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


While trying to search an ex-employee in the 'Assignment Process Results' window, it does not return any results even with the current employee flag = 'ALL'.

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

1. Open 'Assignment Process Results' window
2. Query for ex-employee (eg ee# 644X8)
3. Click on Current Employee "All" checkbox


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms