Home » Tables » Per All People F Table In R12

Per All People F Table In R12

We would like to show you a description here but the site won#t allow us.

16/01/2013 Below is Simple Query to connect PER_PEOPLE_F and FND_USER in Oracle Applications and print following details User ID User name Email.

This table stores the type of an employee.

It is linked with the per_all_people_f with the person_type_id.


This table stores types of jobs.

It is linked with the per_all_assignments_f table to retrieve the correct job name of an employee.


This table contains grade information of employees.

06/09/2012 This table is used to find the type of the employee.

This table is linked with the per_all_people_f with the person_type_id to find out the type of person.


per_jobs_tl This table will contain the various types of JOBS in oracle.

This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

16/09/2012 Hi All, One of our team member dropped the per_all_people_f table in DEV instance.

It is R12.


1 instance.

Archive log not enabled in Dev instance.

How can i know that which guy dropped the table ?

[Apart from Auditing option] Any possible way to recover a table.

Regards, Shaik, This table also has party_Id, because Oracle creates a party in TCA as soon as a record in per_all_people_f gets created.

Main usage of per_all_people_f :-1.

To get the name of the person 2.

To get the date of birth or tax Id of the person Note:- The application uses PER_PEOPLE_F, as that is a secured view layer on top of PER_ALL_PEOPLE_F, The chart above shows some of the most common tables that are used in Oracle HRMS.

Often, a column in one table will link to a column in a different table.

For example, the primary key PERSON_ID in the PER_ALL_PEOPLE_F table will link to the foreign key PERSON_ID in the PER_ALL_ASSIGNMENTS_F table to connect people to their appropriate assignments.

Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.

PER_PTU_DFF_MIG_FAILED_PEOPLE: This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_ALL_PEOPLE_F.

Import customers using interface tables in Oracle Apps R12.

03/08/2018 Oracle EBS SQL Query that will list all employees in the hr.

per_all_assignments_f table and their supervisor, in readable format.

Output is [employee full name, employee number, supervisor full name, supervisor employee number], and ordered by employee name.

– OracleEBS-Employee-Supervisor-Query.

sql, 05/06/2016 Sandeep Sharma I have 9.

5 year experience in Oracle Technologies PLSQL, FORM, REPORT and APPS.

Mo:+91-9703879708 Mail Id: [email protected]

comper all people f table in r12