JBO-27122 Error While Performing RFQ Award Summary Action (Doc ID 2161037.1)

Last updated on AUGUST 31, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Awards

When attempting to award a negotiation, performing the action 'Award Summary'
shows the following error.


ERROR
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select BidHeadersEO.BID_NUMBER
, BidHeadersEO.AUCTION_HEADER_ID
, BidHeadersEO.TRADING_PARTNER_NAME
, BidHeadersEO.TRADING_PARTNER_ID
, BidHeadersEO.TRADING_PARTNER_CONTACT_ID
, BidHeadersEO.EMAIL
, 'N' AS HIDE_SHOW
, (SELECT sum(bl.price * nvl(bl.quantity, 1))
  FROM pon_bid_item_prices bl, pon_auction_item_prices_all ai
  WHERE bl.bid_number = BidHeadersEO.bid_number and ai.auction_header_id = bl.auction_header_id and ai.line_number = bl.line_number and ai.group_type in ('LINE', 'LOT', 'GROUP_LINE')
  ) as QUOTE_TOTAL
, BidHeadersEO.total_award_amount as AWARD_TOTAL
, BidHeadersEO.INTERNAL_NOTE
.
.
.
## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
.
.


STEPS
The issue can be reproduced at will with the following steps:
1. Navigate to Sourcing responsibility.
2. Create a 2 stage RFQ.
3. Create Award.
4. Perform action 'Award Summary'.
5. Error is shown.



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