When Creating a New Contact For an Employee and Selecting an Existing Employee as the Contact, in Contact's Details Phone Number Form (PERWSPHN) Phones Type Does Not Have A List Of Values and Error Occur FRM-40350: Query caused no records to be retrieved
(Doc ID 2377590.1)
Last updated on MARCH 22, 2018
Applies to:Oracle Human Resources - Version 12.2.7 and later
Information in this document applies to any platform.
In Test instance.
On : 12.2.7 version, Person / Assignment Issues
When creating a new contact for an employee and selecting an existing employee as the contact, in Contact's Details Phone Number Form (PERWSPHN) Phones Type Does not have a List Of Values and
following error occurs.
FRM-40350 Query caused no records to be retrieved
FRM-40208 Form running in query-oly mode. cannot change database fields
The issue can be reproduced at will with the following steps:
1) Login in application
2) Select US Super HRMS Manager responsibility
3) People > Enter & Maintain
4) Query an employee
5) Navigate to Others > Contacts
6) Click on the list of values and find an existing employee
7) Add contact type
8) Click on the Contact's Details button
a) In LOV Select: Enter Phone Numbers
b) In Phone Number Form (PERWSPHN) click on Type LOV
c) Error: FRM-40350: Query caused no records to be retrieved
d) If click again on Type LOV
e) Error: FRM-40208 Form running in query-oly mode. cannot change database fields.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!