My Oracle Support Banner

E-SEC: How to get Dynamic Role Rules to work on PT 8.4x and 8.1x (Doc ID 620659.1)

Last updated on APRIL 05, 2020

Applies to:

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


Still have questions after reading this document? Please post a question to our community: PeopleTools Community

Customers on PeopleTools release prior to 8.45 are working with Role Membership rules and have setup a role query that populates the role when testing. However when executing the app engine process to add these users to the role, the process will run to success but the role is not getting added.  This worked in prior tools releases.  However in PeopleTools 8.43 customers have been getting the following Subscription Error Time Sequence Error Message: Write RoleUser to Database SQL error. Function:  SQLExec   Error Position:  0   Return:  805 - ORA-00001: unique constraint (SYSADM.PS_PSROLEUSER) violated   Statement:  INS  
Write RoleUser to Database SQL error in Exec. (2,280) At ROLESYNCH_MSG.Write RoleUser to Database.Subscription   PCPC:4103  Statement:46




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.