For more information, please refer to this announcement explaining best practices for getting answers to questions.
CANCELED_HIRE system person type not populated after cancellation of employee work relationship
Summary:
CANCELED_HIRE system person type not populated after cancellation of employee work relationship
Content (please ensure you mask any confidential information):
When we cancel work relationship for an employee(new starters who have not joined), data gets deleted from per_all_assignments_m table. However, we can see a row in PER_PERSON_TYPE_USAGES_F table with SYSTEM_PERSON_TYPE as 'CANCELED_HIRE'. However, lately we can see deleting employee work relationship is now completely deleting the row from PER_PERSON_TYPE_USAGES_F table. We have HCM extract built on this logic with 'PER_EXT_SEC_PERSON_UE' as root data group user entity with the below filter criteria.