Printing Custom BPA Template Error SQLStmtException JBO-27122 SQL Error During Statement Preparation (Doc ID 725839.1)

Last updated on OCTOBER 16, 2018

Applies to:

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

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