Friday, November 5, 2010

Register concurrent program with request group.

Most of us came across a situation where
after defining(promoting) a concurrent program ,to make other users be able to
run the program we need to add the program to a request group(which we used to
do by navigation through security->responsibility->Request).
The same can be achieved by running package FND_PROGRAM as foloows.

DECLARE
BEGIN
FND_PROGRAM.add_to_group
(
PROGRAM_SHORT_NAME =>'XX_XXXXXX'
,PROGRAM_APPLICATION =>'AR'
,REQUEST_GROUP =>'Receivables All'
,GROUP_APPLICATION =>'AR'
) ;
commit;
exception
when others then
dbms_output.put_line('Object already exists');
END ;
/

No comments:

Post a Comment