Printing Custom BPA Template Error SQLStmtException JBO-27122 SQL Error During Statement Preparation
(Doc ID 725839.1)
Last updated on MARCH 14, 2022
Applies to:
Oracle Bill Presentment Architecture - Version 11.5.10.2 and laterInformation in this document applies to any platform.
FORM:ARXTWMAI.FMB - Transactions
Symptoms
Printing a custom template in Bill Presentment (the print preview PDF) stopped all of the sudden and gives an error message. "An error occurred while generating the PDF"
Checked log shows following:
oracle.apps.fnd.framework.OAException: An error occurred while generating the PDF. Review the log files for more information and contact your system administrator.
at oracle.apps.ar.bpa.presentment.webui.PageCO.showPdf (PageCO.java:195) (pc 794)
...
at org.apache.jserv.JServConnection.processRequest (JServConnection.java:456) (pc 549)
at org.apache.jserv.JServConnection.run (JServConnection.java:294) (pc 408)
at java.lang.Thread.run (Thread.java:479) (pc 11)
## Detail 0 ##
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
trx.customer_trx_id customer_trx_id,
nvl(tl.sequence_num,1) term_sequence_number,
trx.trx_number trx_number,
trx.trx_date trx_date, ....
Note: above SQL script is very large
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 |
Cause |
Solution |
References |