My Oracle Support Banner

JBO-27122 Error After Cancel During Supplier Registration Address Review (Doc ID 2240280.1)

Last updated on FEBRUARY 26, 2019

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:

Error Page

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 SupplierRegEO.SUPPLIER_NAME,
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.