PER Employee Missing Details
Description
Categories: BI Publisher
Imported from BI Publisher
Description: French HRMS employee missing details report
Application: Human Resources
Source: Employee Missing Details Report (XML)
Short Name: PERFREMD_XML
DB package: PER_PERFREMD_XMLP_PKG
Description: French HRMS employee missing details report
Application: Human Resources
Source: Employee Missing Details Report (XML)
Short Name: PERFREMD_XML
DB package: PER_PERFREMD_XMLP_PKG
Run
PER Employee Missing Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select full_name||decode(:P_SESSION_DATE,NULL,' (' || to_char(per.effective_start_date, 'DD-MON-YYYY')||')',NULL) FULL_NAME, decode(per.region_of_birth,null,'X',null) region_of_birth, decode(per.country_of_birth,null,'X',null) country_of_birth, decode(per.date_of_birth,null,'X',null) DOB, decode(asg.establishment_id,null,'X',null) estab, decode(asg.contract_id,null,'X',null) Contract, decode(scl.segment2,null,'X',null) Emp_cat from per_all_people_f per ,per_person_types pt ,per_assignments_f asg ,hr_soft_coding_keyflex scl where per.business_group_id = :p_business_group_id and nvl(:P_SESSION_DATE,per.effective_start_date) between per.effective_start_date and per.effective_end_date and asg.person_id = per.person_id and per.effective_start_date between asg.effective_start_date and asg.effective_end_date and scl.soft_coding_keyflex_id(+) = asg.soft_coding_keyflex_id and per.person_type_id = pt.person_type_id and pt.business_group_id = :p_business_group_id and pt.system_person_type = 'EMP' and (per.region_of_birth is NULL or per.country_of_birth is NULL or per.date_of_birth is NULL or per.sex is NULL or asg.establishment_id is NULL or asg.contract_id is NULL or scl.segment2 is NULL) order by per.order_name, per.effective_start_date |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Effective Date (Blank for All) |
|
Date |