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.
Symptoms
- Unable to search suppliers having apostrophes in the supplier name value
- Supplier Entry / Inquiry Search cannot handle apostrophes
For example, when trying to query for "x'" supplier, when clicking on Go button the page fails with:
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".
Menu: Suppliers / Entry
Go on Supplier Name field, enter x' and click on Go button.
Page fails.
Cause
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
Symptoms |
Cause |
Solution |
References |