Printer issues in Oracle EBS

Printer Generic Queries:

SELECT NUMBER_OF_COPIES
     , NLS_LANGUAGE
     , NLS_TERRITORY
     , PRINTER
     , PRINT_STYLE
     , COMPLETION_TEXT
     , OUTPUT_FILE_TYPE
     , NLS_CODESET
     , OUTFILE_NODE_NAME
     , OUTFILE_NAME
  FROM APPS.FND_CONCURRENT_REQUESTS 
WHERE REQUEST_ID = ;

SELECT PRINTER_STYLE_NAME
     , SRW_DRIVER
     , WIDTH
     , LENGTH
     , ORIENTATION
  FROM apps.FND_PRINTER_STYLES
 WHERE PRINTER_STYLE_NAME =
        ( SELECT PRINT_STYLE
            FROM apps.FND_CONCURRENT_REQUESTS
           WHERE REQUEST_ID =
         );
         
SELECT PRINTER_DRIVER_NAME
     , USER_PRINTER_DRIVER_NAME
     , PRINTER_DRIVER_METHOD_CODE
     , SPOOL_FLAG
     , SRW_DRIVER
     , COMMAND_NAME
     , ARGUMENTS
     , INITIALIZATION
     , RESET
  FROM apps.FND_PRINTER_DRIVERS
 WHERE PRINTER_DRIVER_NAME = 
        ( SELECT PRINTER_DRIVER
            FROM apps.FND_PRINTER_INFORMATION
           WHERE PRINTER_STYLE =
                  ( SELECT PRINT_STYLE
                      FROM apps.FND_CONCURRENT_REQUESTS
                     WHERE REQUEST_ID=
                       AND PRINTER_TYPE = (
                             SELECT PRINTER_TYPE
                               FROM apps.FND_PRINTER
                              WHERE PRINTER_NAME = (
                                      SELECT PRINTER
                                        FROM apps.FND_CONCURRENT_REQUESTS
                                       WHERE REQUEST_ID =
                                                    )
                                           )
                  )
         );   
         
SELECT r.request_id, C.application_name, 
t.user_concurrent_program_name, a.basepath, 
e.execution_file_name, p.concurrent_program_name, 
p.execution_method_code, p.execution_options, 
p.output_file_type, p.save_output_flag, p.print_flag, 
p.minimum_width, p.minimum_length, 
p.output_print_style, p.required_style, p.printer_name, 
TO_CHAR(r.actual_completion_date, 'DD-MON-RR HH24:MI:SS'), 
r.logfile_node_name, r.logfile_name, r.outfile_name, 
r.ofile_size, r.nls_language, r.nls_territory, 
r.nls_codeset, r.is_sub_request, r.phase_code, 
r.status_code, r.completion_text, r.output_file_type, 
r.number_of_copies, r.printer, r.print_style, 
s.width, s.length, s.srw_driver, n.printer_type, 
i.printer_style, i.printer_driver, 
d.srw_driver,printer_driver_method_code, 
spool_flag, stdin_flag, d.command_name, d.arguments, 
d.initialization, b.responsibility_name, r.argument_text,u.user_name 
FROM apps.fnd_concurrent_programs_tl t, 
apps.fnd_concurrent_programs p, apps.fnd_executables e, 
apps.fnd_application a, apps.fnd_application_tl c, 
apps.fnd_concurrent_requests r, apps.fnd_printer n, 
apps.fnd_printer_information i, apps.fnd_printer_drivers d, 
apps.fnd_languages l, apps.fnd_responsibility_tl b, apps.fnd_user u, 
apps.fnd_printer_styles s 
WHERE c.application_id = t.application_id 
and c.application_id = a.application_id 
and r.concurrent_program_id = t.concurrent_program_id 
and t.concurrent_program_id = p.concurrent_program_id 
and p.executable_id = e.executable_id 
and n.printer_name = r.printer 
and (n.printer_type = i.printer_type) 
and (i.printer_driver = d.printer_driver_name) 
and d.platform_code is NULL 
and i.printer_style = r.print_style 
and r.responsibility_id = b.responsibility_id 
and b.language = l.language_code 
and r.requested_by = u.user_id 
and r.nls_language = l.nls_language 
and i.printer_style = s.printer_style_name 
and l.language_code = t.language 
and l.language_code = c.language 
and r.request_id = ; 

AOL - Elementary

1. Use the 'Organization Access' [R -> System Administrator] form to map responsibility with access to one or more org. Backend --> org_access_v
2. a
3. Flexfields:

Key Flexfields (KFF) --> Owned by one application, used by many. Required to setup, usage is optional. Support intelligent keys. 

Descriptive Flexfields (DFF) --> Associated with tables in specific application. Setup optional. No intelligence, stores additional info. 

Profile Options - AOL

There are four possible levels at which system administrators can view and update a profile option value: site, application, responsibility, and user.

• FND: Enable Cancel Query [ Yes (default) / No ] - Option to cancel the form query if taking long time
• Concurrent: Active Request Limit - Limits the number of requests that may be run simultaneously by each user or for every user at a site. If you do not specify a limit, no limit is imposed. Users cannot see or update this profile option. This profile option is visible and updatable at all four levels.