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 FEBRUARY 02, 2024
Applies to:
Oracle Sourcing - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to use the Full list of Negotiations, on the Sourcing Home page the following error occurs:
ERROR:
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)
timeleft,
(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,
(PON_OA_UTIL_PKG.BUYER_MONITOR_IMAGE(ah.doctype_id,
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(Oall7.java:589)
etc..
## 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(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
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)
timeleft,
(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,
(PON_OA_UTIL_PKG.BUYER_MONITOR_IMAGE(ah.doctype_id,
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(Oall7.java:589)
etc..
## 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(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
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
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |