E-IB/SEC: USER_PROFILE Subscription Handler Errors:FUNCLIB_PTSEC.OPRID.FieldFormula Name:UpdatePSLOCK PCPC:2471 Statement:25
Last updated on AUGUST 24, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.48 and later
Information in this document applies to any platform.
Service Operation USER_PROFILE is published from the Portal database to the Financial, ELM and HR system. The USER_PROFILE queue is partitioned on the EMPID field. On each of the target database intermittently a subscription handler will fail with the error seen in the Service Operation Monitor:
Error Timestamp Segment Index Error Message Description
11/18/2010 12:20:21.000000PM 0 A fatal PeopleCode SQL error occurred. Please consult your system log for details.
11/18/2010 12:20:21.000000PM 0 SQL error in Exec. (2,280) FUNCLIB_PTSEC.OPRID.FieldFormula Name:UpdatePSLOCK PCPC:2471 Statement:25 Called from:USER_PROFILE.update_user_profile.OnExecute Name:OnNotify Statement:49
11/18/2010 12:20:21.000000PM 0 Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845)
A resubmit clears up the problem.
The issue can be reproduced with the following steps:
1. Peopletools>Security>User Profile>User Profile.
2. Select a profile to update/insert information.
4. Message sent from Portal to Financial, ELM and HR. In any of the receiving databases, the error may be seen.
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