Suggest you to post in EBS General Discussion to get more visibility and response as this is generic Issue.
1 person found this helpful
Please find a solution pasted below:
Requirement: Manuals users should not be able to submit a concurrent program at a specific time frame:
Assume actual program name as: XXPGM
1. Create a wrapper program on top of the XXPGM and assign to Manual Users. [Manual users have access to only the custom wrapper program and not the actual program ]
[This wrapper program should not take more than 3 hours to implement :-) ]
2. Wrapper program will check if the time is an eligible time for the manual users to submit the program, if so then call the actual program from inside it, else post an output message that the program cannot be submitted at this time frame.
3. This exception time [start and end time ] can be maintained as a system profile option at site level [which allows any modification in future.].
Hope it helps!!, Thanks!!
Thanks for the suggestion!!! Could you please let me know how to create that wrapper .m just a beginner so don't have much knowledge .Any psedo code if you have that would be helpful.
,pv_err_msg IN OUT VARCHAR2)
ln_int_run_id NUMBER :=0;
vreqid NUMBER :=0;
--pv_ret_code:=0; -- Normal return
-- logic to check for time here
if to_char(sysdate,'HH:MI:SS') between 'from time' to 'to time' then
fnd_global.apps_initialize(fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);
vreqid := fnd_request.submit_request( application => 'SQLGL',
program => 'GLLEZL',
start_time => SYSDATE,
sub_request => FALSE,
argument1 => ln_int_run_id,
argument2 => pv_access_set_id,
argument3 => 'N',
argument4 => NULL,
argument5 => NULL,
argument6 => 'N',
argument7 => 'O', --N B4
argument8 => 'Y'
output ('user cant submit now');
Hope it Helps!!!
However what I want is only our batch user(say xx) should be able to run the program at any time and if its submitted by anyone else (there may be more than 1) ,it shouldn't allow that. For that matter we can also restrict the users to submit the program from a particular responsibility only.,it should only be submitted by (Sys Admin ) only coz in my case manual users use a different responsibility to submit a program.