Supplier User Click "Disqualified and Withdrawn" Link and Get an Unexpected Error in Oracle Sourcing (Doc ID 2174420.1)

Last updated on MARCH 16, 2017

Applies to:

Symptoms

Problem Statement
 Supplier user click the "Disqualified and Withdrawn" link, the Error page was showed and received an unexpected error in Oracle Sourcing.


Error
 You have encountered an unexpanded error.

 Exception Details
   oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
   JBO-27122: SQL error during statement preparation. Statement: select auc.auction_header_id,
   ...
   bid_inner.old_bid_number = bid.bid_number AND bid_inner.bid_status <> 'DRAFT') has_revised_resp,
   ...
   ## Detail 0 ##
   java.sql.SQLException: ORA-01427: Single-row Subquery Returns More Than One Row

Steps to Reproduce

1. Buyer create a RFQ 69648 and publish it.
     Controls : Allow Quote Withdrawal
2. Supplier user login and create a Quote (32168) by the RFQ 69648.
3. Supplier user withdraw the quote
   Action LOV "Withdraw Quote", click Go.
4. Buyer confirm the Quote History (RFQ 69648), the status is "Withdrawn"
   Click All Responses in the Published Negotiations.
5. Supplier user Click "Disqualified and Withdrawn" and click the Response Number 32168 link,
   select "Create Quote" and Go, to create a new Quote (32169).
6. Buyer confirm the Quote History (RFQ 69648), Click All Responses in the Published Negotiations.
     32169 Active
     32168 Withdrawn
7. Disqualify the new active quote (32169), the status is "Disqualified".
8. Supplier user Click "Disqualified and Withdrawn" and click the Response Number 32169 link,
   select "Create Quote" and Go, to create a new Quote (32170).
9. Supplier user Click "Disqualified and Withdrawn" and the error page show.

Cause