You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get FULL_NAME from PER_PERSON_NAMES_F_V if user row is not on PER_USERS?

Accepted answer


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?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!