PERWSHRG: When attempting to update assignment error FRM-40350: query caused no records to be retrieved
Last updated on JUNE 06, 2018
Applies to:Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.
***Relevancy checked 10-Jan-2014***
On : 12.1.1 version, Person / Assignment Issues
Patch:7446767 - R12.HR_PF.B.delta.1 applied R12.ATG_PF.B.delta.1 applied 31-Jul-2010
When attempting to update assignment (promotional change), the following error occurs.
The issue can be reproduced at will with the following steps:
1. people -> enter and maintain -> assignment
2. datetrack to future date 01-06-1433
change organization and other data
do you want this update to be regarded as a promotional change ?
select yes to update the record with the previous promotion reason and select no to clear the promotion reason in the reason field
3. user presses no
please enter reason in miscellaneous tab
enter a reason
4. do you want to use the location of the new organization ?
5. status bar indicates 2 records applied and saved
6. change effective date 29-05-1433
FRM-40350 query caused to records to be retrieved
Data corruption has occured, assignment data has been deleted.
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