E-SEC: USER_PROFILE Sync Fails from OIM to PeopleSoft: Class Row Method GetRowset Scroll DERIVED_PSWD Is Invalid. (2,270) (Doc ID 2468046.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

On : 8.55 version, Security

When a new user was created from OIM(provisioning) the following error occurred.

USER_PROFILE Sync fails: Class Row method GetRowset scroll DERIVED_PSWD is invalid. (2,270) USERMAIN


ERROR
-----------------------

[2018-xx-xxT02:55:56.357-04:00] [oim_serverx] [ERROR] [] [ORACLE.IAM.CONNECTORS.ICFCOMMON.PROV.ICPROVISIONINGMANAGER] [tid: [ACTIVE].ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xxxxxxx] [ecid: 0006gtPb9cCFs1TLyA8DyW0002_p0000tk,0:3] [APP: oim#11.1.2.0.0] [DSID: 0000MPb1s_LFs1TLyA8DyW1RgVmG00001y] oracle.iam.connectors.icfcommon.prov.ICProvisioningManager : createObject : Error while creating user[[
org.identityconnectors.framework.common.exceptions.ConnectorException: Cannot create user
at org.identityconnectors.peoplesoft.compintfc.PeopleSoftCompIntfcCreateOp.create(PeoplesoftCompIntfcCreateOp.java:120)
at org.identityconnectors.peoplesoft.compintfc.PeopleSoftCompIntfcConnector.create(PeopleSoftCompIntfcConnector.java:126)
at org.identityconnectors.framework.impl.api.local.operations.CreateImpl.create(CreateImpl.java:80)
.
.
.
.
.
Caused by: psft.pt8.joa.JOAException: Error invoking method [Save]
Message item[0] : (2,270) : Class Row method GetRowset scroll DERIVED_PSWD is invalid. (2,270) USERMAINT.GBL.SavePostChange PCPC:2275 Statement:46
Message item[1] : (91,37) : Error saving Component Interface. {USER_PROFILE} (91,37)
Message item[2] : (0,0) : Failed to execute PSBusComp request




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a new User from OIM
2. Observe error

Changes

Cause

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