My Oracle Support Banner

PERWSHRG: When attempting to update assignment error FRM-40350: query caused no records to be retrieved (Doc ID 1470380.1)

Last updated on DECEMBER 04, 2019

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 - applied applied 31-Jul-2010

When attempting to update assignment (promotional change), the following error occurs.


FRM-40350 query caused no records to be retrieved

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
press update
decision box
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

get error
please enter reason in miscellaneous tab

enter a reason
press update

4. do you want to use the location of the new organization ?

        press no

5. status bar indicates 2 records applied and saved

6. change effective date 29-05-1433
       get error
       FRM-40350 query caused to records to be retrieved

Data corruption has occured, assignment data has been deleted.




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.