Unable To Assign Asset Attributes Due to Error FRM-40350 Query Caused No Records To Be Retrieved

(Doc ID 2329658.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to assign attributes to asset number, 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. Responsibility: Enterprise Asset Management.
2. Go to Assets –> Asset Numbers –> Asset Numbers.
3. Query asset number.
4. Go to Attributes.
5. Click on the list of values to show the contexts previously defined in Flexfield: “Asset Attributes”.
6. Receive the aforementioned error.


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