My Oracle Support Banner

Hungary Localizations: CLE VAT Analytical and Recapitulative Statement(Preliminary) Request Set Error "APP-FND-01564: ORACLE error 1722 in FD" (Doc ID 2530524.1)

Last updated on DECEMBER 04, 2019

Applies to:

EMEA Add-on Localizations - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Reported Issue
-----------------
When trying to run  EMEA Localization for Hungary request set: CLE: VAT Analytical and Recapitulative Statement(Preliminary) which contain 4 concurrent programs namely 
EMEA VAT: Selection Process
CLE: Deferred Tax Selection Process
CLE:Analytical Vat Report
CLE: Domestic Recapitulative Statement VAT Report

is throwing an error .


Error message :
-------------------
app-fnd-01564: Oracle Error 1722 in FDFGVD
cause : FDFGVD failed due to ora-01722: invalid number

The sql statement being executed at the time of the error was

Select VAT_Reporting_entity_id , entity_identifier_Value,entity_identifier_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) from
jg_zz_Vat_Rep_entities where 1=1
and vat_Reporting_entity_id=X and was executed from the file
&ERRFILE.


Steps for replication 
----------------------
1.Select the Request set "CLE: VAT Analytical and Recapitulative Statement(Preliminary)"
2. Enter parameters for EMEA VAT Selection Process Concurrent 
3. On selecting parameters section for the next concurrent i.e. CLE: Deferred Tax Selection Process , it is throwing an error. 
4. Thereby unable to submit that concurrent request set itself. 

Expected Behavior
-------------------
Though concurrent requests when run as standalone allow parameter submission and complete normal , when submitting via request set it is throwing the aforementioned error.
System should equally allow the submission via request set.

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
References


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