Can anyone advise on a PL/SQL API to get either the Person ID or the Person Name from an Employee ID?
E.g. for an individual with Employee ID = 12345, Person ID = “JSMITH” and Person Name = “John Smith”, is there any API to get either JSMITH or John Smith from 12345?
Hello. You could try,
Company_Person_API.Get_Person_Id(company_id, emp_no) OR
Company_Person_API.Get_Person(company_id, emp_no)
Perfect, tvm!
Hello,The person ID result will be returned from the above functions. The name will be returned when you try the following operation.
PERS_API.Get_Name(COMPANY_PERSON_API.Get_Person_ID(company_id,emp_no))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.