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 = ; 

Oracle Database Architecture

Get the DDL script for a table/view -->

DBMS_METADATA.GET_DDL (
object_type IN VARCHAR2,
name IN VARCHAR2,
schema IN VARCHAR2 DEFAULT NULL
)
SELECT DBMS_METADATA.GET_DDL('VIEW','TEST_V','SYSTEM') FROM DUAL;

Things to Ponder:

• Work area size influences SQL Performance and can be automatically or manually managed.

DBA Basics

• View common db properties

SELECT Property_Name, Property_Value, Description
FROM Database_Properties

• Oracle Apps Release/Version from backend?

SELECT Release_name FROM Fnd_Product_Groups

• Multi-Org enabled?

SELECT Multi_Org_Flag FROM Fnd_Product_Groups

• Multilingual?

SELECT Multi_Lingual_Flag FROM Fnd_Product_Groups

• MRC Implemented?

SELECT Multi_Currency_Flag FROM Fnd_Product_Groups

• How do I find the tablespace name where I need to create the table in xyz schema?
  

Get the tablespace name using the below query:
SELECT * FROM dba_users WHERE username = 'xyz'
Tablespace details if required, can be viewed from dba_tablespaces table.