Whenever we talk about Date Tracking in EBS, we always refer to the effective_start_date and effective_end_date fields. Does code like this look familiar? SELECT * FROM per_all_people_f papf WHERE sysdate between papf.effective_start_date and papf.effective_end_date While this great for making sure you have the record on the date you are looking for, I find it to …
Oracle EBS: Life Events, Life_Event_Occurred_Date (lf_evt_ocrd_dt) and last_update_date
