Exception Occurs When Clicking On Full List Button On Sourcing Home Page (Doc ID 562755.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Sourcing - Version: 11.5.10 to 12.0.6 - Release: 11.5 to 12
Information in this document applies to any platform.

Symptoms

Problem Statement:
On 11.5.10 in Production:

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)

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

3. Receive the following error: 'You have encountered an unexpected error . Please contact the system administrator for assistance'.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

## 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)

Business Impact:
The issue has the following business impact:
Due to this issue, users cannot use the Full list of Negotiations in Sourcing .

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