KB1027

Resolving duplicate providers in the Provider List driver

Summary

In each budget cycle, you need to update the Provider List driver. The system may display a duplicate key error when saving the driver after updating it.

Details

This error is caused by one or both of the following situations in the PROVIDER dimensions table:

  • The EmpID value was changed on a provider record that currently exists in the Provider List driver.
  • A new provider ID is the same as the employee ID on another provider record.

Resolution

Complete the following steps to resolve the error:

  1. In the Provider List driver, navigate to the rows listed on the Save Data Errors task pane to note the providers that are causing the error.

  2. In the Main ribbon tab, click Navigation > Explorer.

  3. In Explorer, in the Libraries section, click Table Library > Budgeting > Assumptions > Budget20XX, and double-click Budget20xx_ProviderList.

  4. For the records identified with errors, review the table for the following:
    • Multiple providers with the same employee ID
    • The same provider with different employee IDs

  5. After you determine the record(s) to remove, delete them from the table by selecting Delete Row in the Delete Row column (column B).

  6. After you mark the incorrect record rows for deletion, on the Main ribbon tab, click Save. The system will then remove the rows from the table.

Outcome

After completing the steps in the Resolution section above, you can now save the Provider List driver without error.

Article information

Category

Drivers, Budgeting Drivers

Applies To

HC Budgeting, any platform

Tags

Duplicate Key, Key Error, Provider List, Provider List Driver

Issue Number(s)

PFB-08010