Shulou(Shulou.com)06/01 Report--

-View all responsibilities of EBS users:

SELECT frt.responsibility_name, furg.END_DATE

FROM fnd_user_resp_groups furg

Fnd_responsibility fr

Fnd_responsibility_tl frt

Fnd_user fu

Where fu.user_name ='& username'

And fu.user_id=furg.user_id

And furg.RESPONSIBILITY_ID = fr.responsibility_id

And frt.responsibility_id=fr.responsibility_id

-- and furg.END_DATE is not null

Order by 1

-existing request time sort

SELECT fcr.request_id request_id

TRUNC ((fcr.actual_completion_date-fcr.actual_start_date) /

(1 / 24)) * 60) exec_time

Fcr.actual_start_date start_date

Fcp.concurrent_program_name conc_prog

Fcpt.user_concurrent_program_name user_conc_prog

FROM fnd_concurrent_programs fcp

Fnd_concurrent_programs_tl fcpt

Fnd_concurrent_requests fcr

WHERE TRUNC ((fcr.actual_completion_date-fcr.actual_start_date) /

(1 / 24)) * 60) > NVL ('& min', 45)

And fcr.concurrent_program_id = fcp.concurrent_program_id

And fcr.program_application_id = fcp.application_id

And fcr.concurrent_program_id = fcpt.concurrent_program_id

And fcr.program_application_id = fcpt.application_id

And fcpt.language = USERENV ('Lang')

ORDER BY TRUNC ((fcr.actual_completion_date-fcr.actual_start_date) /

(1 / 24)) * 60) desc

-- query the version of each module

Select a.oracle_id

A.last_update_date

A.product_version

A.patch_level

Decode (a.status

'I'

'Installed'

'S'

'Shared'

'N'

'Not Installed'

A.status) Status

A.industry

B.application_name

C.application_short_name

From fnd_product_installations a, fnd_application_tl b, fnd_application c

Where a.application_id = b.application_id

And a.application_id = c.application_id

And b.language = 'US'

Order by c.application_short_name

-- check scheduled tasks

Select

Fcr.request_id

Fcr.parent_request_id

Fu.user_name requestor

To_char (fcr.requested_start_date, 'MON-DD-YYYY HH24:MM:SS') START_DATE

Fr.responsibility_key responsibility

Fcp.concurrent_program_name

Fcpt.user_concurrent_program_name

Decode (fcr.status_code

'All, 'Waiting'

'Back, 'Resuming'

'Che, 'Normal'

'During, 'Cancelled'

'Evil, 'Error'

'Fried, 'Scheduled'

'Grain, 'Warning'

'Happy,'On Hold'

'Ill, 'Normal'

'Mouse,'No Manager'

'QQ, 'Standby'

'Randy, 'Normal'

'Sparks, 'Suspended'

'There, 'Terminating'

'Used, 'Disabled'

'Wendy, 'Paused'

'Xantha, 'Terminated'

'Zhuan, 'Waiting') status

Decode (fcr.phase_code

'Che, 'Completed'

'Ill, 'Inactive'

'Please, 'Pending'

'Randy, 'Running') phase

Fcr.completion_text

From

Fnd_concurrent_requests fcr

Fnd_concurrent_programs fcp

Fnd_concurrent_programs_tl fcpt

Fnd_user fu

Fnd_responsibility fr

Where

Fcr.status_code in ('Quan,' I') and

Fcr.hold_flag ='N' and

Fcr.requested_start_date > sysdate and

Fu.user_id = fcr.requested_by and

Fcr.concurrent_program_id = fcp.concurrent_program_id and

Fcr.concurrent_program_id = fcpt.concurrent_program_id and

Fcr.responsibility_id = fr.responsibility_id

Order by

Fcr.requested_start_date, fcr.request_id

-- check user login

SELECT user_name username

Description name

To_char (b.first_connect, 'MM/DD/RR HH24:MI') firstconnect

To_char (b.last_connect, 'MM/DD/RR HH24:MI') lastconnect

FROM apps.fnd_user a

(SELECT MIN (first_connect) first_connect

MAX (last_connect) last_connect

Last_updated_by user_id

FROM apps.icx_sessions

GROUP BY last_updated_by) b

WHERE a.user_id = b.user_id

AND last_connect > SYSDATE-3 / 12

ORDER BY 4 DESC

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.