How To Change Look And Feel and Colors Of Oracle Applications 11i and R12

There are two system profile options that can be used to change look and feel. 

1. Java Look and Feel.
   Java Look and Feel can have two values: GENERIC or ORACLE.
   If set to GENERIC, then set Java Color Scheme to blank.
   Which will leave look and feel to generic.
   The Generic look and feel adheres to the native interface and color scheme of the current operating system.
   If set to ORACLE (or if the value is left blank), then the profile option 'Java Color Scheme' can be used to personalize the colors of your screen.
2. Java Color Scheme.
   If 'Java Look and Feel' is set to ORACLE (or if the value is left blank), then 'Java Color Scheme' can be set to the following values:
   
   • Blaf        (in R12: Swan)
   • Blue
   • Khaki
   • Olive
   • Purple
   • Red
   • Teal
   • Titanium

Do the following: 

1. Login to Oracle Applications as the System Administator responsibility.
2. Navigate to Profile > System.
3. Ensure that the Site display is checked.
4. Query up 'Java Color Scheme' for the profile.
5. Select the appropriate color under the Site column.
6. Save the selection.
7. Sign off and back on (or change responsibility) for your new color scheme to take effect.

Be aware that the 'Java Color Scheme' profile has no effect if 'Java Look and Feel' is set to GENERIC.

Script to Delete XML publisher Data Definition or Template

In the XML Publisher's OA Framework pages, both Template and Data Definition pages do not provide an option to delete anything. As an alternative you may opt to run the below script to delete the unwanted records.

DECLARE
BEGIN 
DELETE FROM xdo_templates_b where   template_code = 
Delete   from XDO_TEMPLATES_TL  where template_code    = 
Delete   from xdo_lobs  where lob_code     = 
Delete   from XDO_DS_DEFINITIONS_TL  where data_source_code = 
Delete   from XDO_DS_DEFINITIONS_b   where data_source_code = 
END;

Introduction to OAF

Oracle Application Framework (OA Framework) is the Oracle E-Business Suite development and deployment platform for HTML-based business applications. OA Framework consists of a set of middle-tier runtime services and a design-time extension to Oracle JDeveloper called Oracle E-Business Suite Extension (OA Extension). 

OA Framework, is based on the industry-standard Model-View-Controller(MVC) design pattern and can be used to develop extensions to existing E-Business Suite functionality. Oracle Application (OA) enables you to personalize the layout of the user interface and the content it displays to suit your business needs. Oracle’s JDeveloper tool with an Oracle Applications extension is used for development for the Oracle Applications Framework and uses Java & XML languages for the same. The OA framework is also available to customers for personalizations, customizations and custom-application development.

Components of OAF

 1) BC4J(Business Component for Java) : Java business components for representing business logic.

 2) UIX(User Interface Xml) : Java components for representing UI.

3) OA Extension: Design time tool to define declarative data in JDeveloper. Data resides in Metadata Repository (MDS) or XML files in the file system.

4) OC4J(Oracle Component for Java) : The Java Virtual Machine, for running from  JDeveloper.

5) AOL/J : Applications authentication, authorization and Java services

6) OA Framework: Programmatic ‘glue’ which integrates these technologies. 

Characteristics of OAF 

·       Declarative and Rapid application development 

·       Consistent and Compelling UI Built-in durable 

·       Personalization 

·       Extensible UI and business logic 

·       J2EE based Java and XML 

Based on MVC architecture

General Ledger Queries

SELECT jeh.*

FROM gl_import_references gli

, xla_ae_lines xll

, xla_ae_headers xlh

, xla_distribution_links xld

, gl_je_lines gl

, po_lines_all pol

, po_line_locations_all pll

, po_distributions_all pod

WHERE 1=1

AND pod.line_location_id = pll.line_location_id

AND pll.po_line_id = pol.po_line_id

AND pol.po_header_id = poh.po_header_id

and gli.gl_sl_link_table = xll.gl_sl_link_table

AND gli.gl_sl_link_id = xll.gl_sl_link_id

AND xll.ae_header_id = xlh.ae_header_id

AND xld.ae_header_id = xlh.ae_header_id

AND jel.je_header_id = gli.je_header_id

AND jel.je_line_num = gli.je_line_num

AND xld.source_distribution_id_num_1 = pod.po_distribution_id

AND xld.source_distribution_type = 'PO_DISTRIBUTIONS_ALL'

AND xll.gl_sl_link_table = 'XLAJEL'

select jel.*

FROM gl_import_references gli

, xla_ae_lines xll

, xla_ae_headers xlh

, xla_distribution_links xld

, rcv_receiving_sub_ledger rsl

, gl_je_lines jel

WHERE gli.gl_sl_link_table = xll.gl_sl_link_table

AND gli.gl_sl_link_id = xll.gl_sl_link_id

AND xll.ae_header_id = xlh.ae_header_id

AND xld.ae_header_id = xlh.ae_header_id

AND jel.je_header_id = gli.je_header_id

AND jel.je_line_num = gli.je_line_num

AND xld.source_distribution_id_num_1 = rsl.rcv_sub_ledger_id

AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

AND xll.gl_sl_link_table = 'XLAJEL'

SELECT api.invoice_num

, jel.accounted_cr

, jel.creation_date

, jeh.*

FROM gl_import_references gli

, xla_ae_lines xll

, xla_ae_headers xlh

, xla_distribution_links xld

, ap_invoices_all api

, ap_invoice_lines_all apl

, ap_invoice_distributions_all adp

, gl_je_lines jel

, gl_je_headers jeh

WHERE 1 = 1

AND api.invoice_id = apl.invoice_id

AND apl.invoice_id = adp.invoice_id

AND apl.line_number = adp.invoice_line_number

AND gli.gl_sl_link_table = xll.gl_sl_link_table

AND gli.gl_sl_link_id = xll.gl_sl_link_id

AND xll.ae_header_id = xlh.ae_header_id

AND xld.ae_header_id = xlh.ae_header_id

AND jel.je_header_id = jeh.je_header_id

AND jel.je_header_id = gli.je_header_id

AND jel.je_line_num = gli.je_line_num

AND xld.source_distribution_id_num_1 = adp.invoice_distribution_id

AND xld.source_distribution_type = 'AP_PMT_DIST'

AND xll.gl_sl_link_table = 'XLAJEL'

How to open Oracle Apps R12 forms in Internet Explorer 11 (IE. 11)

1) In internet explorer 11 , navigate to Tools –> Compatibility View Settings . Then add Domain name in the URL (ex: orapps.com in erp.oraapps.com) using Add this website option.

2) Navigate to Tools –> Internet options –> Security . Select internet and click on Custom level. Scroll down till end of the options and change the option Enable XSS filter to  Disable.

3) Add EBS URL as Intranet Site in Internet Options to avoid most of the Java security related issues.

This solution worked for me and I am able to open R12 forms in Internet Explorer version 11