Who's Online Now
0 registered members (), 3 guests, and 8 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Ravi Pasapula, kumar1900, B_DOYLE, rdeshab, samba
1296 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
495,795 PAYE RTI
60,742 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#4344 - 30/03/09 09:55 AM Create report based on date track  
Joined: Mar 2009
Posts: 17
scott Offline
warming-up
scott  Offline
warming-up

Joined: Mar 2009
Posts: 17
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.

#4346 - 30/03/09 10:43 AM Re: Create report based on date track [Re: scott]  
Joined: Mar 2005
Posts: 1,293
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,293
Earth, Europe, England, here
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.


No signature required
#4348 - 30/03/09 10:52 AM Re: Create report based on date track [Re: bcooper]  
Joined: Mar 2009
Posts: 17
scott Offline
warming-up
scott  Offline
warming-up

Joined: Mar 2009
Posts: 17
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.

#4350 - 30/03/09 01:37 PM Re: Create report based on date track [Re: scott]  
Joined: Mar 2005
Posts: 1,293
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,293
Earth, Europe, England, here
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 crazy) is why do you need this information? WHat is the business driver for this?

Regards

Barry

Last edited by bcooper; 30/03/09 01:37 PM.

No signature required
#4351 - 30/03/09 01:37 PM Re: Create report based on date track [Re: scott]  
Joined: Feb 2008
Posts: 174
Gavin Harris Offline
nothin' better to do
Gavin Harris  Offline
nothin' better to do
*****

Joined: Feb 2008
Posts: 174
Down under...
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



Gavin Harris
Sleeping on it...

Link to me on http://www.linkedin.com/in/gavinharris
#4353 - 30/03/09 05:12 PM Re: Create report based on date track [Re: Gavin Harris]  
Joined: Mar 2009
Posts: 17
scott Offline
warming-up
scott  Offline
warming-up

Joined: Mar 2009
Posts: 17
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)





Moderated by  Administrator, bcooper, CT 

Forum Statistics
Forums60
Topics2,228
Posts12,033
Members1,296
Most Online283
Dec 25th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,117
delboy 1,308
bcooper 1,293
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
July
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.023s Queries: 15 (0.009s) Memory: 2.7736 MB (Peak: 2.9419 MB) Zlib disabled. Server Time: 2020-07-08 23:36:00 UTC