| layout | default |
|---|---|
| title | PA Missing Timecards | Oracle EBS SQL Report |
| description | Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor. |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Missing, Timecards, per_jobs, per_people_x, per_assignments_f |
| permalink | /PA%20Missing%20Timecards/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor.
Operating Unit, Week Ending Date, Organization
per_jobs, per_people_x, per_assignments_f, hr_all_organization_units_vl, mo_glob_org_access_tmp, dual, pa_expenditures_all
PA Project Expenditure Items with WIP and INV Detail, PA Cost Audit, PA Employee Activity By Organization, WIP Account Distribution, PA Revenue, Cost, Budgets by Resources, CAC ICP PII WIP Material Usage Variance, CAC Receiving Value (Period-End), CAC WIP Resource Efficiency, PA Project Status Summary
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | PA_Missing_Timecards.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/pa-missing-timecards/ |
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics