E-PUM: Create Views SUP_PROF_ALL and SUP_PROF_QSTVW Fails on FSCM 9.2 PUM Image 32 Fresh Install and Maintenance When Running on MSSQL (Doc ID 2558211.1)

Last updated on APRIL 09, 2023

Applies to:

Symptoms

On : 8.57.07 version, Install and Maintenance, FSCM 9.2.032, MSSQL

When attempting to do a FRESH install of FSCM 9.2.0.32 or APPLYING a Change Package from FSCM 9.2.0.32, the following error occurs:

ERROR
-----------------------
Creating View  SUP_PROF_ALL
- SQL Error. Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'PS_SAMDIFF_ERROR' is not a recognized built-in function name.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'PS_SAMDIFF_ERROR' is not a recognized built-in function name.

CREATE VIEW PS_SUP_PROF_ALL (SETID, VENDOR_ID, QUESTION_ID, BID_FACTOR_TYPE, COMMENTS_2000, REQUIRED_FLG, RESPONSE_DESCR) AS SELECT A.SETID ,A.VENDOR_ID , A.QUESTION_ID , P.BID_FACTOR_TYPE ,PS_SAMDIFF_ERROR('CAST: Invalid number of parameters') ,P.REQUIRED_FLG ,A.RESPONSE_DESCR FROM PS_SUP_PROF_RESP A ,PS_SUP_PROFILE_QST P WHERE A.QUESTION_ID = P.QUESTION_ID AND BID_FACTOR_TYPE NOT IN ('L','M','N') UNION SELECT B.SETID ,B.VENDOR_ID ,B.QUESTION_ID ,C.BID_FACTOR_TYPE ,PS_SAMDIFF_ERROR('CAST: Invalid number of parameters') ,C.REQUIRED_FLG , ( SELECT PV.ATTACHUSERFILE FROM PS_PV_ATTACHMENTS PV WHERE PV.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND PV.ATT_VERSION = B.ATT_VERSION) FROM PS_SUP_PRF_RSP_ATT B , PS_SUP_PROFILE_QST C WHERE B.Q...
Error: Unable to process create statement for SUP_PROF_ALL

Creating View  SUP_PROF_QSTVW
- SQL Error. Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'PS_SAMDIFF_ERROR' is not a recognized built-in function name.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'PS_SAMDIFF_ERROR' is not a recognized built-in function name.

CREATE VIEW PS_SUP_PROF_QSTVW (QUESTION_ID, DESCR254, BID_FACTOR_TYPE1, SUP_CONTACT_TYPE1, REQUIRED_FLG) AS  SELECT A.QUESTION_ID , PS_SAMDIFF_ERROR('CAST: Invalid number of parameters') ,B.XLATLONGNAME ,C.XLATLONGNAME , A.REQUIRED_FLG FROM PS_SUP_PROFILE_QST A ,PSXLATITEM B ,PSXLATITEM C WHERE A.BID_FACTOR_TYPE = B.FIELDVALUE AND B.FIELDNAME = 'BID_FACTOR_TYPE' AND A.SUP_CONTACT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'SUP_CONTACT_TYPE' AND BID_FACTOR_TYPE <> 'S' AND BID_FACTOR_TYPE <> 'M' UNION SELECT A.QUESTION_ID ,PS_SAMDIFF_ERROR('CAST: Invalid number of parameters') ,( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 10320 AND MESSAGE_NBR = 211),C.XLATLONGNAME , A.REQUIRED_FLG FROM PS_SUP_PROFILE_QST A,PSX...
Error: Unable to process create statement for SUP_PROF_QSTVW

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the create view step

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.