Who's Online Now
0 registered members (), 3 guests, and 23 spiders.
Key: Admin, Global Mod, Mod
Newest Members
SAI, Balasubramaniam, Dataterrain, Sarathy R, pjchiverton
1258 Registered Users
Recent Posts
Warning: VAT scam
by CT. 19/10/17 09:27 AM
EDI Replacement
by PaulD. 12/10/17 10:27 AM
Future dated records and API
by hpatel15. 10/10/17 08:04 AM
Faster Payments
by pat. 04/10/17 08:56 AM
Additional Org Info: Org Developer DF
by Sarathy R. 04/10/17 06:54 AM
Monthly Data Collection
by hpatel15. 28/09/17 07:33 AM
Top Posters(30 Days)
SBi 2
PaulD 2
CT 1
delboy 1
pat 1
Bobin 1
Popular Topics(Views)
418,048 PAYE RTI
49,926 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,086
CT Offline
CT  Offline

****

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

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

****

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

Joined: Jun 2005
Posts: 249
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,193
Posts11,868
Members1,258
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,086
bcooper 1,285
delboy 1,250
paulgos 431
SBi 425
Gus 252
pat 249
vkumar 223
October
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.036s Queries: 15 (0.008s) Memory: 2.7447 MB (Peak: 2.8989 MB) Zlib disabled. Server Time: 2017-10-24 05:37:03 UTC