Who's Online Now
0 registered members (), 5 guests, and 26 spiders.
Key: Admin, Global Mod, Mod
Newest Members
nicolekristen, Raj@402, paulbenf, Samora, mahesh kumar
1246 Registered Users
Recent Posts
Element Attribution
by ClanGowland. 18/08/17 08:42 AM
Incrementing parameter in scheduled request
by ClanGowland. 18/08/17 07:31 AM
Gross to Net Summary Report
by delboy. 17/08/17 01:48 PM
11i or R12.1.x to R12.2.x Upgrade
by CT. 08/08/17 08:23 AM
R11.1.3 BACS Running slowly post TYE 17
by PaulD. 07/08/17 01:14 PM
Employment Intermediaries Changes
by CT. 02/08/17 06:54 AM
Shared Parental Leave
by SBi. 25/07/17 07:59 AM
Payroll Purge
by PaulD. 21/07/17 02:12 PM
So...(the IR35 discussion thread)
by PaulD. 21/07/17 09:47 AM
Top Posters(30 Days)
CT 5
SBi 4
PaulD 4
delboy 2
DanC 1
Popular Topics(Views)
406,843 PAYE RTI
48,769 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,074
CT Offline
CT  Offline

****

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

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

****

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

Joined: Jun 2005
Posts: 247
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,178
Posts11,796
Members1,247
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,074
bcooper 1,283
delboy 1,237
paulgos 430
SBi 416
Gus 252
pat 247
vkumar 223
August
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.018s Queries: 15 (0.005s) Memory: 2.7471 MB (Peak: 2.8992 MB) Zlib disabled. Server Time: 2017-08-19 13:13:54 UTC