My Oracle Support Banner

Unable To Query Assignment Process Results For Ex-Employee With Updates In Person (Doc ID 1922765.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : 12.1.3 version, Core Payroll - General

When a change is made to the person level details after the termination date, unable to query the terminated employee on the view Assignment Process Results
the following error occurs.

FRM 40212 Invalid value for field D_ASSIGNMENT_NUMBER

The issue can be reproduced at will with the following steps:
1.Super HRMS Manager
3.Assignment Process Results.
4.Enter assignment number or employee name.
5.Error/warning in the message bar at the bottom of the form.
6.It just returns no results and the message is displayed in the message bar.

The issue has the following business impact:
Due to this issue, users cannot query a terminated employee under View Assignment Process Results


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.