My Oracle Support Banner

"JBO-27122: SQL error during statement preparation" and "ORA-01417: a table may be outer joined to at most one other table" Error When Searching a RFQ by Description (Doc ID 2499525.1)

Last updated on MAY 25, 2019

Applies to:

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

Symptoms

On : 12.2.6 version, Auction/RFx creation

When attempting to search a RFQ by Line Description, the following error occurs:

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct 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(decode(nvl(ah.two_part_flag, 'N' ), 'N' ,nvl(ah.number_of_bids, 0),'Y',
  (
  SELECT count(pbd.bid_number)
  FROM pon_bid_headers pbd,pon_auction_headers_all paha
  WHERE pbd.auction_header_id=ah.auction_header_id
  AND pbd.auction_header_id = paha.auction_header_id
  AND nvl2(pbd.submit_stage,decode(paha.technical_evaluation_status, null, 'TECHNICAL','NOT_COMPLETED','TECHNICAL','COMPLETED',decode(paha.sealed_auction_status,'LOCKED','TECHNICAL','COMMERCIAL')),'-9999') = nvl(pbd.submit_stage,'-9999')
  AND PBD.BID_STATUS IN ('ACTIVE', 'DISQUALIFIED', 'ARCHIVED', 'RESUBMISSION')

...
...
## Detail 0 ##
java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table

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)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
...
...




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Sourcing Home Page
2. Search by Line Description
3. Enter Line Description and click Go
4. Error appears:
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.

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.