My Oracle Support Banner

E:CA - Is There A Recommended User Id To Use When Applying PUMS, (Doc ID 2542794.1)

Last updated on NOVEMBER 12, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Goal

Your question has to do with the items in this script that have a hardcoded where clause of "WHERE OPRID = 'VP1'"

such as:

 CREATE VIEW PS_AR_ALIST_FIL_VW (FILTER_NBR, DESCR) AS SELECT
 FILTER_NBR , DESCR FROM PS_AR_ALIST_FILTER WHERE OPRID = 'VP1'

or

CREATE VIEW PS_EOPC_COMP_SRCH (OPRID) AS SELECT OPRID FROM PSOPRDEFN
 WHERE OPRID = 'VP1'

or

CREATE VIEW PS_SJ_JRNL_TMPL_VW (SJ_JOURNAL_TYPE, SJ_TEMPLATE_ID,
 CF_SECURITY, OPRID, ROLENAME, OPRCLASS) AS SELECT DISTINCT
 A.SJ_JOURNAL_TYPE , A.SJ_TEMPLATE_ID , A.CF_SECURITY , C.OPRID ,
 C.ROLENAME , C.OPRCLASS FROM PS_SJ_JRNL_TMPLT A , PS_SJ_JRNL_HDR_DEF
 B , PS_SJ_JRNL_TMP_SEC C WHERE A.SJ_JOURNAL_TYPE = B.SJ_JOURNAL_TYPE
 AND A.SJ_TEMPLATE_ID = B.SJ_TEMPLATE_ID AND A.SJ_JOURNAL_TYPE =
 C.SJ_JOURNAL_TYPE AND A.SJ_TEMPLATE_ID = C.SJ_TEMPLATE_ID AND
 (C.OPRID = 'VP1' OR A.CF_SECURITY = '0' OR C.ROLENAME IN ( SELECT
 ROLENAME FROM PSROLEUSER WHERE ROLEUSER = 'VP1') OR C.OPRCLASS IN (
 SELECT CLASSID FROM PSROLECLASS WHERE ROLENAME IN ( SELECT ROLENAME
 FROM PSROLEUSER WHERE ROLEUSER = 'VP1')))

you are asking, wouldn't these items be returning the wrong subset of data except in the case where 'VP1' is running it?

 also you say doesn't the upgrade documentation just refer to an upgrade user, not specifying 'VP1' or other supplied account?
 

Solution

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
Goal
Solution


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