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 SEPTEMBER 06, 2016

Applies to:

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

Symptoms

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,
  pv.vendor_id,
  pv.vendor_name,
  decode(pv.organization_type_lookup_code,
  'INDIVIDUAL',pv.individual_1099,
  'FOREIGN INDIVIDUAL',pv.individual_1099, pv.num_1099) taxpayer_id,...........

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

 Steps to reproduce:

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

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