My Oracle Support Banner

Search Match Import Fails When There Is More Than One Row Of Data on Record.PERS_DATA_EFFDT in CS: An Error Has Occurred While Importing The Data And No ID Was Created (Doc ID 2483372.1)

Last updated on FEBRUARY 01, 2021

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.


On : HCM 9.2.25, PTools 8.56.07 version, Job / Personal Information

Search Match Import fails when there is more than one row of historical data.

When a student in Campus solutions has more than one name, address, phone number, email address or ethnicity history, the search match import fails from CS to HCM.
Campus solutions Main Menu>Workforce Administration>personal Information> Biographical>Modify a Person. If this has any historical fields greater than 1 then the import function fails in HCM.
HCM menu =Main Menu> Workforce Administration>Personal Information> Search Match Internal/External

An error has occurred while importing the data and no ID was created. (14020,27)

The issue can be reproduced at will with the following steps:
1. Run Search Match Import from CS to HCM:  Enterprise Components > Integration Definitions >Initiate Processes > Full Data Publish


To view full details, sign in with your My Oracle Support account.

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

In this Document

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