The Receivable Specialist is saved on the Receipt table as Resource ID

Summary:

The Receivable Specialist for a receipt is stored on the Receipt table(AR_CASH_RECEIPTS_ALL) as Resource_ID, i am writing a report to include this Receivable Specialist but with the full name of the Personnel, i have looked at the PER_PERSON_NAMES_F, but the Person_ID does not match the Resource_Id, is there another table that stores the matching information between these two Ids.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

We are on Oracle Fusion ver 24C

Code Snippet (add any code snippets that support your topic, if applicable):