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

Last updated on JUNE 16, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 and later
Information in this document applies to any platform.
***Checked for Relevance 19-03-2013***

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms