PJF: Unable To Load Employee Rate Schedules Using ProjectRateScheduleImportTemplate.xlsm Due To Unique Combination Error
Last updated on NOVEMBER 15, 2016
Applies to:Oracle Fusion Project Foundation Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms