/
Error importing projection salary table

Error importing projection salary table



Description of Issue

Getting error when importing Projection Salary tableĀ 

Error executing pmgrtabio_insert.

ID:[Insert 1023] record [1223:2000:1609 07/01/2022] status -6732 [ISAM -5000] ā€œ

ā€œ[SQL Server] Cannot insert duplicate key row in object ā€˜dbo.payrollGradesā€™ with unique index ā€˜IX_PayrollGrades_Uniqueā€™. The Duplicate ā€œ



Context
  • Payroll

  • Financials

  • Budget Processing

  • Salary and Benefit Projection

  • Projection Start and Status



Cause

Salary table already exists in the system.



Resolution

To confirm the Salary Table exists:Ā 

  1. Go to Projection Start and Status ( Financials > Budget Processing > Salary and Benefit Projection>Projection Start and Status )

  2. Search for Projection run. Click Accept.Ā 

  3. Click on Salary tables

  4. Search for Effective date, Rank, Group BU, etc.Ā 

  5. Click Accept.Ā 



Additional Information












Related content