My Oracle Support Banner

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 AUGUST 20, 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


To view full details, 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 a vibrant support community of peers and Oracle experts.