Log On To Supplier Portal As Bidder, Click On View Events And Place Bid Menu, Get SQL Error (Doc ID 1963581.1)

Last updated on NOVEMBER 14, 2016

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Bid Responses in Supplier Portal

Log on to Supplier portal as bidder, click on View Events and Place Bid menu, get error message "A SQL error has occurred":

SQL statement "SELECT 'X' FROM DUAL"

  Return: 601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'DUAL'.

  Statement: SELECT FILL.BUSINESS_UNIT,FILL.AUC_ID,FILL.AUC_ROUND,FILL.AUC_VERSION,FILL.AUC_ID_BUS_UNIT,FILL.AUC_FORMAT,FILL.AUC_TYPE,FILL.AUC_NAME,FILL.AUC_STATUS,FILL.TIMEZONE,FILL.AUC_DTTM_PREVIEW,FILL.AUC_DTTM_START,FILL.AUC_DTTM_FINISH,FILL.PYMNT_TERMS_CD,FILL.CURRENCY_CD,FILL.ORIGIN,FILL.BLIND_FLG,FILL.AUC_PRELIM_BID,FILL.AUC_EDIT_RESP,FILL.AUC_SCORE_RFI,FILL.CATEGORY_ID,FILL.AUC_CREATE_XML_FLG,FILL.AUC_DISP_AWD_DET,FILL.AUC_DSP_WIN_SCORE FROM PS_RESP_INQA_HD_VW FILL , PS_AUC_HDR V2 , PS_AUC_HDR V3 WHERE FILL.BUSINESS_UNIT = V2.BUSINESS_UNIT AND FILL.AUC_ID = V2.AUC_ID AND FILL.AUC_ROUND = V2.AUC_ROUND AND FILL.AUC_VERSION = V2.AUC_VERSION AND FILL.BUSINESS_UNIT = V3.BUSINESS_UNIT AND FILL.AUC_ID = V3.AUC_ID AND FILL.AUC_ROUND = V3.AUC_ROUND AND FILL.AUC_VERSION = V3.AUC_VERSION AND FILL.AUC_STATUS IN ( 'A', 'P', 'T' ,'U' ,'F', 'I', 'Q') AND (FILL.AUC_DTTM_PREVIEW = '2014-11-05 01:01:01.000' AND EXISTS ( SELECT 'X' FROM PS_AUC_DISP_HDR X1 WHERE X1.BUSINESS_UNIT = FILL.BUSINESS_UNIT AND X1.AUC_ID= FILL.AUC_ID AND X1.AUC_ROUND = FILL.AUC_ROUND AND X1.AUC_VERSION = FILL.AUC_VERSION AND ((X1.BIDDER_TYPE = 'P' ) OR (X1.BIDDER_TYPE = 'B' AND X1.BIDDER_SETID = 'ALACO' AND X1.BIDDER_ID = '0000000304') ) ) AND EXISTS ( SELECT 'X' FROM DUAL) AND EXISTS ( SELECT 'X' FROM PS_AUC_DISP_ADR_VW Y1,PS_AUC_USER_CONTCT Y2 WHERE Y1.BUSINESS_UNIT = FILL.BUSINESS_UNIT AND Y1.AUC_ID= FILL.AUC_ID AND Y1.AUC_ROUND = FILL.AUC_ROUND AND Y1.AUC_VERSION = FILL.AUC_VERSION AND ((Y1.BIDDER_TYPE = 'P' ) OR (Y1.BIDD

ERROR
-----------------------
  Return: 601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'DUAL'.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log on to Supplier portal as bidder
2. click on View Events and Place Bid menu


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view and place bids..

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