Last updated on MAY 25, 2017
Applies to:PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.
On : Campus Solutions 9.2, PSLOCK is occurring when running Search/Match/Post (SCC_SL_SMP) process.
PSLOCK issue seems to be stemming from the 'save' call in app class SCC_SL_TRANSACTION:ACCESSORS:StagedUserPerzCategory, which is issuing:
SQLExec("DELETE FROM PSUSERPRSNLOPTN WHERE OPRID = :1 and
OPTN_CATEGORY_LVL=:2 and USEROPTN=:3", &userid, %This.OPTN_CATEGORY_LVL,
This table is a tools table, and tools internally serializes its updates via
the PSLOCK table using object type names = 'UPM' and 'SYS'.
Although PSLOCK is being updated when the rowsetcache objects are being
refreshed, this only happens the first time they are used. After that, they
stay in the rowset cache, and this does not trigger updates to PSLOCK.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms