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
Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning.
Pages
▼
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