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 APRIL 22, 2019

Applies to:

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

Symptoms

On : CS9 version, Campus Community Integrations & Interfaces

 ACTUAL BEHAVIOR
 ---------------
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."

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

 STEPS
 -----------------------
 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
 Save

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

Cause

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
Symptoms
Cause
Solution
References


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