Setting Up Quoting Defaulting Rule With Source As Application Profile Gives " ORA-24345: A Truncation or null fetch error occurred"
Last updated on FEBRUARY 24, 2018
Applies to:Oracle Quoting - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.
defaulting, defaulting rules, quoting defaulting rules
While creating defaulting rules to be used in Oracle Quoting for the Quote Header level.
Trying to Use Application Profile as Source Type.
Once we select the same and progress to select Profile Option then we encounter an error APP-FND-01564
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...
The issue can be reproduced at will with the following steps:
1. Login as the Quoting Sales Manager
2. Select Defaulting Rules from the Setup functions
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