Error: APP-FND-01564: Oracle Error 24345 in fdlget error message(s) when Setting Profile: OM: Notification Approver. (Doc ID 2227933.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle Order Management - Version 12.1.1 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Why attempting to set profile option : OM: Notification Approver following error occurs.

Error:
-------
APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A Truncation or null fetch error occurred.

The SQL statement being executed at the time of the error was:
SELECT NAME, DISPLAY_NAME||"('|NAME||') ' EXPAND_NAME
FROM WF_ROLES ORDER BY DISPLAY_NAME and was executed from the file &ERRFILE.

STEPS:
1. log Into System Administrator Responsibility
2. Navigate to Profile Option > System
3. Try to setup the value for the profile Option OM: Notification Approver

Changes

 

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