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

Last updated on MARCH 31, 2017

Applies to:

Oracle Bill Presentment Architecture - Version 11.5.10.2 and later
Information 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

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