Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Track history tables in Oracle HRMS & Discoverer

800177Apr 18 2011 — edited Apr 21 2011

Hello experts,

I will be glad if anyone can help thru. I am trying to develop the DIS report for Audit purpose that tracks all the changes entered by Data Entry clerks, regardless of effective date. Mainly from Person Form and Assignment Form.

Is there anyway I can include the exact date/time the change made/status updated. Is the 'Effective date' clue?

e.g. There is an Assignment Change - from 'Global Operations' organization to 'Domestic Application' organization. The change is suppose to be effective from 05/02/2011 but I am entering the action on 04/18/2011. Similar for past events - if I make date tracked Assignment change suppose to be effective from 04/04/2011.

How can I accommodate this in a report. I just have EUL rights of Discoverer10g. (Oracle R12)

Thanks a lot.

This post has been answered by Michael Armstrong-Smith on Apr 21 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2011

Added on Apr 18 2011

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

3 comments

3,858 views