NAV_BAR

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Monday, September 23, 2019

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.

Tuesday, August 20, 2019

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;

Tuesday, July 9, 2019

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

Thursday, October 18, 2018

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'

Thursday, October 4, 2018

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