When Using SCC_PERSON_SYNC, Get Error Cannot Assign an Empty Rowset (14020,1)

(Doc ID 2328625.1)

Last updated on NOVEMBER 15, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


In CS 9.2, when utilizing the service operation SCC_PERSON_SYNC, it errors with the following:

Cannot assign an empty rowset (14020,1) SCC_CONSTITUENT_MGR.UTIL.Utilities.OnExecute Name:ConstructAppClassStringFromEventRegistry PCPC:2248 Statement:42
Called from:SCC_CONSTITUENT_MGR.CONSTITUENT.ConstituentFactory.OnExecute Name:GetInstance Stat

The issue can be reproduced at will with the following steps:

1. Set up and configure integration broker.
2. Configure the service operation SCC_PERSON_SYNC.
3. Try running.

The issue has the following business impact:

Due to this issue, users cannot use the service operation SCC_PERSON_SYNC.


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