Common errors for the Import and Update Participant Details process.

(Doc ID 1940499.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

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

Symptoms

This document lists some common errors with updating the participant detail using the import process.

See documentation Importing and Updating Participant Details into Incentive Compensation: Procedure

Reference Template ParticipantDetailsImportTemplate.xlsm


STEPS
1. Populate ICParticipantDetail.xlsm template and generate the csv and zip file
2. Run Navigator > Participant Assignments > Import and Update Participant Details

 

Following are some common error messages with the Import and Update Participant Details process :

1.  Country Code is not valid.

2.  There is not a valid BUSINESS UNIT on the file. Please verify.

3.  Participant was not found.

4.  Hold Payment Reason must match the lookup defined values.

 

Changes

The template has the following column descriptions.

Staging Column Name: COUNTRY_CODE VARCHAR2 (30 CHAR)
The ISO code that represents the participant's country.
If providing a value, the value must exist in table FND_TERRITORIES_B.ISO_TERRITORY_CODE column.
You can view available ISO Country codes (ISO Territory Codes) using the Setup and Maintenance, Manage Territories task.

Staging Column Name: ORG_ID Number (18,0)
Name of the Oracle Fusion Incentive Compensation business unit.
The name is used by the import process to derive the unique identifier for the business unit.

Staging Column Name: PARTICIPANT_ID NUMBER (18,0)
The participant's name.
It is recommended that you provide one or more of the following attributes to uniquely identify the participant: E-Mail Address, Party ID, Party Number, Person Number, Primary Worker ID, Display Identifier, Source System, Source System ID.
The participant name is used by the import ...

Staging Column Name: HOLD_REASON VARCHAR2 (30 CHAR)
The lookup value meaning that represents the reason for the payment hold, such as leave, Dispute, and terminated.

 

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