My Oracle Support Banner

Transaction Register: APP-FND-01564: Oracle Error 24345 In Fdlget (Doc ID 1340809.1)

Last updated on OCTOBER 01, 2019

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.
Report:INVTRREG.RDF - Transaction register


Symptoms

The Transaction register concurrent program's ‘Transaction Type Low’ or ‘Transaction Type High’ parameter raise an error.

Error
APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A truncation or null fetch occurred.
The SQL statement being executed at the time of the error was: SELECT TRANSACTION_TYPE_NAME, TRANSACTION_TYPE_NAME VALUE, DESCRIPTION, NVL('N','N')...
FROM MTL_TRANSACTION_TYPES WHERE 1=1
ORDER BY TRANSACTION_TYPE_NAME,3
and was executed from the file &ERRFILE.

Steps


1. Navigate to Submit Request
2. Enter the Name: "Transaction register" program
3. Enter the parameters including Sort by: Transaction Type, Unit of Measure: Primary
4. Enter the Transaction Type Low or High
5. Receive the error.

Workaround
Can enter S% (or some limiting values) and shows values.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Patching
 Workaround
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.