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 SEPTEMBER 23, 2016

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

Symptoms

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

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...

STEPS
-----------------------
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

 

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