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 JANUARY 28, 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.


Changes

 

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
Changes
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.