Monday, August 2, 2010

Oracle Apps Important Tables

-------------------------------------------------------------------------------------------------
HRMS
-------------------------------------------------------------------------------------------------
People -- per_all_people_f
Assignments -- per_all_assignments_f, hr_soft_coding_keyflex
Addresses -- per_addresses
Job -- per_jobs, per_job_definitions
Position -- per_positions, per_position_definitions
Grade -- per_grades, per_grade_definitions
Payroll -- pay_all_payrolls_f
Absence -- per_absence_attendances, per_absence_attendance_types
People Groups -- pay_people_groups
Organization -- hr_organization_units, hr_organization_information
Person EIT -- per_person_extra_info
Assignment EIT -- per_assignment_extra_info
Element Types -- pay_element_types_f, pay_input_values_f
Payroll processes -- pay_assignment_actions, pay_payroll_actions
Run Results -- pay_run_results, pay_run_result_values
Payment Methods -- pay_personal_payment_methods_f, pay_org_payment_methods_f
Element Entry -- pay_element_entries_f, pay_element_entry_values_f
Medical Assessments -- per_medical_assessments
Employment Details -- per_periods_of_service
Timecard data -- hxc_time_building_blocks, hxc_time_attribute_usages, hxc_time_attributes

----------------------------------------------------------------------------------------------
-- CM
-----------------------------------------------------------------------------------------------
Bank Statement -- ce_statement_headers_all, ce_statement_lines, ce_intra_stmt_headers_all
Bank Statement Interface -- ce_statement_headers_int_all, ce_statement_lines_interface

----------------------------------------------------------------------------------------------
-- PO
----------------------------------------------------------------------------------------------
Purchase Order -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all

4 comments:

sdprdy said...
This comment has been removed by the author.
sdprdy said...
This comment has been removed by the author.
Oracle Fusion said...

In this blog we can get useful information about oracle apps fusions......................visit our website for more information and you can get online training facilities in Oracle R12 financials online training

fusionscmtraininginhyderabad said...

This blog provides a comprehensive and insightful journey into the core of Cloud Financials training, highlighting crucial tables that underpin the data architecture. The author adeptly navigates through the labyrinth of essential tables, offering valuable insights for professionals and enthusiasts seeking to understand the foundational elements of Oracle Apps.