My Oracle Support Banner

Full List In Sourcing Home Page Errors With oracle.jbo.SQLStmtException: JBO-27122 ORA-01422: exact fetch returns more than requested number of rows (Doc ID 1934010.1)

Last updated on SEPTEMBER 13, 2022

Applies to:

Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to use the Full list of Negotiations, on the Sourcing Home page the following error occurs:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (select ah.auction_header_id,
auction_auction_header_id, ah.auction_title auction_title,
fl1.meaning auction_type,PON_AUCTION_PKG.TIME_REMAINING(ah.auction_header_id)
(to_char(nvl(ah.number_of_bids, 0))) as bids_num,
(fl2.meaning || decode (ah.bid_visibility_code, 'SEALED_AUCTION', '(' ||
fl3.meaning || ')', ''))
status, ah.created_by_full_name CreatedBy,
ah.bid_visibility_code,ah.sealed_auction_status, ah.trading_partner_id, :4,
ah.has_items_flag, doc.internal_name, ah.auction_status, ah.view_by_date,
ah.open_bidding_date)) as monitor_switch,
at oracle.jdbc.ttc7.Oall7.receive(
## Detail 0 ##
java.sql.SQLException: ORA-01422: exact fetch returns more than requested
number of rows
ORA-06512: at "APPS.PON_AUCTION_PKG", line 8902
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.ttc7.TTIoer.processError(

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to : Sourcing Buyer Home Page
2. Click: "Full List" button to view all the Negotiations

Encounter the error


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.