Last updated on AUGUST 24, 2016
Applies to:Oracle Receivables - Version 22.214.171.124 and later
Information in this document applies to any platform.
When attempting to Run Report "Cross Currency Exchange Gain/Loss Report"
When click on Customer Name LOV of Parameters the following error occurs.
APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A truncation or null fetch error occured
The SQL being executed at the time of error was:
SELECT CA.CUST_ACCOUNT_ID,PARTY.PARTY_NAME VALUE,
NVL(TO_CHAR(TO_DATE(NULL), 'J'),0),CA.ACCOUNT_NUMBER "Customer Number",
PARTY.JGZZ_FISCAL_CODE "Fiscal Code",
PARTY.TAX_REFERENCE "VAT Number" FROM HZ_CUST_ACCOUNTS CA,
HZ_PARTIES PARTY WHERE (CA.PARTY_ID=PARTY.PARTY_ID) AND
UPPER(PARTY.PARTY_NAME) LIKE UPPER(:A00) || '%' ORDER BY PARTY.PARTY_NAME,3
was executed from the file &ERRFILE
The issue can be reproduced at will with the following steps:
1. View==>Request==>Submit new request==>Single Report==>
Report Name : Cross Currency Exchange Gain/Loss Report
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms