Query : to find Session Locking

select o.object_name,
l.oracle_username,
l.os_user_name,
s.machine,
s.program,
decode(l.locked_mode,0,'None',1,'NULL',2,'Row-S(SS)',3,'Row-X(SX)',
4,'Share',5,'S/Row-X(SSX)',6,'Exclusive(X)') locked_mode,
s.sid,
s.serial#
from all_objects o,v$locked_object l,v$session s
where l.session_id = s.sid
and l.object_id=o.object_id

Important Tables in HRMS

  • Per_all_people_F
  • per_person_types
  • per_person_type_usages
  • per_addresses
  • per_contact_Relationships
  • per_periods_of_service
  • Per_all_assignments_f
  • per_pay_groups
  • per_jobs
  • per_job_Definitions
  • per_grades
  • per_grade_definitions
  • hr_all_positions
  • hr_all_position_definitions
  • hr_all_locations
  • pay_all_payrolls_F
  • pay_element_entry_values_F
  • pay_element_entries_F
  • pay_elements_links_F
  • pay_element_types_F

 

Key Flexfields (KFFs) in HRMS

  • Job KFF,
  • Grade KFF,
  • People Group KFF,
  • Position KFF,
  • Cost Allocation KFF,
  • Comptence KFF