EBS Customizations (MOSC)

MOSC Banner

adding records to fnd_request_group_units and fnd_responsibility

edited Mar 26, 2010 5:16AM in EBS Customizations (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center