How to avoid duplicate salary payments
We've had a situation where an employee was transferring to another location and unfortunately rather than being set as a transfer, the HR team re-created him as a new starter. This has resulted in duplicate salaries being paid.
Can anyone advise a good way to stop or flag this to avoid this occuring in the future.
We are on Oracle 11i