How to get FULL_NAME from PER_PERSON_NAMES_F_V if user row is not on PER_USERS?
Summary:
We have a very simple section of report code that uses the LAST_UPDATED_BY field on FA_TRANSACTION_HEADERS table ("FTH" in the code below) to get a user's full name. However, if the user terminates from the company, there is no longer any record of their PERSON_ID on the PER_USERS table. So if we run a report for a year ago, the tables joins don't work, and we get a blank result for the FULL_NAME field.
Is there any other table that permanently stores the PERSON_ID field so we can grab their Full Name from the PER_PERSON_NAMES table?