PERWSHRG: When attempting to update assignment error FRM-40350: query caused no records to be retrieved

(Doc ID 1470380.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.
***Relevancy checked 10-Jan-2014***

Symptoms

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.

ERROR
------------

FRM-40350 query caused no records to be retrieved


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

1. people -> enter and maintain -> assignment
    01-03-1431
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.

Cause

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