My Oracle Support Banner

Error: "Fdlget Failed Due To ORA-00942: Table Or View Does Not Exist" While Querying CLE% Profile Options (Doc ID 3011173.1)

Last updated on MARCH 24, 2024

Applies to:

Oracle Financials for EMEA - Version 12.2 and later
Information in this document applies to any platform.


When attempting to search for profile option CLE%,
the following error occurs on Forms.

APP-FND-01564: ORACLE error 942 in fdlget
Cause: fdlget failed due to ORA-00942: table or view does not exist

The issue can be reproduced at will with the following steps:
1. Go to System Administrator -> Profile-> System
2. Query for Profile option name as CLE%
3. Multiple times this error coming for all profile options


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.