My Oracle Support Banner

Are SJT Security Tables Needed in CS After a CS-HR Split? (Doc ID 1568437.1)

Last updated on MAY 03, 2023

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Can the following SJT tables be truncated in a CS database if environments are now split with HCM in a different instance?

SJT_CLASS
SJT_CLASS_ALL
SJT_CLS_TMP
SJT_DEPT
SJT_DEPT_TMP
SJT_OPR_CLS
SJT_OPR_CLS_TMP
SJT_PERSON
SJT_PERSON_USF
 

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
References


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