We are on oracle ebs 12.2.4 and looking for any reusable queries to get all the transactions/ entities that an employee in oracle ebs is associated with?
before terminating an employee in oracle ebs, we are looking to get an extract with list of entities like pending workflow approval notifications or if the employee is part of a approval hierarchy that need to be updated.
This list will help to close any open transactions before end dating the employee record.
please let me know