My Oracle Support Banner

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 and later
Information in this document applies to any platform.
FORM:ARXTWMAI.FMB - Transactions


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 ( (pc 794)
at org.apache.jserv.JServConnection.processRequest ( (pc 549)
at ( (pc 408)
at ( (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


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

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