APP-FND-01564 ORA-24345 Cross Currency Exchange Gain/Loss Report (Doc ID 472308.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms


When attempting to Run Report "Cross Currency Exchange Gain/Loss Report"
When click on Customer Name LOV of Parameters the following error occurs.

ERROR
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,
PARTY.PARTY_NAME DESCRIPTION,NVL('N','N'),
NVL(TO_NUMBER(NULL),-1),NULL,NVL('Y','Y'),
NVL(TO_CHAR(TO_DATE(NULL), 'J'),0),
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


STEPS
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

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