6 Replies Latest reply on May 13, 2016 12:38 PM by John_K

    ebs proper table name


      Hi i am new to oracle EBS 12.1.13. Using the  'hr_employee_api.create_employee'  i  have created a new user .

      output is : "anonymous block completed"

      My question is that

      1. From which table i will get the recently created employee?

      2. How can i retrieve the person id of that  newly created employee?

      note : i have checked inside "per_all_people_f" table but din get any record.If you run the same code its showing "ORA-20001: Employee Number already exists"


      please give me the solution?