My Oracle Support Banner

Invalid OPRIDs in CS Operator Defaults Table (Doc ID 2493288.1)

Last updated on JANUARY 06, 2020

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Campus Community Other

There are 320 invalid OPRID entries in the user defaults table (OPR_DEF_TBL_CS) in our CS DMO environment These are not valid user IDs as confirmed by checking the PSOPRDEFN table. When a user is deleted from the environment, if the user has an entry in the user defaults table it is also deleted, so these invalid entries aren't left over data from profiles that have been properly removed.

What is the purpose of these invalid entries in the user defaults table? Should they be removed?


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

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