XML Data Generation Failed For Dispute Confirmation (Doc ID 1546847.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Advanced Collections - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Dispute Confirmation send fails with XML Data Generation Failed


GetXmlData: l_dataHdrQry :SELECT XMLElement("DISPUTE_ID",'18001')||XMLElement("PARTY_ID",'8951')||XMLElement("LOCATION_ID",'53740')||XMLElement("CONTACT_ID",'null')|| '' FROM DUAL
The XML DataHeader is 18001895153740null
GetXmlData: getXml
GetXmlData: Exc_Error:ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException
iexvxmlb.pls:SEND_COPY: End GetXmlData...
iexvxmlb.pls:SEND_COPY: l_return_status=E
iexvxmlb.pls:SEND_COPY: error to get XML data
iexvxmlb.pls:SEND_COPY: Exc_Error:User-Defined Exception
"iextxmlb.pls:update_row:Exception errmsg=ORA-01403: no data found
ORA-06510: PL/SQL: unhandled user-defined exception"
IEX_DUNNING_PVT Send_XML - After SEND_COPY:E
IEX_DUNNING_PVT Send_XML - l_return_status=E
IEX_DUNNING_PVT Send_XML - l_msg: IEX


XMLGEN synonyms are ok, since the results of the following are in XML format

SELECT DBMS_XMLGEN.getXML('SELECT * FROM FND_USER WHERE USER_ID = 0') FROM dual;

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