PA Missing Timecards – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor.

Report Parameters

Operating Unit, Week Ending Date, Organization

Oracle EBS Tables Used

per_jobs, per_people_x, per_assignments_f, hr_all_organization_units_vl, mo_glob_org_access_tmp, dual, pa_expenditures_all

Report Categories

Enginatics

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

Running This SQL Without Blitz Report

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.

Download & Import Options

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/

© 2026 Enginatics