Who's Online Now
0 registered members (), 4 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Andi, nicwoody, appetite11, Nathy, Apoorva
1270 Registered Users
Recent Posts
US State LOV in Cloud HCM
by bcooper. 18/06/18 10:26 AM
Amending Maternity and ShPP Average Earnings
by appetite11. 14/06/18 10:51 AM
Retropay Enhanced Performance Issues
by delboy. 13/06/18 02:05 PM
Top Posters(30 Days)
delboy 2
Popular Topics(Views)
457,355 PAYE RTI
54,022 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,092
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,092
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: 254
pat Offline
claiming squatters rights
pat  Offline
claiming squatters rights

Joined: Jun 2005
Posts: 254
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,092
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,092
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: 254
pat Offline
claiming squatters rights
pat  Offline
claiming squatters rights

Joined: Jun 2005
Posts: 254
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
Forums60
Topics2,208
Posts11,934
Members1,271
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,092
bcooper 1,289
delboy 1,282
paulgos 433
SBi 426
pat 254
Gus 252
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.033s Queries: 15 (0.013s) Memory: 2.7539 MB (Peak: 2.9065 MB) Zlib disabled. Server Time: 2018-06-25 09:33:38 UTC