JEBEVA17_XMLP Ends In Error When No Data Available (Doc ID 1942037.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Financials for EMEA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Belgian Localizations for AP

When attempting to run the JEBEVA17_XMLP module: Belgian VAT Annual Audit Report for a year where there is no data
the following error occurs:

ERROR
-----------------------
Calling XDO Data Engine...
oracle.apps.xdo.XDOException: !!Error : trigger 'beforeReportTrigger' returns status as 'false'
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:654)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Error in beforeReport trigger of JG_ZZ_AUDIT_AR_PKG package. Error-100ORA-01403: no data found
+---------------------------------------------------------------------------+


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run JEBEVA17_XMLP module: Belgian VAT Annual Audit Report


Changes

 

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