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

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.

Symptoms

When trying to create / update an address during the Supplier registration, the following error occurs:

ERROR:
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

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
OR
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.


Changes

The issue started to occur after applying <Patch 23175913:R12.POS.B>

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