My Oracle Support Banner

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 FEBRUARY 06, 2019

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

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.