Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Report to identify employees with corruption in "PER_PERSON_NAMES_F" table
Summary:
Hello,
We are looking for a report to pull all employees with corrupted "PER_PERSON_NAMES_F" table. We had several employees with this corruption that caused errors in the associated employment tables. We were told the "WW" in the name table is the marker of the failure. We have the following query where we need to supply person numbers. We are looking for a report so that we don't have to enter the person number information.
SELECT a.*
FROM fusion.PER_PERSON_NAMES_F a ,
fusion.PER_ALL_PEOPLE_F b
WHERE b. PERSON_ID = a. PERSON_ID
Tagged:
0