SG-1498 GDPR Administration | Errors -ORA-02292: integrity constraint (EAM.R5FOK8_TRA) violated - child record found when revoking an Employee with transactions - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

SG-1498 GDPR Administration | Errors -ORA-02292: integrity constraint (EAM.R5FOK8_TRA) violated - child record found when revoking an Employee with transactions

 Description 

When revoking an Employee with transactions, the employee reference in r5transactions table causes an error in the process - in GDPR Administration | Errors we have

ORA-02292: integrity constraint (EAM.R5FOK8_TRA) violated - child record found

Steps to reproduce:

# Job Setup - FORGETME job active and running.

# Employees - create an employee record REVOKEEMP.

# Physical Inventory - create a physical inventory record for a store / part, add REVOKEEMP in Assigned To. Approve the Physical Inventory.

# Employees - Click on Revoke icon to revoke the employee record.

# Wait until the FORGETME driver runs.

# GDPR Administration | Errors - see the error ‘ORA-02292: integrity constraint (EAM.R5FOK8_TRA) violated - child record found’ is shown for this record.

Current result: Employee record not revoked, error ORA-02292 shown.

Expected result: Employee record revoked, no errors shown.