Module: HRCore HRSeverity: BLOCKER
DateTrack Gap or Overlap in Employee Person or Assignment History
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
date track corruptiondatetrack gapHR_DATETRACK_GAPeffective dates overlapper_all_people_f date gapper_all_assignments_f overlap
Root Cause Analysis
DateTrack sequence for employee {personId} has broken contiguous timeline.
Diagnostic SQL Queries (Read-Only)
CHECK_PERSON_DATETRACKDetect gaps between effective_end_date and subsequent effective_start_date
SELECT person_id, effective_start_date, effective_end_date,
LEAD(effective_start_date) OVER (PARTITION BY person_id ORDER BY effective_start_date) AS next_start
FROM per_all_people_f
WHERE person_id = :personIdRemediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM per_all_people_f WHERE person_id = :personId AND effective_start_date > effective_end_dateExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.