My Oracle Support Banner

R12: Supplier Entry/Inquiry Cannot Handle Apostrophes: JBO-27122: SQL error during statement preparation and ORA-911: invalid character (Doc ID 1287156.1)

Last updated on JULY 27, 2023

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Oracle iSupplier Portal - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


For example, when trying to query for "x'" supplier, when clicking on Go button the page fails with:

You have encountered an unexpected error. Please contact the System Administrator for assistance. 
Click here for exception details. 

Exception details:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
  JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM
  (select hp.party_name,
  hp.party_id as party_id,
  hp.duns_number_c as duns,
  'FOREIGN INDIVIDUAL',pv.individual_1099, pv.num_1099) taxpayer_id,...........

at oracle.apps.fnd.framework.OAException.wrapperException(
java.sql.SQLSyntaxErrorException: ORA-911: invalid character

 Steps to reproduce:

Responsibility "Payables, Vision Operations".
Menu: Suppliers / Entry
Go on Supplier Name field, enter x' and click on Go button.
Page fails.


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.