Participant Detail Import Does Not Create New Row (Doc ID 2248415.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When importing Participant Details using the provided xlsm template and the standard "Import and Update Participant Details" process.

The expected behavior is for the import process to End Date the existing record as "New Record Start Date - 1". This is not happening.

The import is overwriting the existing record with the new date and details.

Here is an example:

participant with two existing Detail rows. The Start Date of the current record is 2/1/2017.
Load a new row using the template and process with a Start Date of 3/1/2017.
The expected behavior is for the import process to update the end date the first row with a value of 2/28/2017 and then insert a new row will be entered in the system with a Start Date of 3/1/2017.
This is not happening. The existing row is overwritten with the values of the import, including the Start Date.


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