ORACLE

ORACLE
Let us share our knowledge to the world of oracle apps. I am trying my best to do so and I request every one to contribute their part. If you have any thing useful related to oracle apps, do send me I will post in my blog on behalf of you. If you like my blog tell the world about it, else tell me i will improve. You can suggest me, what exactly you want on oracle apps. Mail your queries.

Wednesday, December 28, 2011

For attaching the concurrent program to the request group.

This blog is about attaching concurrent program in a request group through Standard API..

If we need to attach some 'n' number of concurrent program please follow these few steps and acheive it,
No need to login to application and no need to worry about that we didn't have sysadmin responsibilty.

1) Create a excel with following details
      program_short_name,
      application,
      Report Group Name,
      Report Group Application
2) load that excel values in a staging tabel and do validation if requried
3)Attach your concurrent program in requried request group with below said Standard API.. 

PROMPT Adding Concurrent program to request group 'XYZ Group'
PROMPT
BEGIN
FND_PROGRAM.add_to_group('XYZ_ABC_EMPLOYEE' -- program_short_name, 'XYZ' -- application, 'XYZ Group' -- Report Group Name, 'XYZ'); -- Report Group ApplicationEND;
/

No comments:

Post a Comment