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 DECEMBER 05, 2019

Applies to:

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: <TEMPLATE_NAME>
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.

Changes

Cause

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