JBO-27122 Error After Cancel During Supplier Registration Address Review
(Doc ID 2240280.1)
Last updated on JULY 26, 2018
Applies to:Oracle iSupplier Portal - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
When trying to create / update an address during the Supplier registration, the following error occurs:
You have encountered an unexpected error. Please contact the System Administrator for assistance
Click: "here" for exception details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT SupplierRegEO.SUPPLIER_NAME,
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Sign on to Application, and navigate to Purchasing Super User / Purchasing Buyer / Buyer Work Center / Suppliers / New Supplier Request
Navigate to Prospective registration page for supplier
2. For Address Book / Address information click: Create Button and/or Update Button
3. Click Cancel button in Create/Update Address page
4. Try to navigate again to Prospective registration page or to Create/Update Address page
The Create Address page renders but shows the unexpected error and exception in the bottom of the same page, and all the links are disabled.
The issue started to occur after applying <Patch 23175913:R12.POS.B>
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