Transaction Register: APP-FND-01564: Oracle Error 24345 In Fdlget [Video]

(Doc ID 1340809.1)

Last updated on MARCH 08, 2017

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

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