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!