R12 Bills Presentment Architecture (BPA) Print Invoices for an External Template Shows Error "Invalid Character Exception in thread Thread-9” (Doc ID 2024585.1)

Last updated on OCTOBER 20, 2016

Applies to:

Oracle Bill Presentment Architecture - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


On : 12.1.3 version, Bill Printing

You are attempting to print Bill Presentment Architecture (BPA) Invoices for an External Template and receive the following error:

ERROR
-----------------------
Exception in thread "Thread-9" oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.xml.parser.v2.XMLDOMException: invalid character ( in name;

** Main Error To Concern : [java.sql.SQLException: ORA-01000: maximum open cursors exceeded]

Log File Shows:

PrintInvoiceThread.getTemplateId()-
Unexpected Error for the following transaction:
TrxNumber: 21 || templateId: 10794 || templateName: CCL UK INVOICE I10333 RTF
Exception in thread "Thread-9" oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.xml.parser.v2.XMLDOMException: invalid character ( in name;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.ar.bpa.presentment.cp.PrintInvoiceThread.buildXml(PrintInvoiceThread.java:535)
at oracle.apps.ar.bpa.presentment.cp.PrintInvoiceThread.run(PrintInvoiceThread.java:130)
## Detail 0 ##
oracle.xml.parser.v2.XMLDOMException: invalid character ( in name
at oracle.xml.util.XMLUtil.validateName(XMLUtil.java:447)
at oracle.xml.parser.v2.XMLDocument.createElement(XMLDocument.java:716)
at oracle.apps.ar.bpa.presentment.util.InvoiceXMLBuilder.getXML(InvoiceXMLBuilder.java:573)
at oracle.apps.ar.bpa.presentment.cp.PrintInvoiceThread.buildXml(PrintInvoiceThread.java:486)
at oracle.apps.ar.bpa.presentment.cp.PrintInvoiceThread.run(PrintInvoiceThread.java:130)

SQL_PLSQL_ERROR (ERRNO=604) (REASON=java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-06508: PL/SQL: could not find program unit being called: "APPS.APP_EXCEPTION"
ORA-06512: at "APPS.FND_GLOBAL", line 271
ORA-06512: at "APPS.FND_GLOBAL", line 1575
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-06508: PL/SQL: could not find program unit being called: "APPS.APP_EXCEPTION"

Steps to Reproduce:
Responsibility:  Receivables
Try to upload BPA template
Verify if system prompts error.

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