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

Last updated on FEBRUARY 20, 2019

Applies to:

Symptoms

Problem Statement
 Supplier user clicks the "Disqualified and Withdrawn" link and gets an unexpected error in Oracle Sourcing.


Error
 You have encountered an unexpected 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 <NUMBER> and publish it.
     Controls : Allow Quote Withdrawal
2. Supplier user login and create a Quote <QUOTE 1> for the RFQ <NUMBER>.
3. Supplier user withdraw the quote
   Action LOV "Withdraw Quote", click Go.
4. Buyer confirm the Quote History (RFQ <NUMBER>), the status is "Withdrawn"
   Click All Responses in the Published Negotiations.
5. Supplier user Click "Disqualified and Withdrawn" and click the Response Number <QUOTE 1> link,
   select "Create Quote" and Go, to create a new Quote <QUOTE 2>.
6. Buyer confirm the Quote History (RFQ <NUMBER>), Click All Responses in the Published Negotiations.
     <QUOTE 2> Active
     <QUOTE 1> Withdrawn
7. Disqualify the new active quote <QUOTE 2>, the status is "Disqualified".
8. Supplier user Click "Disqualified and Withdrawn" and click the Response Number <QUOTE 2> link,
   select "Create Quote" and Go, to create a new Quote <QUOTE 3>.
9. Supplier user Click "Disqualified and Withdrawn" and the error page shows.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.