HOME
ABOUT ME: SHAILENDER THALLAM
CONTACT
ORACLE APPS INTERVIEW QUESTIONS
How to Schedule a concurrent program from
Backend
Search on this Site
Search
By Shailender Thallam | December 10, 2014 | 2,277 views | Category: AOL SQL Scripts Oracle Apps
Categories
Basics
0 Comments
Advanced Collections (2)
Alerts (2)
AOL and SYSADMIN (36)
AOL SQL Scripts (23)
APIs (7)
Business Events (3)
Costing (1)
PDFmyURL lets you convert a complete website to PDF automatically!
Custom PLL (1)
Data Conversions/Interfaces (2)
Extensions (1)
General Ledger (2)
HRMS (5)
Interview Questions (10)
Inventory (7)
iRecruitment (1)
iStore (1)
OAF (8)
We can use the same fnd_request.submit_request API which we use to submit a program for
OPM (4)
scheduling a program too. The only dierence is the value passed to the parameter start_time.
Oracle Apps Basics (20)
Usually while submitting a concurrent program form backend we pass sysdate as value to the
Oracle Learning Management (4)
parameter start_time but to schedule a program we just need to pass a future date and time to
Oracle SQL (18)
this parameter.
Order Management (15)
For example:- If you would like to schedule a program to run after 30 minutes from now, you need to
Payables (3)
pass to_char(sysdate + 30/1440,DD-MON-YYYY HH24:MI:SS) as a value to parameter
Payments (6)
start_time.
Note: 1440 is the number of minutes in a day.
Below is the example to schedule a concurrent program to run after 30 minutes:
Personalizations (4)
PL/SQL (19)
Prole Options (6)
Purchasing (5)
1
2
3
4
5
6
/*********************************************************
*PURPOSE: To Submit a Concurrent Request from backend
*
*AUTHOR: Shailender Thallam
*
**********************************************************/
-DECLARE
PDFmyURL lets you convert a complete website to PDF automatically!
Receivables (8)
Reports (2)
Scripts (8)
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
DECLARE
l_responsibility_id NUMBER;
Security (1)
l_application_id
NUMBER;
l_user_id
NUMBER;
Shipping Execution (2)
l_request_id
NUMBER;
BEGIN
Trade Mangement (1)
-SELECT DISTINCT fr.responsibility_id,
Uncategorized (2)
frx.application_id
INTO l_responsibility_id,
Unix / Shell Scripts (2)
l_application_id
FROM apps.fnd_responsibility frx,
WIP Jobs (1)
apps.fnd_responsibility_tl fr
WHERE fr.responsibility_id = frx.responsibility_id
Workows (21)
AND LOWER (fr.responsibility_name) LIKE LOWER('XXTest Resp');
-XMLP (12)
SELECT user_id INTO l_user_id FROM fnd_user WHERE user_name = 'STHALLAM';
---To set environment context.
-apps.fnd_global.apps_initialize (l_user_id,l_responsibility_id,l_application_id
---Submitting Concurrent Request
-l_request_id := fnd_request.submit_request (
application
=> 'XXCUST',
program
=> 'XXEMP',
description
=> 'XXTest Employee Details',
start_time
=> to_char(sysdate + 30/1440,'DD-MON-YYYY HH24:MI:SS'
sub_request
=> FALSE,
argument1
=> 'Smith'
);
-COMMIT;
-IF l_request_id = 0
THEN
dbms_output.put_line ('Concurrent request failed to submit');
ELSE
dbms_output.put_line('Successfully Submitted the Concurrent Request');
END IF;
-EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Error While Submitting Concurrent Request '||TO_CHAR
END;
/
PDFmyURL lets you convert a complete website to PDF automatically!
52 /
For Further Reading
1. PL/SQL Script to Submit a Concurrent Request from backend
2. How to submitt XMLP Report using a PL/SQL Script
3. How to make a Concurrent Program WAIT untill completion of another Concurrent
Program execution?
4. PL/SQL Script to Add a Concurrent Program to a Request Group from backend
5. PL/SQL Script to Create a Concurrent Program Parameter from backend
6. How to get Concurrent Request ID of a parent program in a child program of a Request
Set?
7. PL/SQL Script to Create a Concurrent Program from backend
Category: AOL SQL Scripts Oracle Apps Basics
AdChoices
AdChoices
AdChoices
Time Table Schedule
Schedule Program
Backend
Create Schedule
Oracle EBS R12
How to Code
WOW! Did you like this post? We'll send more interesting posts like How to Schedule a
PDFmyURL lets you convert a complete website to PDF automatically!
concurrent program from Backend to you!
Enter your Email Address:
Enter your email address
Subscribe Me!
SQL Query to nd Status of Inventory
MD50, MD70 and MD120 Templates Free
Accounting Periods
0 Comments
Recommend
Download
OracleAppsDNA
Sort by Oldest
Share
Start the discussion
Subscribe
Add Disqus to your site
Login
Privacy
PDFmyURL lets you convert a complete website to PDF automatically!
How to make a
Concurrent Program...
How to get Concurrent
Request ID of a parent...
PL/SQL Script to Create
an Concurrent Program...
PL/SQL Script to Create a
Concurrent Program fr...
PL/SQL Script to Add a
Concurrent Program to...
A killer Auto Refresh
option on Concurrent...
How to Generate Trace
for a Seeded or...
Attaching Concurrent
Program Output as...
PDFmyURL lets you convert a complete website to PDF automatically!
