My Oracle Support Banner

LOCATION_SYNC - Adding A New Effective Dated Row For Existing Location Ends In Error (Doc ID 1986782.1)

Last updated on JULY 10, 2020

Applies to:

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


On : CS9 version, Campus Community Integrations & Interfaces

When running the Location_Sync from HR 9.2 to CS 9 and making a change to the location in HR by adding a new effective dated row to an existing location the XML will contain an Audit Action of 'A' - Add. Publication message in HCM will be successful. Subscription message in CS will end in error:
 "Row already exists with the specified keys. {LOCATION} A rows already exists in the database with the specified keys."

 The new effective dated row should be Added in CS rather than fail on subscription.

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

HCM Navigation: Main Menu > Set Up HCM > Foundation Tables > Organization > Location
 Open an existing location
 Add a new effective dated row of current date

 The issue has the following business impact:
This is synched very infrequently so it is a low impact.


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.