My Oracle Support Banner

Setting Up Quoting Defaulting Rule With Source As Application Profile Gives " ORA-24345: A Truncation or null fetch error occurred" (Doc ID 2185903.1)

Last updated on DECEMBER 03, 2019

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



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.