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. |