Applying Update Error CREATE VIEW PS_SCD_TOPN_SUP_VW Failed With ORA-00904: "SCD_VNDSEL_TM_FRM": Invalid Id
(Doc ID 2667000.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When applying <Bug 30849858> get error via Change Assistant, create views has error:
SQL> CREATE VIEW PS_SCD_TOPN_SUP_VW (ROWNBR, SCD_EVALTEE_SETID,
SCD_EVALUATEE_ID, SCD_SCORE, LASTUPDDTTM) AS SELECT ROWNUM AS ROWNBR
,T.SCD_EVALTEE_SETID ,T.SCD_EVALUATEE_ID ,T.SCD_SCORE ,T.LASTUPDDTTM
FROM ( SELECT A.SCD_EVALTEE_SETID ,A.SCD_EVALUATEE_ID ,B.SCD_SCORE
,A.LASTUPDDTTM FROM PS_SCD_EVLPST_STAT A INNER JOIN PS_SCD_BLD_EVAL_HD
B ON A.SCD_LST_POST_EVLID = B.SCD_EVALUATION_ID WHERE A.LASTUPDDTTM
BETWEEN ( SELECT SYSDATE - SCD_VNDSEL_TM_FRM FROM PS_INSTALLATION_SC)
AND SYSDATE ORDER BY A.LASTUPDDTTM DESC ) T /
BETWEEN ( SELECT SYSDATE - SCD_VNDSEL_TM_FRM FROM PS_INSTALLATION_SC)
*
ERROR at line 7:
ORA-00904: "SCD_VNDSEL_TM_FRM": invalid identifier
Apply 30849858 from PUM35 (PRP 26355789) via Change assistant
Steps to Reproduce Issue:
Apply fix for <Bug 30849858>
Changes
Not applicable.
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 |