ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4DADBA9F28E25278E0630100007F12DEY select haouv.name business_group, ppx.employee_number, ppx.full_name employee_name, (select pj.name from per_jobs pj where pj.job_id=paf.job_id) job, haouv2.name organization, (select ppx2.full_name from per_people_x ppx2 where ppx2.person_id=paf.supervisor_id) supervisor, ppx.email_address from per_people_x ppx, per_assignments_f paf, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2 where 1=1 and ppx.person_id=paf.person_id and paf.primary_flag='Y' and paf.assignment_type='E' and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date and paf.business_group_id=haouv.organization_id and paf.organization_id=haouv2.organization_id and ( :timecard_source='OTL' or not exists ( select null from pa_expenditures_all pea where pea.incurred_by_person_id=ppx.person_id and pea.expenditure_ending_date=:week_ending_date ) ) and ( nvl(:timecard_source,'PA')='PA' or ppx.person_id not in ( select hts.resource_id from hxc_timecard_summary hts where :week_ending_date between trunc(hts.start_time) and trunc(hts.stop_time) ) ) order by haouv.name, haouv2.name, ppx.full_name Added parameter Timecard Source to check OTL timecards instead of project expenditures. Replaced the operating unit restriction, which compared the business group with the operating units and returned no rows, by a Business Group parameter. PA AR PA بطاقات قيد الوقت المفقودة (بتنسيق XML) Application: المشروعات Source: AUD: بطاقات قيد الوقت المفقودة (بتنسيق XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG D PA Fehlende Stundennachweise Application: Projects Source: PA: Fehlende Stundennachweise (XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG F PA Feuilles de temps manquantes Application: Projects Source: AUD : Feuilles de temps manquantes (XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG US PA Missing Timecards Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor. Timecard Source Project Expenditures lists employees without a project expenditure for the week ending date. OTL Timecards lists employees without an OTL timecard whose period contains the week ending date, including employees who do not charge projects. ZHS PA AUD：缺少工时记录卡 Application: 项目 Source: AUD：缺少工时记录卡 (XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG Enginatics 1=1 :timecard_source :week_ending_date 1 10 1=1 haouv.name=:business_group LOV FND Business Groups D7815153ACE3306DE0530100007FD65A select pbg.business_group_id id, pbg.name value, pbg.short_name description from per_business_groups pbg value select pbg.name from per_business_groups pbg where pbg.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID') AR من تاريخ نهاية الأسبوع D Von KW Ende F Date de fin de semaine - Du US Business Group ZHS 自周末日期 2 11 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 20 :week_ending_date Date Y AR إلى تاريخ نهاية الأسبوع D Bis KW Ende F Date de fin de semaine - Au US Week Ending Date ZHS 至周末日期 4 30 1=1 haouv2.name=:organization LOV custom select haouv2.name value, null description from hr_all_organization_units_vl haouv2 order by haouv2.name AR اسم التنظيم D Organisationsbezeichnung F Nom de l'organisation US Organization ZHS 组织名 5 40 :timecard_source LOV custom select 'PA' id, 'Project Expenditures' value, null description from dual union all select 'OTL' id, 'OTL Timecards' value, null description from dual Project Expenditures Y US Timecard Source Where a submitted timecard is looked for: project expenditures with the week ending date, or OTL timecards whose period contains it. 2E6698492A3D4EFDA551906816F04461 Missing OTL Timecards Active employees without an OTL timecard for the week. ENGINATICS 1 BUSINESS_GROUP 1 7 EMAIL_ADDRESS 4 EMPLOYEE_NAME 3 3 EMPLOYEE_NUMBER 5 JOB 2 ORGANIZATION 2 6 SUPERVISOR Timecard Source OTL S Site