My Oracle Support Banner

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.

Symptoms

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.

ERROR
-----------------------
FRM-40350 Query caused no records to be retrieved
FRM-40208 Form running in query-oly mode. cannot change database fields


STEPS
-----------------------
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) Save
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.

Cause

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.