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.
- Any Location has to be 2 Digits (Add 0 in front of value).
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**