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

Last updated on JANUARY 30, 2017

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

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