My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Inventory Management - Version: 12.1.2 and later   [Release: 12.1 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
>" /> Video - Transaction Register Error (01:52)

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.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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