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 APRIL 04, 2025
Applies to:
Oracle Bill Presentment Architecture - Version 12.1.3 and laterInformation 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: <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
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 |
Changes |
Cause |
Solution |