FOREIGN KEY Constraint Error on Timesheet Update Import

FOREIGN KEY Constraint Error on Timesheet Update Import

ISSUE: When importing Timesheet in UPDATE mode, the report gives FOREIGN KEY contains database level error. 

Records need to be removed from back end to make fixes and re-run the Import. 

PROCESS OVERVIEW:

STEP 1: Isolate the Data Issue and Fix

ERROR = Override Location had only 1 digit and was configured. 

FIX = Either update the values in OVERRIDE_LOCATION or change the field to Skip Column Optional. 

BOARD CONTROL > GENERAL TABLES > IMPORT PROFILE MAINTENANCE > ATE_HRLY

**Override Location should be configured as Skip Column**

**Configured as Skip Column**

STEP 2: Delete the Timesheet Records (without Batch associated) from EC_WEB_TS_TRANS 

select * from EC_WEB_TS_TRANS

where EMP_GROUP_CODE = 'ABC123'

order by WORK_DATE desc

**Delete Records which were Imported with File that had Errors**

PAYROLL > PAY INPUT > HOURLY & DAILY TIMESHEET IMPORT PROCESS

**Trial > Submit > Update > Submit**