My Oracle Support Banner

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:

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

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

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


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