Scribd
Upload
185 views12 pages

Register SQL Plus Program

Uploaded by

satishvsh
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
185 views12 pages

Register SQL Plus Program

Uploaded by

satishvsh
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Author – A.

Kishore
[Link]

Implementing a SQL*PLUS Concurrent Request

1> Defining the Executable


Concurrent:Program:Executable.

2> Defining the Concurrent Program


Concurrent:Program:Define
Author – [Link]
[Link]

3> Assigning the Concurrent Program to a Request Group


Security:Responsibility:Request.
Author – [Link]
[Link]
Author – [Link]
[Link]

APPENDIX 1: Sample SQL*PLUS Script


SET PAGESIZE 40
SET LINESIZE 80
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING ON
TTITLE 'Userid|Activity Report'
BTITLE 'Confidential'
COLUMN c1 HEADING 'User Name'
COLUMN c2 HEADING 'Session Start Time'
COLUMN c3 HEADING 'Session End Time'
SELECT SUBSTR(fu.user_name, 1,30) "c1"
, TO_CHAR(fl.start_time, 'fmYYYY/MM/DD fmHH:MI:SS AM') "c2"
, NVL(TO_CHAR(fl.end_time, 'fmYYYY/MM/DD fmHH:MI:SS AM'),
'Session In Doubt') "c3"
from fnd_user fu,
fnd_logins fl
where fu.user_id = fl.user_id
and fu.user_name = UPPER('&1')
and fl.start_time >= '&2'
ORDER BY fl.start_time
/
SET FEEDBACK ON
SET VERIFY ON

COPY the sql file into $FND_TOP/sql

Parameter
Author – [Link]
[Link]
Author – [Link]
[Link]
Author – [Link]
[Link]
Author – [Link]
[Link]
Author – [Link]
[Link]
Author – [Link]
[Link]
Author – [Link]
[Link]
Author – [Link]
[Link]

You might also like