PJF: Unable To Load Employee Rate Schedules Using ProjectRateScheduleImportTemplate.xlsm Due To Unique Combination Error
(Doc ID 2204015.1)
Last updated on APRIL 03, 2019
Applies to:Oracle Fusion Project Foundation Cloud Service - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 1.0]
Information in this document applies to any platform.
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 -
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.
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.
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