HXC Timecard Audit Trail

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor Engine
Source: OTL: Timecard Audit Trail Report
Short Name: HXCRPTAUD
DB package: HXC_RPT_TC_AUDIT_TRAIL
Run HXC Timecard Audit Trail and other Oracle EBS reports with Blitz Report™ on our demo environment
    SELECT TO_CHAR(TIME_ENTRY_DATE,'dd-MON-yyyy') ENTRY_DATE,
           ATTRIBUTE_INFO,
	   NVL(start_stop_time,hours) HOURS,
	   ACTION,
	   TO_CHAR(ACTION_DATE,'dd-MON-yy HH24:MI:SS') ACTION_BY_DATE,
	   ACTION_BY,
	   COMMENTS,
	   CLA_REASON,
	   RESOURCE_NAME,
	   TO_CHAR(TC_START_TIME,'dd-MON-yyyy') START_TIME,
	   TO_CHAR(TC_STOP_TIME,'dd-MON-yyyy') STOP_TIME,
	   SUBSTR(ACTION_TYPE,1,1) ACTION_ON
      FROM hxc_rpt_tc_audit
     ORDER 
        BY resource_name,
           tc_start_time,
           transaction_id,
           TRUNC(time_entry_date),
	   action_type,
	   action_date
Parameter Name SQL text Validation
From Date 
 
 Date
To Date 
 
 Date
Delete and Regenerate Data? 
 
 LOV Oracle
Display Records with Working Status? 
 
 LOV Oracle
Organization 
 
 LOV Oracle
Location 
 
 LOV Oracle
Payroll 
 
 LOV Oracle
Supervisor 
 
 LOV Oracle
Person 
 
 LOV Oracle
Download
Related Blitz Reports
HXC Missing Timecard PA Payroll Distribution Employee Detail HXC Retrieval Error Handling JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use AR Automatic Transactions Batch PQH Position Element Summary PQH Entity Element Summary CST Inventory Master Book FV Data Act File B
Blitz Report™

Blitz Report™ provides multiple benefits: