adding records to fnd_request_group_units and fnd_responsibility
I recently added a concurrent program. I have some custom code that initializes apps and submits the concurrent request. The problem I'm having is the select into isn't working because of missing records in fnd_request_group_units and fnd_responsibility.
SELECT fr.application_id, fr.responsibility_id, fcp.printer_name,
fcp.print_flag, fcp.output_print_style,
fcpt.user_concurrent_program_name
INTO napplid, nrespid, sprogprinter,
sprogprintflag, sprogprintstyle,
sprogdescription
FROM fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_responsibility fr
WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
0