Who's Online Now
0 registered members (), 2 guests, and 35 spiders.
Key: Admin, Global Mod, Mod
Newest Members
mahesh kumar, Arundevaa B, NickyMcQ, dartdeena, jebaneesa
1240 Registered Users
Recent Posts
Setting up RTI for XML
by delboy. 26/06/17 02:34 PM
Top Posters(30 Days)
delboy 2
Popular Topics(Views)
396,463 PAYE RTI
47,701 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#11785 - 01/02/17 08:15 AM Issue: OTA_DELEGATE_BOOKINGS having wrong WHO info  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
Hi all, well as you all will no doubt appreciate, I am not overly blessed with knowledge around this particular application, but some strange things have been happening with this table.

There appear to be certain situations (the details of which are not yet fully known) where some process or other just updates the last_updated_by and last_update_login for a large number of rows. The user who is shown as the last_update_by vehemently denies all knowledge, and indeed the responsibility is not one that would normally allow him or her access to that kind of data.

Furthermore, the last update login id, when one looks at fnd_logins, looks like it is 'concurrent' however there are no concurrent jobs that bear that login id.

So, my question is this: what other non-human interaction besides a concurrent job, would give rise to a login_id.

If I could get some kind of steer as to how else a background process could be initiated, I might be on the way to resolving this little problem.

It's not a show-stopper, and to be fair if it were not for a recent change to some reports that now show 'last updated by' in the details for these enrolments, people would have been none the wiser.

Nothing in Metalink of course, so anyone else out there seen this before? Any clues would be voraciously seized upon.


CT
#11786 - 02/02/17 09:21 AM Re: Issue: OTA_DELEGATE_BOOKINGS having wrong WHO info [Re: CT]  
Joined: Jun 2005
Posts: 246
pat Offline
claiming squatters rights
pat  Offline
claiming squatters rights

Joined: Jun 2005
Posts: 246
Hardy's Way
Hi CT,

I often use the following sql to find all concurrent processes running at the last update timestamp:

select
prog.user_concurrent_program_name
,req.request_id
,to_char(req.actual_start_date ,'Dy dd-Mon-rrrr hh24:mi:ss') start_time
,to_char(req.actual_completion_date,'Dy dd-Mon-rrrr hh24:mi:ss') end_time
from
applsys.fnd_concurrent_programs_tl prog
,applsys.fnd_concurrent_requests req
where prog.concurrent_program_id = req.concurrent_program_id
and to_date('29-Aug-2013 15:39:00','dd-Mon-rrrr hh24:mi:ss')
;

where 29-Aug-2013 15:39:00 is the last update time.

Hopefully it will return a culprit process.

#11787 - 02/02/17 09:30 AM Re: Issue: OTA_DELEGATE_BOOKINGS having wrong WHO info [Re: CT]  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
Thanks Pat, however I've already run various scripts to try and reveal conc requests without success.

Cheers anyway smile


CT
#11788 - 02/02/17 01:15 PM Re: Issue: OTA_DELEGATE_BOOKINGS having wrong WHO info [Re: CT]  
Joined: Jun 2005
Posts: 246
pat Offline
claiming squatters rights
pat  Offline
claiming squatters rights

Joined: Jun 2005
Posts: 246
Hardy's Way
Figured you would have tried more than just the one script but hoped it would help.

The only other thing I can think of is could there be an Alert scheduled that isn't being picked up by your scripts.


Moderated by  andy.fisher, cazbeach, Geoff Dixon 

Forum Statistics
Forums48
Topics2,172
Posts11,747
Members1,241
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,063
bcooper 1,279
delboy 1,227
paulgos 423
SBi 412
Gus 252
pat 246
vkumar 223
June
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
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.020s Queries: 16 (0.006s) Memory: 2.7436 MB (Peak: 2.8965 MB) Zlib disabled. Server Time: 2017-06-28 00:01:12 UTC