Last updated on MARCH 21, 2017
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>
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms