E-IB/SEC: USER_PROFILE Subscription Handler Errors:FUNCLIB_PTSEC.OPRID.FieldFormula Name:UpdatePSLOCK PCPC:2471 Statement:25

(Doc ID 1275787.1)

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.

Symptoms

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


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.
3. Save.
4. Message sent from Portal to Financial, ELM and HR.  In any of the receiving databases, the error may be seen.

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