PJF: Unable To Load Employee Rate Schedules Using ProjectRateScheduleImportTemplate.xlsm Due To Unique Combination Error (Doc ID 2204015.1)

Last updated on NOVEMBER 15, 2016

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.1.11.1.0 to 11.12.0.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

While loading employee rate schedules using "Import Project Rate Schedules" FBDI, user receives an unique combination error however, same data allows to enter via the Manage Rate Schedules page -

Reported Error
The combination of schedule, person name, person number, person e-mail, job, organization, and from date must be unique.

MESSAGE_NAME = PJF_RSFBL_MULT_PERSON_RATES
MESSAGE_TEXT = The combination of schedule, person name, person number, person e-mail, job, organization, and from date must be unique.

Context - This message is displayed when the file-based data import process attempts to import two or more rate schedule lines with the same values for person name, person number, person e-mail, job, organization, and from date.

Replication Steps
1. Enter data in "Person Rates" sheet on ProjectRateScheduleImportTemplate.xlsm template.
2. Generate the ProjectsRatesFBDIWorkbook.Zip file.
3. Submit the Load Interface File for Import process to upload the CSV files into the open interface table.
4. Submit the Import Project Rate Schedules process.

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