I would like to create a discovere report based on date track on person and assignment form in HRMS.When ever changes make on person and assignment form by whom.if you have any smilar report based on date track history please let me know.

What sort of detail are you after Scott?

Does your report need to identify just the fact that the person/assignment has been 'touched' by a user (either update or correction), or do you want details of the fields that were changed?
Also, how often does this report need to run? Presumably you are wanting to highlight changes within a given time period?

We have such reports here, but (a) they're not mine to give away freely and (b) are complex and took a great deal of time to perfect.

If you are simply after a list of employee or assignment records that have had changes/updates made then you need to drive off the LAST_UPDATE_DATE column and use the LAST_UPDATED_BY to join to FND_USER to fetch details of the application user who made the changes.

Regards

Barry

P.S. I saw that you had posted the same question twice in different areas - i have lopped the duplicate post out.

Thanks for reply.

I want details of the fields in person and assignment form that were changed by whom on specific period.


if you have similar kinds of reports,please let me know that would be very helpful for me.

Thanks for your support.

You're not going to be able to do this by report alone.
In order to be able to identify the fields that were changed you are going to have to head down one of 2 routes...

• 1 A batch process that runs periodically (overnight?) that snapshots the data into temp tables and then compares the values with previous snapshot and reports the differences, or
• 2 Use triggers to grab which fields have been changed (using the :OLD and :NEW references) and write this information to a stage table which is then used to drive your report.
  There is core functionality within OAB called the "Change Event Log" (or similar) that does this, but on a much grander scale (ie for larger number of tables). This could be a useful start point for you

Either way, you are going to need a reasonable amount of development work using mixed tools (PL/SQL, Triggers, Reports etc).

One question i do have (and should have asked this first ) is why do you need this information? WHat is the business driver for this?

Regards

Barry

You could also have a look at AuditTrail... I have not set it up, but from what I have read, it will record a before and after snap-shot of the data for you.
Set-up guide is part of the HRMS IG from Oracle; the guide I have is 2-88.

Hope this helps!
Gavin

Thanks for your reply

i dont want to go in long procedure. i need only simply report based on two tables(per_all_people_f and per_all assignments_F).

we need to check the columns(last updated by and last updated date)in both tables.

This report would be consist on following columns.

Empno,
Change field name (per_all_people_f, per_all_assignment_f)
status (update or correction)
change_date(per_all_people_f, per_all_assignment_f)