Oracle Database 10g full database export .

http://sabdarsyed.blogspot.qa/2006/12/to-take-full-database-export-oracle-10g.html Step 1 Create a Export Directory: On Windows: ----------- SQL> create or replace directory sys_dmp as 'D:\expdp'; Directory created. On Solaris: ----------- SQL> create or replace directory sys_dmp as '/u02/expdp'; Directory created. Step 2 Create a separate export user: ############################## SQL> Connect /as sysdba SQL> CREATE USER expdpadmin IDENTIFIED BY expdp default tablespace users; User created. Step 3 Grant Export and Import Privileges. ################################### SQL> GRANT CONNECT,RESOURCE TO expdpadmin; Grant succeeded. SQL> GRANT exp_full_database to expdpadmin; Grant succeeded. SQL> alter user expdpadmin quota unlimited on USERS; User altered. SQL> GRANT READ, WRITE ON DIRECTORY SYS_DMP to expdpadmin; Grant succeeded. To check on which directories you have privilege to read & write: ################################################################# SQL> SELECT privilege, directory_name 2 FROM user_tab_privs t, all_directories d 3 WHERE t.table_name(+)=d.directory_name 4 ORDER BY 2,1; Step 4 Exporting Full Database: ######################## expdp expdpadmin/XXXXXX full=y directory=sys_dmp dumpfile=full_db_expdp.dmp logfile=full_db_expdp.log

Accessing Oracle E-Business Suite from a Desktop Client

Administrator privileges are required for installing all JRE Plug-in versions on the desktop client. IE Browser Settings for User Download of the Java Plug-in (oaj2se.exe) Oracle recommends that customers running Oracle E-Business Suite through a Microsoft Internet Explorer (IE) browser should use a 'Medium' security setting through the 'Trusted Sites' zone in the browser at runtime. Further information on browser settings are available from Document 389422.1 titled, 'Recommended Browsers for Oracle E-Business Suite Release 12'. If the appropriate Plug-in or higher is not already installed on the desktop client, you should be prompted to download it when trying to connect to a 'forms link' through an Oracle E-Business Suite forms-based (professional user interface) responsibility. Note: The oaj2se.exe can usually be downloaded manually by adding '/OA_HTML/oaj2se.exe' to the base url of the environment. For example; if the base url of the environment was 'https://server1.example.com:4443', you could run 'https://server1.example.com:4443/OA_HTML/oaj2se.exe'. With a medium security setting, after clicking on a 'forms link', a message similar to the following should appear at the top of the browser window; JRE 6 Users "The website wants to install the following add-on: 'Java(TM) Runtime Environment 6.0 Update 38' from 'Sun Microsystems, Inc.'. If you trust this website and the add-on and want to install it, click here..." JRE 7 Users 'The website wants to install the following add-on: 'Java SE Runtime Environment 7.0 Update 10' from 'Oracle America, Inc.'. If you trust this website and the add-on and want to install it, click here...' If you see this message, follow the steps below to install the Plug-in: Click on the message above and select 'Install ActiveX Control...' Once the browser has stopped processing, click on the 'forms link' again, and the oaj2se.exe file should start to download Once the download has completed, a security warning pop-up window will ask, 'Do you want to install this software?' Click on the 'Install' button and follow the on screen instructions Alternatively, you can avoid this message by temporarily altering the security settings for the initial install, using one of the two methods below. Once the Plug-in has been installed on the desktop client, the browser security settings should be reset to 'medium'. Method A: Change Security Setting to Medium-low Select 'Tools' -> 'Internet Options -> 'Security' (Tab)' from the browser menu. Select 'Trusted Sites' -> 'Custom Level' (button) From the 'Reset custom settings' drop down select 'Medium-low' Click the 'Reset...' button and accept the changes. Press the 'OK' buttons on the 'Security Settings' and 'Internet Options' windows. Close the browser and start a new browser session for the settings to take effect. After launching Oracle E-Business Suite and downloading the oaj2se.exe file onto your desktop client, please reset the security setting back to 'Medium'. Method B: Change Individual Parameter Settings Select 'Tools' -> 'Internet Options -> 'Security' (Tab)' from the browser menu. Select 'Trusted Sites' -> 'Custom Level' (button) Under 'Settings' -> 'ActiveX controls and Plug-ins' Change 'Automatic prompting for ActiveX controls' to 'Enable' Change 'Download unsigned ActiveX controls' to 'Prompt' Click the 'OK' button and accept the changes and click the 'OK' buttons to close the window Close the browser and start a new browser session for the settings to take effect. After launching Oracle E-Business Suite and downloading the oaj2se.exe file onto your desktop client, please reset 'Automatic prompting for ActiveX controls' to 'Disable' and 'Download unsigned ActiveX controls' to 'Disable. Connecting to an Oracle E-Business Suite Instance for the First Time "The application's digital certificate cannot be verified. Do you want to run the application?" If accessing Oracle E-Business Suite using a Forms-based (Professional user interface) responsibility where the Java certificate for the environment you are accessing has not previously been installed into the Java certificate store, the following warning window will display: JRE 7 Users JRE 7u40 and Higher Users If your Jar files are still signed with a self-signed certificate, the option to 'remember the decision' for future logins has been removed in JRE 1.7.0_40 (7u40) and later. This warning message will therefore appear each time you start a new session requiring the user to agree to accept the risk before running. JRE 7u40 Security Warning Tick the checkbox and click the 'Run' button to open the form. To prevent this security window popping it is recommended that you sign all your jars using a trusted certificate authority (CA). Signing can be done using either an official CA (such as Verisign, Thawte etc.) or an in-house CA. For further information on Jar signing requirements see Document 1591073.1 titled, 'Enhanced JAR File Signing for Oracle E-Business Suite'. Running with a Self-Signed Certificate If your Jars are signed with a self-signed certificate you can still launch Java content and also prevent this window from popping by utilizing a Deployment Rule Set. However, the DeploymentRuleSet.jar file must itself be signed with a certificate from a Trusted CA, either an official CA (such as Verisign, Thawte etc.). If your Jars are signed with a self-signed certificate you can also still launch Java content using a self-signed certificate by utilizing the Exception Site List feature from the desktop. However, this will not suppress this warning message. Users will still be required to respond to this warning each time they launch a new session. JRE 7u21 and Lower Users If accessing Oracle E-Business Suite using a Forms-based (Professional user interface) responsibility where the Java certificate for the environment you are accessing has not previously been installed into the Java certificate store, the following, or similar, security warning window will display: JRE 7 Java certificate warning Check the 'I accept the risk and want to run this application' box to verify you trust the certificate. Click the 'Hide Options' button and check 'Do not show this again for apps from the publisher and location above'. Click the 'Run' button to open the form. Once the certificate has been successfully installed, this message will not appear again when accessing this environment from your desktop client. JRE 6 Users JRE 6u60 and Lower Users JRE 6 certificate warning Check 'Always trust content from this publisher' to verify you trust the certificate. Click the 'Run' button to open the form. Once the certificate has been successfully installed, this message will not appear again when accessing this environment from your desktop client. JRE 6u65 and Higher Users To further enhance Java security the option to install the certificate into the Java certificate store and remember the decision for future logins when using self-signed certificates has been removed in JRE 1.6.0_65 (6u65) and higher. This warning message will therefore appear each time you start a new session if using self-signed certificates. To prevent this message appearing sign your jar files using a trusted CA by following Document 1591073.1. JRE 6u65 certificate warning Click the 'Run' button to open the form. Note: If you are using a self-signed certificate for jar signing the Publisher will display as UNKNOWN in the Java 'Warning - Security' window as shown above. This is an intended change in behavior to avoid misrepresentation and spoofing attacks. Trusted signing authorities will continue to display the publisher name as in previous JRE Plug-in releases. Uninstalling a JRE Plug-in Version from your Desktop Client To uninstall a jre Plug-in version from your Windows desktop client, follow the steps appropriate to the version of Windows you are using. Windows XP To uninstall a JRE Plug-in version from your desktop client: 1. From the Windows 'Control Panel', click on 'Add or Remove Programs'. 2. Select the appropriate version of 'Java 2 Runtime Environment' and click 'Remove'. 3. Select the appropriate options in the dialogs which follow. Windows Vista and Windows 7 To uninstall a JRE Plug-in version from your desktop client: 1. From the Windows 'Control Panel' click on 'Programs and Features'. 2. Select the appropriate version of 'J2SE Runtime Environment' and click the 'Uninstall' button. 3. Select the appropriate options in the dialogs which follow. (An administrator's password is required for this). Reverting to a Previous Java Plug-in Version If you wish to revert back to previously installed version of the Java Plug-in to be used in the Oracle E-Business Suite, please re-install the required version by re-running the txkSetPlugin script with the appropriate parameters. Running this script is explained in Step 5.1. Run the JRE Upgrade Script (Unix Users) and Step 3.2. Run the JRE Upgrade Script (Windows Users). This will automatically update the JRE parameters in the configuration files of your Web Application Tier.

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)

Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

http://1lyoracleapps.blogspot.qa/ Select 'Tools' -> 'Internet Options -> 'Security' (Tab)' from the browser menu. Select 'Trusted Sites' -> 'Custom Level' (button) Under 'Settings' -> 'ActiveX controls and Plug-ins' Change 'Automatic prompting for ActiveX controls' to 'Enable' Change 'Download unsigned ActiveX controls' to 'Prompt' Click the 'OK' button and accept the changes and click the 'OK' buttons to close the window Close the browser and start a new browser session for the settings to take effect. After launching Oracle E-Business Suite and downloading the oaj2se.exe file onto your desktop, please reset 'Automatic prompting for ActiveX controls' to 'Disable' and 'Download unsigned ActiveX controls' to 'Disable'. Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1) In This Document Section 1: Overview Section 2: Microsoft Internet Explorer (IE) for Windows Users Section 3: Firefox (FF) for Windows Users Section 4: Chrome for Windows Users Section 5: Safari for Mac Users The most current version of this document can be obtained in Document 389422.1 There is a change log at the end of this document. Section 1: Overview This document outlines the requirements for browsers that are certified for use with Oracle E-Business Suite R12. Browsers may require specific patches for compatibility with Oracle E-Business Suite. Such patches are backwards compatible with earlier browser releases. For example, after installing the required Internet Explorer 11 patches you will still be able to access your environment using earlier Internet Explorer versions as well as alternative browsers. Microsoft Edge Browser The certification of Microsoft Edge on Windows 10 with Oracle E-Business Suite 12.1 and 12.2 is currently in progress. Oracle E-Business Suite R12 has two interfaces: a web-based (OA Framework/HTML) model for modules like iProcurement and iStore, and Oracle Forms/Java based model for our professional services modules like Oracle Financials. Microsoft Edge does not support Java and will therefore only be certified for E-Business Suite customers running web-based (HTML / OA Framework) screens, running Java based content with Edge will not supported. Note: The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracles products remains at the sole discretion of Oracle. Section 2: Internet Explorer (IE) for Windows Users Internet Explorer: Certification Matrices Internet Explorer: Prerequisite Patch Requirements Internet Explorer: Recommended Browser Settings Internet Explorer: Importing an SSL Certificate Internet Explorer: Running IE10 and IE 11 in 64-bit Mode Internet Explorer: Known Issues IE Alert: Java(TM) was blocked because it is out of date and needs to be updated From the 9th September 2014 Internet Explorer has started blocking out of date ActiveX controls running through any security zone except the 'Local intranet' or the 'Trusted sites' zones when using IE 8 or later. Trying to run any Java content from your desktop using older JRE releases, prior to the latest CPU's on any JRE stream, through any other zone for example the 'Internet' zone will now be blocked. This issue may therefore affect Oracle E-Business Suite users trying to access forms and any other Java content. Further information on this latest security feature is available from this Microsoft announcement and its associated links. Oracle's recommendation has always been to run Oracle E-Business Suite through the 'Trusted sites' zone as outlined under the Internet Explorer: Recommended Browser Settings section within this document. Users that have followed this advisory or run their environments through the Local Intranet zone will not be affected by this change within IE. Users that are running their Oracle E-Business Suite environments through any other zone and are also using an old JRE version on any stream will not be able to access forms or any other Java content. Microsoft provide a workaround in their documentation to turn this feature off which can be used to workaround this issue if desired. However, Oracle continues to recommend running your Oracle E-Business Suite environments to through the 'Trusted sites' zone of the browser which will avoid this issue occurring. Upgrading to the latest and therefore most secure JRE version will also prevent Java content being blocked from any IE security zone. For information on upgrading to the latest JRE releases see Document 393931.1 titled, 'Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12'. Internet Explorer: Certification Matrices Certification Matrix for Internet Explorer (64-bit) Browsers The table below outlines the certified combinations of 64-bit Internet Explorer Browser, Windows Desktop Client Operating System and JRE (64-bit) streams with minimum versions, where applicable. Please also review this document for further specific certification information and requirements: Browser Version Windows 10 (64-bit) Windows 8.1 (64-bit) Windows 8 (64-bit) Windows 7 (64-bit) IE 11 (64-bit) 1 JRE 1.8.0_51 (64-bit) and higher JRE 1.7.0_85 (64-bit) and higher JRE 1.8.0_25 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher JRE 1.6.0_37 (64-bit) and higher Not Certified JRE 1.8.0_25 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher JRE 1.6.0_32 (64-bit) and higher IE 10 (64-bit) 1 Not Certified Not Certified JRE 1.8.0_25 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher JRE 1.6.0_37 (64-bit) and higher JRE 1.8.0_25 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher JRE 1.6.0_32 (64-bit) and higher IE 9 (64-bit) Not Certified Not Certified Not Certified JRE 1.8.0_25 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher JRE 1.6.0_32 (64-bit) and higher IE 8 (64-bit) Not Certified Not Certified Not Certified JRE 1.7.0_10 (64-bit) and higher JRE 1.6.0_32 (64-bit) and higher 1 Internet Explorer is only certified running Desktop Mode on Windows 8 and higher. The Metro version does not support Java and is not certified for Oracle E-Business Suite Certification Matrix for Internet Explorer (32-bit) Browsers The table below outlines the certified combinations of 32-bit Internet Explorer Browser, Windows Desktop Client Operating System and JRE (32-bit) streams with minimum versions, where applicable. Please also review this document for further specific certification information and requirements: Browser Version Windows 10 (32-bit & 64-bit) Windows 8.1 (32-bit & 64-bit) Windows 8 (32-bit & 64-bit) Windows 7 (32-bit & 64-bit) Windows Vista (32-bit) Windows XP (32-bit) 2 IE 11 1 JRE 1.8.0_51 and higher JRE 1.7.0_85 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_37 and higher Not Certified JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher Not Certified Not Certified IE 10 1 Not Certified Not Certified JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_37 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher Not Certified Not Certified IE 9 Not Certified Not Certified Not Certified JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher Not Certified IE 8 Not Certified Not Certified Not Certified RE 1.7.0_10 and higher JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher IE 7 Not Certified Not Certified Not Certified Not Certified JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher Unsupported Browsers (Included for Historical Purposes) 3 IE 6 Not Certified Not Certified Not Certified Not Certified Not Certified JRE 1.7.0_10 and higher JRE 1.6.0_03 and higher 1 Internet Explorer is only certified running Desktop Mode on Windows 8 and higher. The Metro version does not support Java and is not certified for Oracle E-Business Suite 2 Windows XP was desupported by the vendor in April 2014, see 3rd Party Software Support Lifecycle. 3 Unsupported Browsers (Included for Historical Purposes) - IE6 was desupported by the vendor is April 2014, see 3rd Party Software Support Lifecycle. It is recommended that users upgrade to a later release of the browser. Compatibility with Higher JRE releases Oracle has certified the Oracle E-Business Suite with the minimum JRE releases noted above on the JRE 6 (1.6.0.x) stream. Oracle E-Business Suite end-users may use or upgrade to later production releases of the JRE plug-in on, either stream, at their discretion. It is recommended to upgrade to the latest certified JRE releases to uptake the latest security and functional fixes. For further information on upgrading JRE and it's requirements and known issues, please reference Document 393931.1 titled, 'Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12'. Oracle will continue to test and certify the Oracle E-Business Suite with selected future versions of JRE releases in advance of their general availability to the public. Oracle will update this documentation with known compatibility issues or workarounds as needed. 3rd Party Software Support Lifecycle Oracle's support of the various third party client operating system, service pack levels and browsers aligns with the respective vendor's support life cycle. Support timelines as well as Internet Explorer, Windows desktop operating system and service pack requirements are available from Microsoft. Internet Explorer: Prerequisite Patch Requirements Internet Explorer 11 (32-bit and 64-bit) Windows 8.x (32-bit and 64-bit) Internet Explorer 8, 9 & 10 (64-bit) Internet Explorer 10 (32-bit) Internet Explorer 9 (32-bit) Internet Explorer 8 (32-bit) Internet Explorer 7 (32-bit) with Windows Vista Internet Explorer 11 (32-bit and 64-bit) Oracle E-Business Suite 12 is not certified with IE11 using either 'Enterprise Mode' or 'Compatibility View'. Enterprise Mode: Internet Explorer 11 includes an 'Enterprise mode' which can be used to emulate Internet Explorer 8 behavior and provide compatibility for earlier browser standards. This should not be used with Oracle E-Business Suite as it will have no effect on certain issues. If you need to use 'Enterprise Mode' for other applications then EBS should be added as an exception to bypass it . Compatibility View: Due to Display Issues in FWK (IE9 and 10) it was previously recommended to run E-Business Suite using the browsers 'Compatibility View'. These display issues have been fixed for IE11 through the General IE 11 Patch Requirements listed below. Once you have applied the prerequisite patches, you should run E-Business Suite pages without enabling the 'Compatibility View' feature in the browser. You can check this by navigating to Internet Explorer 11 -> Tools -> Compatibility View settings, and ensuring that; (a) your instance domain is NOT part of the Compatibility View settings, and (b) the 'Display intranet sites in Compatibility View' is unchecked. Users must apply the recommended prerequisite patches listed within this section to fix compatibility issues with Oracle E-Business Suite 12. General IE 11 Prerequisite Patch Requirements To use IE11 with Oracle E-Business Suite 12, apply the following patches (or later) including any further prerequisite patch requirements as stated in the patch readme files as applicable to your EBS release. Product Requirements EBS 12.2 EBS 12.1 EBS 12.0.6 General Requirements Patch 20007138:R12.TXK.C Note 1 Patch 20518047:R12.FWK.C Note 2 Patch 19863340:R12.FND.C Patch 19195514:R12.JTT.C Patch 9239090:12.1.3 Release Update Pack Patch 18936791:R12.FWK.B.delta.4 Patch 17932167:R12.TXK.B Patch 20986782:R12.CC_PF.B Note 3 Patch 19845055:R12.FWK.A Patch 17932167:R12.TXK.A Patch 19854889:R12.JTT.A Patch 19879618:R12.FND.A Note 1Patch 20007138:R12.TXK.C must be applied first, before applying Patch 20518047:R12.FWK.C. Note 2 Patch 20518047:R12.FWK.C has superceded the previously recommended Patch 19855051:R12.FWK.C. Note 3 Patch 20986782:R12.CC_PF.B has superceded the previously recommended Patch 19659562:R12.CC_PF.B. On environments where Patch 17931904:R12.FND.B had not been installed Patch 19659562:R12.CC_PF.B would fail to compile certain jsp files e.g. jtffmcr1.jsp. The FND patch has now been included in Patch 20986782:R12.CC_PF.B to prevent this issue. Additional Product Specific IE 11 Patch Requirements WebADI and Report Manager users must also apply the product specific patch(es) listed below to use Internet Explorer 11 as applicable to your EBS release. Product Requirements EBS 12.2 EBS 12.1 EBS 12.0.6 WebADI (BNE) Patch 19907901:R12.BNE.C Patch 19273341:R12.BNE.B.delta.4 Patch 19907888:R12.BNE.A Report Manager (FRM) Patch 19900999:R12.FRM.C Patch 19559960:R12.FRM.B.Delta.4 Patch 19901003:R12.FRM.A Windows 8.x (32-bit and 64-bit) Oracle E-Business Suite is certified on Windows 8 (32-bit & 64-bit) running Internet Explorer 10 in 'Desktop Mode' (running from the 'Metro Screen' (Start Screen) is not supported) with the following patch requirements: Oracle E-Business Suite Release 12.2. Oracle E-Business Suite Release 12.1 with E-Business Suite 12.1.3 Release Update Pack (Patch 9239090). Oracle E-Business Suite Release 12.0 with R12.ATG_PF.A.DELTA.6 (Patch 7237006) or higher Oracle forms 10.1.2.3 or higher WebADI and Report Manager Users WebADI and Report Manager have prerequisite patch requirements when running on Windows 8, for further information see Document 1077728.1 titled, 'Using Microsoft Office 2007 and 2010 with Oracle E-Business Suite 11i and R12'. Known Issues For known issues see Windows 8 Specific Issues Internet Explorer 8, 9 & 10 (64-bit) Internet Explorer 8 (64-bit), Internet Explorer 9 (64-bit) and Internet Explorer 10 (64-bit) are certified as client browser's on Windows 7 (64-bit) with the following patch requirements: Oracle E-Business Suite Release 12.2 or higher. Oracle E-Business Suite Release 12.1.1 or higher. Oracle E-Business Suite Release 12.0 with R12.ATG_PF.A.DELTA.6 (Patch 7237006) or higher Oracle forms 10.1.2.3 or higher Internet Explorer 10 (32-bit) Internet Explorer 10 (32-bit) is certified as a client browser on Windows 7 (32-bit & 64-bit) with the following patch requirements: Oracle E-Business Suite Release 12.2 or higher. Oracle E-Business Suite Release 12.1.1 or higher. Oracle E-Business Suite Release 12.0 with R12.ATG_PF.A.DELTA.6 (Patch 7237006) or higher Oracle forms 10.1.2.3 or higher Internet Explorer 9 (32-bit) Internet Explorer 9 (32-bit) is certified as a client browser on Windows Vista and Windows 7 (32-bit & 64-bit) with the following patch requirements: Oracle E-Business Suite Release 12.2 or higher. Oracle E-Business Suite Release 12.1.1 or higher. Oracle E-Business Suite Release 12.0 with R12.ATG_PF.A.DELTA.6 (Patch 7237006) or higher Oracle forms 10.1.2.3 or higher Internet Explorer 8 (32-bit) Internet Explorer 8 (32-bit) is certified as a client browser on Windows XP (32-bit), Windows Vista (32-bit) and Windows 7 (32-bit & 64-bit) with the following patch requirements: Oracle E-Business Suite Release 12.2 or higher. Oracle E-Business Suite Release 12.1.1 or higher. Oracle E-Business Suite Release 12.0 with R12.ATG_PF.A.DELTA.6 (Patch 7237006) or higher Oracle forms 10.1.2.3 or higher Internet Explorer 7 (32-bit) with Windows Vista Internet Explorer 7 (32-bit) is certified as a client browser on Windows Vista (32-bit) with the following patch requirements: Oracle E-Business Suite Release 12.2 or higher. Oracle E-Business Suite Release 12.1.1 or higher. Oracle E-Business Suite Release 12.0, with R12.ATG_PF.A.DELTA.3 (patch 6077669) or higher. Internet Explorer: Recommended Browser Settings Security Zones Microsoft Internet Explorer offers four different security zones to run your application through. Which zone is used is dependant how you are accessing your site (Internet or Local Intranet) and set up within the zones themselves (Trusted sites & Restricted sites). It is advisable to have the security setting at Medium for run-time use. The Security Internet Options on Microsoft Internet Explorer can be accessed by going to: Tools -> Internet Options -> Security tab from the Internet Explorer Menu Bar. Each zone carries its own default security level that may need to be adjusted when accessing Oracle E-Business Suite through it. The defaults are as follows: Zone Usage Default for IE7 & Higher Default for IE6 Internet Web sites not placed in other zones Medium-high Medium Local Intranet Web sites on your organization's intranet Medium-low Medium-low Trusted Sites Web sites you trust not to damage your computer Medium Low Restricted Sites Web sites that could potentially damage your computer High High NOTE: It is recommended that Oracle E-Business Suite is run through the 'Trusted Sites' zone, with a 'Medium' Security Setting. Trusted Sites Zone Certain products and functions within Oracle E-Business Suite require the manipulation of the default browser security zone settings to function correctly. Altering security settings in the Internet Zone is not recommended because you are accessing more widespread web data of which you may not know the source. The Trusted Sites zone allows you to precisely control which specific sites or domains will be accessed through this zone. This allows you, if required, to manipulate the settings with minimal security risk. Setting up Oracle E-Business Suite to run through the 'Trusted Sites' zone with a 'Medium' Security Setting. Step 1: Select Tools -> Internet Options -> Security tab -> Trusted Sites icon -> Sites (button) from the Internet Explorer Menu Bar. Step 2: If required, set the Security Level for this Zone to Medium. Step 3: In the Add this Web site to the zone: field, enter the 'hostname and domain' of your Oracle E-Business Suite environment, e.g. https://., then click the Add button. Alternatively you can simply add the domain name preceded by *, so that all sites under that domain go through this zone, e.g. *. Note: If you are entering an http://... or *.domain address, you must first uncheck the Require server verification (https:) for all sites in this zone check box. You may re-check this steeing again after entering your values. Internet Explorer Browser Settings for User Download of oaj2se.exe Oracle recommends that customers running Oracle E-Business Suite through Internet Explorer (IE) should use a 'Medium' security setting through the 'Trusted Sites' zone in the browser at runtime. This setting does not automatically download the oaj2se.exe file from the middle tier if the user does not already have the appropriate version installed on their desktop. The JRE plug-in will download and install from the webserver on a medium security setting. After clicking on a 'forms link', a message similar to the following will appear at the top of the browser window: 'The website wants to install the following add-on: 'J2SE Runtime Environment 6 Update 3' from 'Sun Microsystems, Inc.'. If you trust this website and the add-on and want to install it, click here...' To install the plug-in:- Click on the message above and select 'Install ActiveX Control...' Once the browser has stopped processing, click on the 'forms link' again, and the oaj2se.exe file should start to download Once the download has completed, a security warning pop-up window will ask, 'Do you want to install this software?' Click on the 'Install' button and follow the on screen instructions Alternatively, to enable the download of this file, the user should temporarily alter the security settings within their browser using one of the two methods below: Method A: Change Security Setting to Medium-low Select 'Tools' -> 'Internet Options -> 'Security' (Tab)' from the browser menu. Select 'Trusted Sites' -> 'Custom Level' (button) From the 'Reset custom settings' drop down select 'Medium-low' Click the 'Reset...' button and accept the changes. Press the 'okay' buttons to close the window. Close the browser and start a new browser session for the settings to take effect. After launching Oracle E-Business Suite and downloading the oaj2se.exe file onto your desktop, please reset the security setting back to 'Medium' Method B: Change Individual Parameter Settings Select 'Tools' -> 'Internet Options -> 'Security' (Tab)' from the browser menu. Select 'Trusted Sites' -> 'Custom Level' (button) Under 'Settings' -> 'ActiveX controls and Plug-ins' Change 'Automatic prompting for ActiveX controls' to 'Enable' Change 'Download unsigned ActiveX controls' to 'Prompt' Click the 'OK' button and accept the changes and click the 'OK' buttons to close the window Close the browser and start a new browser session for the settings to take effect. After launching Oracle E-Business Suite and downloading the oaj2se.exe file onto your desktop, please reset 'Automatic prompting for ActiveX controls' to 'Disable' and 'Download unsigned ActiveX controls' to 'Disable'. Microsoft Office with WebADI For patch requirements and required browser settings required to integrate Microsoft Office with Oracle E-Business Suite, see Document 1077728.1. Page Refresh When using Oracle Self-Service products it is important to ensure that the most current data is being viewed. You may check if the page has been updated since your last visit by manually refreshing the page, however it is desirable for this to be done automatically through IE by setting the following parameter from the browser menu as follows: IE7 and Higher Users Select Tools -> Internet Options -> General tab -> Browsing History -> Settings (button). Select Every time I visit the webpage. With this option set Internet Explorer will check if the page has changed since it was last viewed. IE6 Users Select Tools -> Internet Options -> General tab -> Settings (button). Select Every visit to the page. With this option set Internet Explorer will check if the page has changed since it was last viewed. Shared Desktop Security If multiple users share the same desktop, they may be able to view a previous users browser content by pressing the 'Back' button on the browser. To avoid this issue set the Force Page Refresh profile option to Yes at Site level in your Oracle E-Business Suite 12 instance. For security reasons, if a PC is shared by multiple users it is also advisable not to save encrypted pages onto the drive by navigating to Tools -> Internet Options -> Advanced tab -> Security settings and ticking Do not save encrypted pages to Disk. Exception: SSL users who export Discoverer Workbooks to excel must leave the Do not save encrypted pages to Disk parameter unchecked. AutoComplete in Internet Explorer IE can automatically show previous values entered in the same form field. For privacy and security reasons this feature should be disabled as follows: Go to Tools -> Internet Options -> Content -> AutoComplete -> Settings (button) Uncheck the Forms and User names and passwords on form check boxes. HTTP 1.1/Keep Alive Settings Users should have the HTTP 1.1/Keep Alive option enabled. To set this option, navigate to the following parameters from the browser menu and ensure they are checked: Tools -> Internet Options -> Advanced tab -> HTTP 1.1 Settings: Use HTTP 1.1. Use HTTP 1.1 through proxy connections. Internet Explorer: Importing an SSL Certificate Note: Windows 8 and higher users may be required to run with elevated privileges to install an SSL certificate into the browser Connecting to a Secure Socket Layer (SSL) enabled environment requires the certificate to be 'Trusted'. If the certificate is not from a trusted authority or has not previously been trusted on the client, it must be verified at runtime. When accessing such an environment it will return the following warning message: 'There is a problem with this website's security certificate'. Using the automatic default install button may cause the certificate to be added to the browser's 'Intermediate Certification Authorities' folder and not the required 'Trusted Root Certification Authorities' folder. Therefore the security message will still display. If the certificate has wrongly been installed into the 'Intermediate Certification Authorities' please remove it through the browser and re-install into the 'Trusted Root Certification Authorities' folder. Installing an SSL certificate into the Browsers Trusted Certificates folder requires the browser's security option 'Enable Protected Mode' to be disabled (not checked), which is the default setting in the 'Trusted Sites' zone. This feature is only available in Internet Explorer for Vista and Windows 7 and does not exist in the XP versions of the browser. (If required, 'Enable Protected Mode' may be enabled (checked) after the certificate has been installed for runtime use). To trust the certificate authority and prevent the error page appearing on future logins, install it as follows: Enter the URL in the browser From the browser menu select: Tools -> Internet Options -> Security -> Trusted Sites icon. Security setting should be 'Medium' by default Make sure the 'Enable Protected Mode' option is off (not checked) Click the 'Sites' button and add the url if it is not there already (or add *.oracle.com to cover all Oracle environments, you must uncheck the 'Require Server Verification....' option first to allow you to add it) Save the changes and close the browser window Enter the URL in a new browser window You will again see a message saying 'There is a problem with this website's security certificate'. Click on, 'Continue to this website (not recommended)'. In the task bar click on the Red certificate error An Untrusted Certificate Window Pops, click on 'View Certificates' Click on Certification Path 'Tab' Highlight the Root certificate (will probably have a white cross in a red background next to it) and press 'View Certificate' Click on Install Certificate 'button' and press next Select 'Place all the certificates in the following store' Click 'Browse' and tick the 'Show physical Stores' box. Click the + next to 'Trusted Root Certification Authorities' folder If a folder exists called 'Local Computer' Click on it and select 'Okay' If that folder does not exist, highlight 'Trusted Root Certification Authorities' folder and select 'Okay' Press 'Next' followed by 'Finish' When the Security Window pops asking if you wish to install it, say 'Yes' then hit the 'finish' button Close the pop-up and the browser, when you next login, it should be fine. If the install button is not active when trying to install the certificate, it may have been installed previously using the automatic facility (Into the 'Intermediate Certification Authorities' zone). To remove the certificate: Open the browser and go to Tools -> Internet Options -> Content -> Certificates -> Intermediate Certificate Authorities Highlight the appropriate certificate for the instance you are trying to access, press the 'Remove' button then close down the browser Open a new browser session and follow the steps above to install the certificate into the 'Trusted Certificates' folder Internet Explorer: Running IE10 and IE 11 in 64-bit Mode Internet Explorer runs in a multi-process architecture whereby there is a Frame (Manager) process and one or more Tab (Content) processes. With IE10 and later there is no longer a separate 32-bit and 64-bit install of the browser when running a 64-bit version of Windows. In this instance the Frame (Manager) process always runs as 64-bit while the Tab (Content) process can run as either 32-bit or 64-bit. Internet Explorer Settings To run Oracle E-Business Suite through a 64-bit browser using a 64-bit JRE release you will need to set the following values in Internet Explorer: Windows 7 (64-bit) Select (Check) the following values: Tools -> Internet Options -> Security -> (e.g. Trusted Sites) -> Enable Protected Mode Tools -> Internet Options -> Advanced -> Enable Enhanced Protection Mode Windows 10 (64-bit) and Windows 8.1 (64-bit) Select (Check) the following values: Tools -> Internet Options -> Security -> (e.g. Trusted Sites) -> Enable Protected Mode Tools -> Internet Options -> Advanced -> Enable 64-bit processes for Enhanced Protection Mode Do not select (Uncheck) the following value: Tools -> Internet Options -> Advanced -> Enable Enhanced Protection Mode If you have " Enable Enhanced Protection Mode" selected (checked) when launching JRE you will see the following warning in the browser window. IE64_warn Click the Don't Run button and uncheck the value in the browser as outlined above. (Clicking the Run Control button will disable Enhanced Protected Mode which will not allow the 64-bit JRE release to run. It will instead try to launch using a 32-bit version if available.) General Checks and Settings User Access Control Setting (UAC) Ensure the 'User Account Control Setting' (UAC) is not set to "Never Notify". This can be found under: Control Panel -> Action Center -> Change User Account Control Settings The default value for this setting is "Notify me only when programs try to make changes to my computer". Therefore, unless this was changed by the user it is unlikely it would need altering. 32-bit Add-ons If the browser has 32-bit add-ons or toolbars installed then the tab process will continue to open in 32-bit mode and prevent you running a 64-bit application. These can be checked through the IE Menu at the following locations: Tools -> Manage add-ons -> Toolbars and Extensions -> Show: Currently loaded add-ons Tools -> Manage add-ons -> Toolbars and Extensions -> Show: Downloaded Controls Any add-ons listed with a value of "32-bit" in the Architecture column must be disabled or uninstalled. Add-ons with a value of "32-bit and 64-bit" are okay to use in a 64-bit browser tab and can remain enabled. After removing or disabling any old add-ons, clear the browser cache and start a new browser session. Check the Browser Set Up To verify your browser is using 64-bit tabs, run through the steps in this section. 1. Close any open IE browser sessions 2. Open a new IE session 3. Launch your EBS environments logon page 4. Check the bitness of your IE tabs process as appropriate to your Windows version as explained below: Windows 7 Users Open Windows Task Manager -> Processes (tab) If your tab is running as 64-bit you should see two "iexplore.exe" processes. If you see one process named "iexplore.exe" and another named "iexplore.exe *32" your tabs are still running on 32-bit. If this is the case you should recheck the set up steps above. Windows 8.1 Users Open Windows Task Manager -> Details (tab) Right click on one of the columns and click Select columns Check Platform The Platform column should now appear in the table showing whether the process is 32-bit or 64-bit Your iexplore.exe processes should show as 64-bit if the tab is working correctly. If one of the iexplore.exe processes is running as 32-bit recheck the set up steps above. Reset the Browser If you are still getting a 32-bit tab, as a last resort you can try resetting your browser. While this will disable toolbars and add-ons it will also set it back to its original state. You will therefore need to reset the browser parameters above as well as any other parameters you may have altered for your business requirements (WebADI required settings for example). To reset the browser select the following from the IE Menu: Tools -> Internet options -> Advanced (tab) -> Reset (button) -> Reset (button) Internet Explorer: Known Issues Internet Explorer 8 and Higher Specific Issues Windows 8 Specific Issues Windows Vista and Windows 7 Specific Issues General Internet Explorer Issues Internet Explorer 6 Specific Issues Internet Explorer 8 and Higher Specific Issues Display Issues in FWK (IE 9 and IE 10) Note: The following Display Issues in FWK (IE 9 and IE 10) are fixed by applying the patches listed in the General IE 11 Patch Requirements table. Once these patches have been applied you should no longer use the Internet Explorer 'Compatibility View' feature when running any version of Internet Explorer. To prevent display issues within some FWK pages it is advisable to run your Oracle E-Business Suite environment through IE 'Compatibility View'. Some of these issues are highlighted below. IE10 users may see the responsibilities under the main menu displayed as 'undefined': Responsibilities Undefined IE9 and IE10 users running in 'Browser Mode' may see button and text misalignment as well as font changes within certain FWK pop ups and other pages, for example when opening a 'Search and Select' window: Buttons in Standards Mode Patch Fix Oracle E-Business 12.1.3 users can fix these issues by applying Patch 17618077.R12.FWK.B. Workaround To workaround these issues, set the webpages to run through Internet Explorer 'Compatibility View'. To set this as the default setting for your domain: From the browser menu select Tools -> Compatibility View Settings In the Add this Website field enter your domain information as appropriate (e.g. oracle.com) Click the Add button Close the Compatibility View Settings window Running through 'Compatibility View' should correct any button, font or other display issues: Buttons in Compatibility Mode 64-bit Internet Explorer Issues (IE8 and IE9) The issues outlined in this section are specific to users running an IE 64-bit browser. Default Browser By design Microsoft do not allow the 64-bit version of Internet Explorer to be set as the default browser on the desktop: Tools -> Internet Options -> Programs (tab) -> Default Web Browser "Internet Explorer (64-bit) cannot be the default browser." Opening an HTML window from a third party application will therefore use the default 32-bit browser which may require the user to login to the appropriate Oracle E-Business Suite responsibility through this new session. Report Manager Default Browser Behavior Financial Statement Generator reports that drill down into General Ledger from Adobe Acrobat Reader or Microsoft Excel will open in the user's default browser. If the user has an active Oracle E-Business Suite session open in the default browser, then when the user selects a drill down link, the corresponding Oracle General Ledger page appears directly. If the user does not have an active Oracle E-Business Suite session, or if the Oracle E-Business Suite session is in another browser (e.g. 64-bit), then the Oracle E-Business Suite login page appears first in the default browser, and the user must log in and select a responsibility to access the Oracle General Ledger drill down page. For ease of use, it is recommended that users requiring this function run Oracle E-Business Suite in their default browser. Oracle Product Workbench (IE8, 9 and 10) Oracle Product Workbench will fail to launch when running through an Internet Explorer 64-bit browser as the browser is unable to load 32-bit ActiveX controls. Please use a 32-bit version of Internet Explorer to run this product. Multiple EBS Sessions (IE8 and Higher) Previous releases of Internet Explorer (IE7 and earlier) allowed users to logon to the same Oracle E-Business Suite environment concurrently from the same desktop by launching each application session through a new browser session. By default the ‘Session Merging’ feature introduced in IE8 prevents this functionality from working by default. This is because the same session id is used when accessing the same Oracle E-Business Suite environment. By default this will occur if you select New Window, New Tab or Duplicate Tab from the the browsers File menu, or if you open another browser window through the desktop browser icon. This can result in unusual behavior with invalid sessions causing errors such as “Your login session has become invalid" , "Unable to authenticate session" and failures to launch forms causing errors such as “FRM-92050: Failed to connect to the server: /forms/formservlet: -1" To retain the use of multiple sessions through a separate session id to the same Oracle E-Business Suite environment running IE8 and higher please use one of the workarounds below to ensure each browser session remains independent: Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar. Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging Create a new IE icon adding the -noframemerging parameter e.g. Start -> Program Files Right click on the Internet Explorer icon and select Properties Add -noframemerging to the end of the link in the Target field e.g. "C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging or "C:\Program Files (x86)\Internet Explorer\iexplore.exe" -noframemerging Click the OK button to close the window This icon may then be copied to the desktop if desired Unable to Authenticate Session If you receive an 'Unable to authenticate session' error in your browser when running multiple sessions, please set the -noframemerging option as outlined in the Multiple EBS Sessions section above. If this does not resolve the problem or you are not running multiple sessions, please try clearing your browser cache by deleting the 'Temporary Internet Files' through: Tools -> Internet Options -> General (tab) -> Browsing History -> Delete (button) Loosely-Coupled IE (LCIE) Loosely-Coupled IE (LCIE) is standard IE browser behavior in IE8 and higher. This splits the browsers frame and its tabs into separate processes on the desktop to improve performance and browser recovery if a tab crashes. Oracle E-Business Suite users may be affected in the following ways. Multiple Java Console Windows Open With the 'Show Console' option set in the Java Control Panel, launching a forms based application through IE8 or higher may cause two separate 'Java Console' windows to open. Accessing further applets from the same Oracle E-Business Suite session may also cause further 'Java Console' windows to appear. This will not always be seen because not every tab will necessarily be started in its own process because LCIE will attempt to balance reliability with performance. Therefore the issue of multiple java console windows is most likely to be seen if running from a high specification multi-core processor desktop. If required you can prevent the java console from appearing by running the following from your desktop client: Control Panel -> Java (icon) -> Advanced (tab) -> Java Console -> select the 'Hide Console' (radio button) Journal Approval from Email Notification Due to LCIE, trying to approve a journal from an email notification may cause the following error when running IE8 and later: FRM-92050; failed to connect to the sever;/forums/forums;-1 Steps to reproduce the issue: After receiving an email notification to approve a journal click on the Please click here to Respond link. Click on Enter Journals link to drill back into Oracle and view journal details. Error message appears. To workaround this issue please turn LCIE off through the registry as follows: Open the registry editor. Navigate to: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main. Locate the TabProcGrowth key. (If the key does not exist, create a new DWORD (32-bit) Value named TabProcGrowth.) Set the value of the key TabProcGrowth to 0. (This will instruct IE to open all of the tabs within the same iexplore.exe process.) Cross-Site Scripting Errors (XSS) 'Internet Explorer has modified this page to prevent a possible cross-site scripting attack' XSS Error when Launching Forms Oracle E-Business Suite 12.0 and 12.1 users may an XSS error in the browser window when launching any forms based application. This may occur because the required Forms 10.1.2.3 servlet components may not have been deployed properly when Forms 10.1.2.3 was first installed in your Oracle E-Business Suite Release 12 environment (Bug 8608695). If your end-users running IE8 or higher encounter this error when attempting to launch a Forms-based E-Business Suite product, redeploy the Forms 10.1.2.3 formsapp.ear file by following Document 397174.1 titled, 'Deploying a New Forms .ear File in Oracle Applications Release 12'. XSS Error After Launching Forms Multiple Times Some users may suddenly encounter an XSS error after successfully opening and closing multiple forms within a session, preventing any further forms launches. To fix this issue, make the following configuration changes to the template file, apps_conf_1013.tmp: 1. Back up your template file: $FND_TOP/admin/template/apps_conf_1013.tmp 2. Add the following lines to the template file apps_conf_1013.tmp: Header set X-XSS-Protection 0 . Header set X-XSS-Protection 0 3. Run Autoconfig to update the configuration file: $INST_TOP/ora/10.1.3/Apache/Apache/conf/apps.conf Note: For further information on customizing AutoConfig template files see Section 4: Customizing AutoConfig-Managed Configurations within Document 387859.1 titled, 'Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12'. Workflow Notification Certificate Signing in IE9 and IE10 When using IE9 or IE10 the digital signing of workflow notifications will error with the message: Verification of signature has failed For further information on patch availability see Document 1908197.1, titled "Verification of Signature has Failed Error on Internet Explorer Browser Version 9 and Above ". iRecruitment Attachments Some users may find the iRecruitment Applicant Comparison Report will not open when running Internet Explorer 8.x on Windows XP, the application stops and you cannot choose whether to save or open the pdf file. To fix this issue see Document 1579266.1. Windows 8 Specific Issues BiDi (Arabic and Hebrew) languages Due to issues with right side truncation, Windows 8 is not certified for BiDi (Arabic and Hebrew) languages. A patch fix for this issue is in progress. Projects to MS Projects Interface Trying to post information between Oracle Projects and Microsoft Projects will currently error when running on Windows 8. A patch fix for this issue is in progress. For further information see Document 1077728.1 titled, 'Using Microsoft Office 2007 and 2010 with Oracle E-Business Suite 11i and R12' Windows Vista and Windows 7 Specific Issues The following issues are applicable for users running on Windows Vista through IE7 or higher, and Windows 7 through IE8 and higher. Balanced Scorecard Users The VB client is not supported on Windows Vista or Windows 7. Discoverer Users Discoverer (10g) 10.1.2.3 is certified with Windows Vista. For further information, see Document 456426.1. Discoverer 10.1.2.2 and earlier are not certified with Windows Vista or Windows 7. Financial Analyzer and Sales Analyzer Users Financial Analyzer and Sales Analyzer client versions (6.4) are not supported on Windows Vista or Windows 7. Please use the OFA and OSA web versions, see Document 470992.1. XML Reports (RTF file extensions) Windows Vista and Windows 7 users cannot open *.rtf format files through the browser. When clicking the 'OK' button on the 'Opening *.rtf' modal window the file will not open and the modal window will come up again. To correct the problem, associate a different program such as Wordpad, OpenOffice.org etc. with the .rtf extension on the desktop. Control Panel -> Default Programs -> Associate a file type or protocol with a program Select .rtf under the Name column from the list Click the Change Program button. Select an appropriate program i.e. Wordpad Click the OK button General Internet Explorer Issues Discoverer Viewer Users After clicking the drill icon on a worksheet the drill items are not listed when running Discoverer Viewer through IE7 and higher. To fix this issue: Discoverer Viewer 10.1.2.0.2 and 10.1.2.1 and 10.1.2.2 users should apply Patch 5673463. Please contact support to request this patch. Discoverer Viewer 10.1.2.2 Cumulative Patch (CP7) and lower users should apply Patch 5673463. Please contact support to request this patch. This issue is fixed in Discoverer 10.1.2.2 Cumulative Patch (CP8) and Discoverer 10.1.2.3 and higher. Framework (FWK) Rich User Interface Features The following Rich User Interface FWK features were introduced in Oracle E-Business Suite 12.1.2: Inline Attachments Look Ahead LOV Pop-ups Navigator/Favorites Pull-down Menus RESTful Service Interface Internet Explorer users wishing to utilize these features must use Internet Explorer 7 or higher. These features are not supported for users running Internet Explorer 6, please see the matrix below. If you require further information please see Document 395441.1 titled, 'Oracle Application Framework Support Guidelines for Customers'. Certification Matrix for FWK Rich User Interface Features Browser Version EBS 12.1.2 EBS 12.1.3 EBS 12.2.x IE 11 Not Certified Certified Certified IE 10 Certified Certified Certified IE 9 Certified Certified Certified IE 8 Certified Certified Certified IE 7 Certified Certified Not Certified IE 6 Not Certified Not Certified Not Certified Tabbed Browsing in IE 7 and Higher Forms Windows IE7 and higher provides a tabbed browsing facility, which can be enabled from the browser menu through Tools -> Internet Options -> General Tabs -> Settings. Forms in Oracle E-Business Suite are supported and launched through a separate frame. Therefore, even with tabs enabled, the forms navigator and the forms windows will continue to open in a new window and not in a new tab. This is intended functionality and is not a bug. Web Based LOV's When using IE7 or IE8 with the 'Always Open Pop-Ups in a New Tab' browser option selected, focus is lost after opening the LOV in a new tab causing the application to freeze. To unfreeze the application and regain focus within the pop-up window press 'Ctrl & Tab'. To workaround this issue please select a different value for 'When a pop-up is encountered; in the browser: Navigate to: Tools -> Internet Options -> Tabs -> Settings -> Always Open Pop-Ups in a New Tab Select either: Let Internet Explorer decide how pop-ups should open or: Always open pop-ups in a new window Alternatively, to use the tabbed setting upgrade to IE9 or later where this problem does not exist. This issue is being evaluated through enhancement request Bug 9773527. Exporting Data and Opening Attachments File Export / Forms Attachments Functionalities JRE 1.6.0_27 (6u27) adheres more strictly to Internet Explorer browser settings. Users may find that the File -> Export and Forms Attachments functionalities (for example opening Word, rtf and Excel attachments) will not work after upgrading to this Plug-in version when running IE6, IE7 or IE8. Trying to run these functionalities may cause a window to open briefly before closing again, the 'File Download' window will not open. To fix this issue please set the following browser setting within IE under the appropriate security zone (using 'Trusted Sites' as an example): Navigate to: Tools -> Internet Options -> Security -> Trusted Sites -> Custom level. Set: Downloads -> Automatic prompting for file downloads to Enable This setting no longer exists in IE9 and therefore these functionalities are not affected when using this browser. File Association The file type that you wish to export from E-Business Suite must be associated with the browser. If the file type is not associated, the Window will not open or will briefly open and then close immediately. This may occur for example, when using 'File -> Export' to an excel spreadsheet or when opening an attachment from E-Business Suite. To fix this issue, using the 'Trusted Sites' zone as an example, (which is recommended for running Oracle E-Business Suite through): Select 'Tools' -> 'Internet Options' -> 'Security' (tab) -> 'Trusted Sites' -> 'Custom Level' (button) -> 'Downloads' from the browser menu. Set 'Automatic prompting for file downloads' to 'Enable'. Save the setting and close the browser window. Start a new browser session and login to Oracle E-Business Suite. This time, when trying to open the attachment or export data you should see a pop up windows titled 'File Download'. Uncheck the checkbox labeled, 'Always ask before opening this type of file' and click the 'open' button. The file should now display correctly. After this has been done, the file extension type is registered and you may set the 'Automatic prompting for file downloads' back to 'disable', accessing such files in future will now work correctly with that setting. Browser Helpers and Toolbars The use of certain browser helpers and Toolbars may cause the browser to crash when trying to login to Oracle E-Business Suite due to their incompatibility with older plug-in versions. To remove a toolbar: On the Start menu, click Control Panel Double-click Add or Remove Programs Select the appropriate toolbar Click the Remove button To disable an add-on: From the browser menu, Tools -> Manage Add-ons -> Enable or Disable Add-ons Select the appropriate add-on Under 'Settings' click the 'disable radio' button Restart the browser SSL Users Internet Explorer may display one of the following messages through a modal window when running Oracle E-Business Suite in an SSL enabled environment: Do you want to view only the webpage content that was delivered securely? or This page contains both secure and nonsecure items. Do you wish to display the nonsecure items? To stop this message appearing, using the 'Trusted Sites' zone as an example: Select 'Tools' -> 'Internet Options' -> 'Security' (tab) -> 'Trusted Sites' -> 'Custom Level' (button) -> 'Miscellaneous' section from the browser menu. Set 'Display mixed content' to 'Enable'. Save the setting and close the browser window. Internet Explorer 6 Specific Issues Microsoft Internet Explorer ActiveX Update 912945 For details regarding this Microsoft update and its affect on Oracle E-Business Suite, see Document 364366.1. This functionality is included by default in IE 7. Section 3: Firefox (FF) for Windows Users Certification Matrix for Firefox (32-bit) browsers Firefox: Prerequisite Patch Requirements Firefox: Recommended Browser Settings Firefox: Blocked Plugins in Mozilla Firefox Firefox: Importing an SSL Certificate Firefox: Known Issues Certification Matrix for Firefox (32-bit) browsers Firefox ESR 38.x with Oracle E-Business Suite 12.1 Firefox ESR 38.x may display the error Secure Connection Failed when trying to open the Oracle E-Business Suite 12.1 login page. 12.1 users are recommended to remain on Firefox ESR 31.x until a patch fix for this issue is provided. Note: Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates. The table below outlines the currently certified Browser, Desktop Client Operating System and JRE streams with minimum versions, where applicable. Please also review this document for further specific certification information and requirements: Browser Version Windows 10 (32-bit & 64-bit 1) Windows 8.1 (32-bit & 64-bit 1) Windows 8 (32-bit & 64-bit 1) Windows 7 (32-bit & 64-bit 1) Windows Vista (32-bit) Windows XP (32-bit) 2 Firefox ESR 38.x 3 JRE 1.8.0_51 and higher JRE 1.7.0_85 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_37 and higher Not Certified JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher Not Certified Recent Releases No Longer Supported (Included for Historical Purposes) 4 Firefox ESR 31.x 3 Not Certified JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_37 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_37 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher JRE 1.8.0_25 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher Not Certified Firefox ESR 24.x 3 Not Certified Not Certified JRE 1.6.0_37 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher JRE 1.7.0_10 and higher JRE 1.6.0_10 and higher JRE 1.7.0_10 and higher 1 Windows 7 (64-bit) desktop client operating system is currently only certified with Oracle E-Business Suite when running 32-bit products e.g. Client based products, Browsers, JRE plug-in and Microsoft Office. 2 Windows XP was desupported by the vendor in April 2014, see 3rd Party Software Support Lifecycle. 3 Firefox ESR XX.x is an Extended Support Release (ESR) which will be supported by the vendor for approximately a year. For further information on the support lines and other information please see Mozilla Firefox ESR Overview 4 Recent Releaes No Longer Supported (Included for Historical Purposes) - These Firefox browsers are no longer supported by the vendor, see 3rd Party Support Lifecycle. It is recommended that any users running these versions upgrade to the latest Firefox ESR release.. 3rd Party Software Support Lifecycle Oracle's support of the various third party client operating system and browsers aligns with the respective vendor's support life cycle. Firefox It is recommended that any users running earlier versions of Firefox upgrade to the latest Firefox ESR release. Oracle will continue to offer support for earlier Firefox versions with Oracle E-Business Suite R12 on a 'Best Effort' basis only. Consequently, where issues are due to problems with the browser, we may, where necessary, require customers to upgrade or change their browser to resolve the issue. Compatibility with Higher JRE releases Oracle has certified the Oracle E-Business Suite with the minimum JRE releases noted above on the JRE 6 (1.6.0.x) stream. Oracle E-Business Suite end-users may use or upgrade to later production releases of the JRE 6 plug-in at their discretion. For further information on upgrading JRE and it's requirements, please reference Document 393931.1 entitled 'Upgrading JRE (Native Plug-in) with Oracle E-Business Suite 12 for Windows Clients'. Oracle will continue to test and certify the Oracle E-Business Suite with selected future versions of JRE releases in advance of their general availability to the public. Oracle will update this documentation with known compatibility issues or workarounds as needed. All current JRE production versions equal to or higher than the minimum versions stated above are compatible with Oracle E-Business Suite 12. Firefox: Prerequisite Patch Requirements Firefox Windows 8 Users Firefox ESR 17.x and ESR 24.x are certified as a client browsers on Windows 8 (32-bit and 64-bit) with the following prerequisite requirements: Oracle E-Business Suite Release 12.2.x Oracle E-Business Suite Release 12.1.3 Oracle E-Business Suite Release 12.0.6 with: Applications Framework Patch 7602616 Patch 7567840 which removes the use of the jpi-version parameter and switches Firefox to a non-static versioning model. WebADI and Report Manager Users WebADI and Report Manager have prerequisite patch requirements when running on Windows 8, for further information see Document 1077728.1 titled, 'Using Microsoft Office 2007 and 2010 with Oracle E-Business Suite 11i and R12'. Known Issues For known issues see Windows 8 Specific Issues Windows XP, Vista and 7 Users Firefox versions ESR 10.x and higher are certified as client browsers on Windows Vista SP2 and Windows 7 SP1 (32-bit & 64-bit) with the following requirements: Oracle E-Business Suite Release 12.1.1 or higher. Oracle E-Business Suite Release 12.0.x with: Oracle Applications Technology R12.ATG_PF.A.delta.6 (Patch 7237006) or higher Applications Framework Patch 7602616 It is also strongly recommended to apply Patch 7567840 which removes the use of the jpi-version parameter and switches Firefox to a non-static versioning model. Use of the jpi-version parameter is no longer supported with next-generation java. For further information see Multiple Desktop JRE Plug-in Versions with Firefox 3.0.x and higher Firefox: Recommended Browser Settings Shared Desktop Security If multiple users share the same desktop, they may be able to view a previous users browser content by pressing the 'Back' button on the browser. To avoid this issue please set the 'Force Page Refresh' profile option to 'Yes' at Site level in your Oracle E-Business Suite 12 instance. Firefox: Blocked Plugins in Mozilla Firefox Mozilla has changed the way that third party plugins are handled within Firefox to a 'Click to Play' model. (For further information please see the Mozilla article Putting Users in Control of Plugins.) This function may affect Oracle E-Business Suite users running Oracle Forms by prompting the user to activate or upgrade the JRE Plug-in before a form can be launched. Users running the latest version of the JRE Plug-in will generally not be affected by this change. It is however recommended that all users trust the JRE Plug-in within Firefox for their Oracle E-Business Suite environments to prevent this message appearing when running old or blocked releases. For information on how to do this please see 'How to always activate a plugin for a trusted website' outlined in the Mozilla article Why do I have to click to activate plugins?. Note: It is recommended that Oracle E-Business Suite users move to the latest available version of the JRE Plug-in. For information on upgrading please see: Document 393931.1: Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12. Firefox: Importing an SSL Certificate Untrusted Connection To trust the certificate authority and to stop this error page appearing on future logins, add an exception: 1. Click the 'Add Exception...' button and the 'Add Security Exception' window should open. Security Exception 2. Check 'Permanently store this exception'. If this checkbox is grayed out you will first need to turn on History (this can be turned off again after trusting the certificate) as follows: Tools -> Options -> Privacy -> Set Firefox will: Remember history Click OK button 3. Click the Confirm Security Exception button. SSL Warning Message "The connection to this website is untrusted" If you are using an SSL certificate that is not from one of the standard recognized Certificate Authorities (CA), for example your own in-house CA you may see the following pop-up when launching Java content. FF SSL Warning To prevent this message appearing copy your SSL root certificate to the desktop then import it into the Java 'Secure Site CA' certificate store. Java Control Panel -> Security (tab) -> Manage Certificates (button) -> Certificate Type: Secure Site CA -> Import (button) Firefox: Known Issues General Firefox Issues Windows Vista and Windows 7 with Firefox General Firefox Issues Firefox ESR 38.0.1 Performance Issue Loading Java content using Firefox ESR 38.0.1 can show performance degradation if accessing any URL outside of your own network. If your jars are signed by a 3rd party provider, the certificate revocation function will attempt to connect to their network to run the check, which is outside your internal network. This is due to a bug in the Firefox 38 base release whereby the default 'Use Browser Settings' value is not being picked up and instead content is running using a direct connection. . Fix This issue is fixed in Firefox ESR 38.1.0. If you are unable to upgrade at this time you can avoid the issue by using the following workaround. Workaround To workaround this issue, add either your proxy server information under 'Use Proxy Server' or your proxy configuration script details under 'Use automatic proxy configuration script' in the Java Control Panel and select that value instead of the default 'Use browser settings' option: Java Control Panel -> General (tab) -> Network Settings (button) Secure Connection Failed Oracle E-Business Suite 12.1 users running Firefox ESR 38.x may see the following error when attempting to load their environments login page: Secure Connection Failed The connection to server.example.com:4443 was interrupted while the page was loading. The default value of the Firefox parameter, security.tls.version.fallback-limit has been changed from 1 to 3 in this release. This change in combination with the latest patching levels will cause this error to display when using TLS enabled environments. A patch fix for this issue is currently in progress.. Workaround To workaround the issue in the meantime you can set the value back to 1 through the browser configuration. Open Firefox and enter about:config In the Search field enter tls Double click security.tls.version.fallback-limit and set the value to 1 Internationalization For information on internationalization issues with Firefox please see the 'Browsers Notes' section of Document 393320.1 titled, 'Internationalization Update Notes for Release 12'. Browser Window Opens Behind the Forms Window Opening an html page from the forms navigator may cause the html window to open behind the navigator window when using Firefox. This issue is fixed in JRE 1.6.0_30 (6u30) and higher with the following browser options set: Tools -> Options -> Content -> Enable JavaScript (checked) Tools -> Options -> Content -> Enable JavaScript -> Advanced… (button) -> Raise or lower windows (checked) Tools -> Options -> Tabs -> Open new windows in a new tab instead (unchecked) Framework (FWK) Rich User Interface Features The following Rich User Interface FWK features were introduced in Oracle E-Business Suite 12.1.2: Inline Attachments Look Ahead LOV Pop-ups Navigator/Favorites Pull-down Menus RESTful Service Interface For browser support information for these features, please see the matrix below. If you require further information please see Document 395441.1 titled, 'Oracle Application Framework Support Guidelines for Customers'. Certification Matrix for FWK Rich User Interface Features Browser Version EBS 12.1.2 EBS 12.1.3 EBS 12.2.x FF ESR 38.x Certified Certified Certified FF ESR 31.x Certified Certified Certified FF ESR 24.x Certified Certified Certified JRE Plug-in Download Using Firefox (oaj2se.exe) Oracle E-Business Suite 12.0.x Users If using a non-static versioning model (Patch 7567840 has not been applied) and the correct 'JRE Plug-in' version is not already installed on the client it will not automatically download from the web server when using a Firefox browser. This issue is fixed in Oracle E-Business Suite 12.0.6 Release Update Pack (RUP6), Patch 6728000. To workaround this problem, the user can either download and install the JRE Plug-in, before launching the Oracle E-Business Suite, or can still download it from the server as follows. Clicking on a forms link through Firefox will activate the 'Plug-in Finder Service'. The user will then see the message 'Additional plug-ins are required to display all the media on this page' in the task bar. Click on the 'Install Missing Plug-ins' button. (This will open a new window, search for the plug-in but will not find it) Click on the 'Manual Install' button, which should open another window saying: Forbidden You don't have permissions to access /OA_JAVA/ on this server. In the URL line on this window change http://:/OA_JAVA to http://:/OA_HTML/oaj2se.exe. When asked if you wish save the oaj2se.exe file. Click the 'Save File' button and install the file onto your desktop Once it has installed successfully, close down the firefox window and start a new session to access the Oracle E-Business Suite. Multiple Sessions You may only access a single Oracle E-Business Suite instance from a single desktop session when using the Firefox browser. Currently 'Internet Explorer' is the only browser that allows you to access multiple instances or multiple Application Responsibilities concurrently from the same desktop session, through the use of multiple browser sessions. Multiple Desktop JRE Plug-in Versions Multiple Desktop JRE Plug-in Versions with Firefox 3.x and higher Firefox 3.0.x and higher supports 'Next-Generation JRE Plug-in' technology which is enabled by default when running JRE 1.6.0_10 and higher. Oracle E-Business Suite 12.0.x Users It is strongly recommended Oracle E-Business Suite 12.0.x users running Firefox 3.0 users apply Patch 7567840. Without this patch the latest JRE plug-in version on the desktop would have to match the JRE plug-in version being called from the web server to successfully load a form. See Multiple Desktop JRE Plug-in Versions with Firefox (Static Versioning) Whilst there is limited backward compatibility, using the jpi-version attribute of the MIME type to select a particular JRE version is no longer supported when using the next-generation JRE plug-in (JRE 1.6.0_10 and higher). This patch changes the behavior within Oracle E-Business Suite Release 12 by removing the jpi-version parameter to overload the usage of the application/x-java-applet MIME type and implement the java_version parameter for JRE version selection. Further information is available from the JRE Version Selection page. This patch changes the behavior of Firefox 3.0 to a 'non-static versioning' model. Earlier 'classic' java versions can also be run on this new architecture and they will also then adhere to a non-static versioning model. Oracle E-Business 12.1.1 Users Oracle E-Business 12.1.1 users do not require Patch 7567840. This architectural change is included by default making Firefox 3.0 adhere to the non-static versioning model. For further information on static and non-static versioning please see Appendix A: Static vs Non-Static Versioning and Set Up Options in Document 393931.1, titled, 'Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12'. (Return to Prerequisite Patch Requirements section if required.) Multiple Desktop JRE Plug-in Versions with Firefox (Static Versioning) By default, Firefox only uses the latest version of the plug-in that it finds on the desktop client. Unless Oracle E-Business Suite is set to use the latest available version of the plug-in, users may not be able to connect using earlier versions of the plug-in. To enable Firefox to use multiple versions of the Plug-in from the desktop client, (thus allowing the use of JRE Plug-ins on the desktop that are not the latest version installed on that desktop) the following workaround can be used: Copy '\bin\npjpi.dll' to '\plugins'. (Using JRE 1.6.0_03 as an example in a default installation, this would be) - Copy C:\Program Files\Java\jre1.6.0_03\bin\npjpi160_03.dll to C:\Program Files\Mozilla Firefox\plugins To check which versions are available within Firefox type, 'about:plugins' in the address bar. Note: This workaround is not valid when running Firefox 3.0 with JRE 1.6.0_10 or higher installed on the desktop client. Tab functionality in the Firefox Browser Firefox uses tabbed browsing by default. Forms in Oracle E-Business Suite are supported and launched through a separate frame. Therefore, even with tabs enabled, the forms navigator and the forms windows will continue to open in a new window and not in a new tab. This is intended functionality and is not a bug. Personal Homepage Setting The ICX 'Personal Homepage' setting is not supported with the Firefox browser. Rich Text Editing The Cut, Copy and Paste buttons within the Rich text Editor on Oracle Applications Framework do not work by default when using a Firefox browser. This is due to a security feature within Firefox. We recommend that the keyboard shortcut keys, which do still work by default are used for this functionality. If you still wish to use the buttons, this can be enabled by editing the users Firefox preference file. Further information is available from the Cut, Copy and Paste Buttons and Security preferences pages BIDI Language Users BIDI Languages are not supported with Self Service Applications using the Firefox Browser. Oracle Report Manager Oracle Report Manager interaction with Excel will not work when using the Firefox browser. This functionality requires the interaction of ActiveX through VbScript, which is not supported in Firefox. Oracle Report Manager users should run Internet Explorer for full functionality. Full support through Firefox is being investigated. Windows Vista with Firefox Windows Vista and Windows 7 with Firefox Balanced Scorecard Users The VB client is not supported on Windows Vista or Windows 7. Discoverer Users Discoverer 10.1.2.3 is certified on Windows Vista. For further information please see Document 456426.1. Financial Analyzer and Sales Analyzer Users Financial Analyzer and Sales Analyzer client versions (6.4) are not supported on Windows Vista or Windows 7. Please use the OFA and OSA web versions, see Document 470992.1. XML Reports (RTF file extensions) Windows Vista and Windows 7 users cannot open *.rtf format files through the browser. When clicking the 'OK' button on the 'Opening *.rtf' modal window the file will not open and the modal window will come up again. To correct the problem, associate a different program such as Wordpad, OpenOffice.org etc. with the .rtf extension on the desktop. Control Panel -> Default Programs -> Associate a file type or protocol with a program Select .rtf under the Name column from the list Click the 'Change Program' button. Select an appropriate program i.e. Wordpad Click the 'OK' button Section 4: Chrome for Windows Users Note: Oracle E-Business Suite R12 has two interfaces: a web-based (OA Framework/HTML) model for modules like iProcurement and iStore, and Oracle Forms/Java based model for our professional services modules like Oracle Financials. Google is expected to phase out Chrome's support for Java "before the end of 2014", see API (NPAPI) support from Chrome, preventing plug-ins like Java from running. See API (NPAPI) support. Chrome is only certified for E-Business Suite customers running web-based (HTML / OA Framework) screens, running Java based content with Chrome is not supported. Chrome Release Cycle and Certification Chrome releases are updated every six to eight weeks. Oracle is unable to test every new version of Chrome with the E-Business Suite. Oracle is expected to certify selected Chrome releases on an ongoing basis. Certification Matrix for Chrome Browsers Certification Matrix for Windows Operating Systems and Oracle E-Business Suite Releases: EBS Release Windows 10 (32-bit & 64-bit 1) Windows 8.1 (32-bit & 64-bit 1) Windows 7 (32-bit & 64-bit 1) EBS 12.2.4 3 Chrome v44 Chrome v44 Chrome v35 EBS 12.1.3 3 Chromev 44 Chrome v44 Chrome v35 Using Later Chrome Releases Customers may use later Chrome releases. Oracle will investigate any reported issues and attempt to reproduce the problem on our certified release and will provide patches for reproducible issues, subject to technical feasibility. If the issue cannot be reproduced, customers may be advised to: Wait and see whether the next release of Chrome fixes the issue. Use a certified version of Internet Explorer or Firefox ESR Issues specific to other Chrome releases may still be documented as known issues. Certification Matrix for Mobile Devices: Browser Version Mobile Operating System Certified Devices EBS Release 12.2.4 EBS Release 12.1.3 Chrome v35 Android v4.1 or Higher Samsung Galaxy Tab (4.1.2) Certified Certified Using Other Mobile Devices and Later Chrome Releases Oracle EBS Development uses Samsung and Nexus mobile devices in the certification testing cycles for Oracle E-Business Suite. These are considered to be our reference devices. Customers may use other Android-based devices and later Chrome releases. Oracle will attempt to reproduce reported issues on our reference devices. Oracle will provide patches for reproducible issues, subject to technical feasibility. If the issue cannot be reproduced using our reference devices, customers may be advised to: Wait and see whether the next release of Chrome fixes the issue. Consult with their device vendor for guidance. Use a desktop client. Device-specific issues that cannot be reproduced with our reference devices may be documented as known issues. Chrome: Prerequisite Patch Requirements Oracle E-Business Suite 12.2.4 Users There are no patch requirements for Oracle E-Business Suite 12.2.4 users Oracle E-Business Suite 12.1.3 Users Oracle E-Business Suite 12.1.3 users must apply Patch 18936791:R12.FWK.B.delta.4. Chrome: Known Issues Oracle Product Workbench Product Workbench Launch Failure Oracle Product Workbench will not launch when using Chrome and displays the message "No plug-in available to display this content". A fix for this issue is currently in progress. Oracle MES for Discrete Manufacturing 'Tif' Images are not Opened by Default 'Tif' image attachment types are not opened by default when using the Chrome browser but they are saved to downloads. A fix for this issue is in progress. To view the image in the meantime, open it from downloads. Oracle Order Management Navigator Tree Displays outside the Window Clicking on the navigator icon from within the 'Create Order' page causes the navigator tree to display outside the window. A fix for this issue is currently in progress Oracle Knowledge Management Changing Solution Name You are unable to change the Solution Name when using Chrome. When trying to save the change the error "you do not have access to this solution. Please contact your system administrator" is displayed preventing the change. A fix for this issue is currently in progress. Hiding/Removing 'Details' and 'Remove' Columns The 'Details' and 'Remove' columns cannot be hidden or removed in the 'Recommended Solutions' rich table when using Chrome. Despite clicking on the 'settings' icon, unchecking the tick marks against these columns and clicking anywhere on the screen, they are still displayed. A fix for this issue is currently in progress. Section 5: Safari for Mac Users Safari: Certification Matrix Safari: Recommended Browser Settings Safari: Known Issues Safari: Certification Matrix The tables below outline certified Browser, Operating System and JRE versions for Oracle E-Business Suite 12.x. Browser Version OS X v10.7.5 or higher OS X v10.8.2 or higher OS X v10.9.1 or higher OS X v10.10.2 or higher Safari 8.0.3 or higher not certified not certified not certified JRE 1.8.0_31 and higher JRE 1.7.0_72 and higher Safari 7.0.1 or higher not certified not certified JRE 1.8.0_25 and higher JRE 1.7.0_45 and higher not certified Safari 6.0.2 or higher JRE 1.7.0_21 and higher JRE 1.8.0_25 and higher JRE 1.7.0_21 and higher not certified not certified For further information and patch requirements for Apple Macintosh OS X versions 10.7 and higher see Document 1533334.1 titled 'Oracle E-Business Suite Release Notes Release 12 for Apple Macintosh OS X'. For Internationalization information please see Document 393320.1, titled 'Internationalization Update Notes for Release 12'. Browser Version OS X v10.4.7 or higher OS X v10.5.6 or higher OS X v10.6.3 or higher OS X v10.7.2 or higher Safari 5.1.2 or higher n/a JRE 1.5.0_13 and higher JRE 1.6.0_20 and higher JRE 1.6.0_29 and higher Safari 5.0.2 or higher n/a JRE 1.5.0_13 and higher JRE 1.6.0_20 and higher n/a Safari 4.0.5 or higher n/a JRE 1.5.0_13 and higher JRE 1.6.0_20 and higher n/a Safari 4.0.4 or higher n/a JRE 1.5.0_13 and higher n/a n/a Safari 3.2.1 or higher JRE 1.5.0_13 and higher JRE 1.5.0_13 and higher n/a n/a Safari 2.0.4 or higher JRE 1.5.0_06 and higher n/a n/a n/a For further information and patch requirements for Apple Macintosh OS X version 10.4, please see Document 402138.1, titled 'Oracle Applications Release Notes Release 12 for Apple Macintosh OS X version 10.4'. For further information and patch requirements for Apple Macintosh OS X version 10.5 and 10.6, please see Document 864552.1, titled 'Oracle E-Business Suite Release Notes Release 12 (12.0, 12.1) for Apple Macintosh OS X v10.5 and v10.6'. For Internationalization information please see Document 393320.1, titled 'Internationalization Update Notes for Release 12'. Safari: Recommended Browser Settings Performance From the Safari Menu, go to 'Preferences -> Security -> Web Content' and select: 'Enable Plug-ins', 'Enable Java' and 'Enable JavaScript'. Do not select 'Block Pop-Up Windows'. (Selecting this will cause the Oracle E-Business Suite not to open). From the Safari Menu go to 'Preferences -> Advanced' and select 'Press Tab to highlight each item on a webpage'. Safari: Known Issues Framework (FWK) Rich User Interface Features The following Rich User Interface FWK features were introduced in Oracle E-Business Suite 12.1.2: Inline Attachments Look Ahead LOV Pop-ups Navigator/Favorites Pull-down Menus RESTful Service Interface For browser support information for these features, please see the matrix below. If you require further information please see Document 395441.1 titled, 'Oracle Application Framework Support Guidelines for Customers'. Certification Matrix for FWK Rich User Interface Features Browser Version EBS 12.1.2 EBS 12.1.3 EBS 12.2.x Safari 8.0.x Not Certified Certified Certified Safari 7.0.x Certified Certified Certified Safari 6.0.x Certified Certified Certified Safari 5.0.x Certified Certified Not Certified Safari 4.0.x Certified Certified Not Certified Safari 3.2.x Certified Not Certified Not Certified Related Notes Document 285218.1: Recommended Browsers for Oracle E-Business Suite 11i Document 290807.1: Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i Document 393931.1: Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 Document 1077728.1: Using Microsoft Office 2007 and 2010 with Oracle E-Business Suite 11i and R12 Document 277535.1: Recommended Set Up for Client/Server Products with Oracle E-Business Suite 11i & R12 Change Log Date Description Aug 11, 2015 Firefox ESR 31 is no longer supported by the vendor as reflected in the Certification Matrix for Firefox (32-bit) browsers Aug 7, 2015 Added Windows 10 as certified with EBS 12.1 and 12.2.running IE11, ESR38 & Chrome 44 Jul 3, 2015 Added FF ESR 38.1.0 as the fix for the Firefox ESR 38.0.1 Performance Issue Jun 17, 2015 Added Firefox ESR 38 Performance Issue. May 27, 2015 Superceded Patch 19855051:R12.FWK.C with Patch 20518047:R12.FWK.C for EBS 12.2 users under Internet Explorer 11 (32-bit and 64-bit). May 19, 2015 Added Mozilla Firefox ESR 38.x as a certified browser for EBS 12.2. May 13, 2015 Superceded Patch 19659562:R12.CC_PF.B with Patch 20986782:R12.CC_PF.B for EBS 12.1.3 users under Internet Explorer 11 (32-bit and 64-bit). Feb 23, 2015 Added Safari 8.0.x with OS X 10.10.x to the Safari: Certification Matrix. Jan 16, 2015 Added IE 11 as a certified browser on Windows 7 & 8.1 for EBS 12.2 and 12.0.6. Nov 18, 2014 Added JRE 1.8.0_25 (8u25) to the certification Matrix for Safari on Mac. Nov 13, 2014 Added JRE 1.8.0_25 (8u25) to the certification Matrices for Windows browsers. Oct 23, 2014 Moved Firefox ESR 24.x to unsupported browsers section of Certification Matrix for Firefox (32-bit) browsers Sep 26, 2014 Added IE11 as a certified browser on Windows 7 & 8.1 for EBS 12.1.3. Added Chrome v35 as a certified browser for EBS 12.2.4 web-based content and Mobile Devices. Sep 12, 2014 Added IE Alert: Java(TM) was blocked because it is out of date and needs to be updated. Sep 9, 2014 Added Mozilla Firefox ESR 31.x as a certified browser. Jan 24 , 2007 Initial document created. Document 389422.1 by Oracle E-Business Suite Development

Difference between Concurrent Requests, Concurrent Programs, and Concurrent Processes in Oracle EBS

Concurrent Requests, Programs, and Processes When a user runs a report, a request to run the report is generated. The command to run the report is a concurrent request. The program that generates the report is a concurrent program. Concurrent programs are started by a concurrent manager http://www.dba-oracle.com/art_dbazine_conc_mgr.htm http://www.pythian.com/blog/the-internal-workflow-of-e-business-suite-concurrent-manager-process/ http://appsjagan.blogspot.qa/2010/09/concurrent-manager.html https://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T575591.htm Oracle E-Business Suite Setup Guide Release 12.2 Part Number E22953-13 Go to Table of Contents Contents Go to previous page Previous Go to next page Next Concurrent Processing Overview of Concurrent Processing This section explains how a request to run a concurrent program is handled by Oracle E-Business Suite, and what the life cycle of a concurrent request is. In Oracle E-Business Suite, concurrent processing simultaneously executes programs running in the background with online operations. As System Administrator, you can manage when programs are run and how many operating system processes Oracle E-Business Suite devotes to running programs in the background. Concurrent Requests, Programs, and Processes When a user runs a report, a request to run the report is generated. The command to run the report is a concurrent request. The program that generates the report is a concurrent program. Concurrent programs are started by a concurrent manager. Concurrent Managers start concurrent programs Every time your users request a concurrent program to be run, their request is inserted into a database table, and is uniquely identified by a request ID. Concurrent managers read requests from this table. Part of a manager's definition is how many operating system processes it can devote to running requests. This number is referred to as the manager's number of target processes. Running concurrent programs A concurrent program actually starts running based on: When it is scheduled to start Whether it is placed on hold Whether it is incompatible (cannot run) with other programs Its request priority Concurrent Request Priorities The priority of a concurrent request is determined by application username, and is set by the System Administrator using the Concurrent:Priority user profile option. The first available concurrent manager compares the request's priority to other requests it is eligible to process, and runs the request with the highest priority. When choosing between requests of equal priority, the concurrent manager runs the oldest request first. Parent requests and Child requests Often, several programs may be grouped together, as in a request set. Submitting the request set as a whole generates a request ID, and as each member of the set is submitted it receives its own request ID. The set's request ID identifies the Parent request, and each of the individual programs' request ID identifies a Child request. Concurrent Manager The concurrent managers serve important administrative functions. The concurrent managers ensure that the applications are not overwhelmed with requests, and the second areas of functions are the management of batch processing and report generation. In The Oracle e-Business suite has three important Concurrent Managers: Internal Concurrent Manager: The ICM (Internal Concurrent Manager) controls all of the other concurrent managers. Standard Manager: The Standard Manager accepts any and all requests. It has no predefined specialization rules and is active all the time. It is not recommended to add specialization rules to the standard manager as it can cause problems. Conflict Resolution Manager: The Conflict Resolution Manager resolves conflicts, such as request incompatibilities. How to check concurrent manager running or not? Log in to applications as System Administrator responsibility and navigate to the concurrent > manager > administration page and under the processes column if the target and actual column equal the same number (above 0) this means the managers are up and running. How to Start / Stop Concurrent manager ? If concurrent managers down, Use this syntax to start the concurrent managers from the command line: adcmctl.sh start apps/ You stop the concurrent managers from the command line: adcmctl.sh stop apps/ Location where you find adcmctl.sh scripts is $COMMN_TOP/admin/scripts/$CONTEXT_NAME/ Where the location of Concurrent Managers Log files? The concurrent manager log files can be located in one of the following places: 1. If the environment variable $APPLCSF is set, the default location is $APPLCSF/$APPLLOG 2. If the environment variable $APPLCSF is not set, the logs go to $FND_TOP/$APPLLOG NOTE: The default name of the concurrent manager log files is std.mgr. You can change these by setting the parameter logfile=. Manager Log Files: Standard manager log: w.mgr Transaction manager log: t.mgr Conflict Resolution manager log: c.mgr Where: is the concurrent process id of the manager How to Tune the Concurrent Manager? Tuning the Internal Concurrent Manager (ICM) The ICM performance is affected by the three important Oracle parameters PMON cycle, queue size, and sleep time. PMON cycle - This is the number of sleep cycles that the ICM waits between the times it checks for concurrent managers failures, which defaults to 20. You should change the PMON cycle to a number lower than 20 if your concurrent managers are having problems with abnormal terminations. Queue Size - The queue size is the number of PMON cycles that the ICM waits between checking for disabled or new concurrent managers. The default for queue size of 1 PMON cycle should be used. Sleep Time - The sleep time parameter indicates the seconds that the ICM should wait between checking for requests that are waiting to run. The default sleep time is 60, but you can lower this number if you see you have a lot of request waiting (Pending/Normal). However, reducing this number to a very low value many cause excessive cpu utilization. Purging Concurrent Requests When the space in FND_CONCURRENT_PROCESSES and FND_CONCURRENT_REQUESTS exceed 50K, you can start to experience serious performance problems within your Oracle Applications. When you experience these space problems, a specific request called "Purge Concurrent Requests And/Or Manager Data" should be scheduled to run on a regular basis. This request can be configured to purge the request data from the FND tables as well as the log files and output files on accumulate on disk. Adjusting the Concurrent Manager Cache Size Concurrent manager performance can also be enhanced by increasing the manager cache size to be at lease twice the number of target processes. The cache size specifies the number of requests that will be cached each time the concurrent manager reads from the FND_CONCURRENT_REQUESTS table. Increasing the cache size will boost the throughput of the managers by attempting to avoid sleep time. Analyzing Oracle Apps Dictionary Tables for High Performance It is also very important to run the request Gather Table Statistics on these tables: · FND_CONCURRENT_PROCESSES · FND_CONCURRENT_PROGRAMS · FND_CONCURRENT_REQUESTS · FND_CONCURRENT_QUEUES. Run the request "Analyze All Index Column Statistics" on the indexes of these tables. Since the APPLSYS user is the owner of these tables, so you can also just run the request Analyse Schema Statistics for APPLSYS. Monitoring Pending Requests in the Concurrent Managers You may find that requests are stacking up in the concurrent managers with a status of "pending". This can be caused by any of these conditions: 1. The concurrent managers were brought down will a request was running. 2. The database was shutdown before shutting down the concurrent managers. 3. There is a shortage of RAM memory or CPU resources. When you get a backlog of pending requests, you can first allocate more processes to the manager that is having the problem in order to allow most of the requests to process, and then make a list of the requests that will not complete so they can be resubmitted, and cancel them. To allocate more processes to a manager, log in as a user with the System Administrator responsibility. Navigate to Concurrent -> Manager -> Define. Increase the number in the Processes column. Also, you may not need all the concurrent managers that Oracle supplies with an Oracle Applications install, so you can save resources by identifying the unneeded managers and disabling them. However, you can still have problems. If the request remains in a phase of RUNNING and a status of TERMINATING after allocating more processes to the manager, then shutdown the concurrent managers, kill any processes from the operating system that won't terminate, and execute the following sqlplus statement as the APPLSYS user to reset the managers in the FND_CONCURRENT_REQUESTS table: update fnd_concurrent_requests set status_code='X', phase_code='C' where status_code='T'; How to find Concurrent Manager Node in Multi-Node environment ? Method 1: SQLPLUS> select node_name from apps.fnd_nodes where support_cp='Y'; Method 2: Execute "ps -ef | grep FNDLIBR" under application User on all nodes where FND (Foundation) LIBR (Library) is executable. Can I delete a concurrent manager? No. You can only disable/Enable the manager by checking the 'Enabled' checkbox How do I enable/disable the Conflict Resolution Manager? Use the system profile option 'Concurrent: Use ICM'. Setting this to 'No' (which is the default) allows the CRM to be started. Setting it to 'Yes' causes the CRM to be shutdown and the Internal Manager (ICM) will take over the conflict resolution duties. If the CRM will not start (it is started automatically by the ICM), check this profile option. Note that using the ICM to resolve conflicts is not recommended. The CRM's sole purpose is to resolve conflicts, while the ICM has other functions to perform as well. Only set this option to 'YES' if you have a good reason to do so. How do I clean out the Concurrent Manager tables? Run the script, cmclean.sql, article Note 134007.1 How do we process more concurrent requests concurrently? Login as a Sysdba and navigate ->Concurrent -> Manager -> Define and Query for the relevant concurrent manager), done in two steps: (i) Increase the Number of Target processes for the manager (ii) Change the cache size of the concurrent manager. How to Handle hang Concurrent Request or How to Kill Concurrent Request session ? Step 1 Mapping Concurrent request Id to Sid and serai# by using following query select v.request_id, s.sid,s.serial#,s.event,p.spid from apps.fnd_conc_requests_form_v v,v$process p,v$session s where v.request_id = ‘' and v.oracle_process_id = p.spid(+) and p.addr = s.paddr(+) Step 2 Execute following command and supply output from query 1 SQL> alter system kill session 'sid, serial#' How to retrieve Summary of concurrent Jobs/status/Count in Last 1 hour? Use following query: select fcpt.USER_CONCURRENT_PROGRAM_NAME, DECODE(fcr.phase_code, ‘C’, ‘Completed’, ‘I’, ‘Inactive’, ‘P’, ‘Pending’, ‘R’, ‘Running’, fcr.phase_code ) PHASE , DECODE(fcr.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Errored’, ‘F’, ‘Scheduled’, ‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No Manager’, ‘Q’, ‘Standby’, ‘R’, ‘Normal’, ‘S’, ‘Suspended’, ‘T’, ‘Terminating’, ‘U’, ‘Disabled’, ‘W’, ‘Paused’, ‘X’, ‘Terminated’, ‘Z’, ‘Waiting’, fcr.status_code ) STATUS, count(*) from apps.fnd_concurrent_programs_tl fcpt,apps.FND_CONCURRENT_REQUESTs fcr where fcpt.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID and fcpt.language = USERENV(’Lang’) and fcr.ACTUAL_START_DATE > sysdate - 1/24 group by fcpt.USER_CONCURRENT_PROGRAM_NAME,fcr.phase_code,fcr.status_code / Problems and Solutions: Problems: I hit the Restart button to start the Standard manager, but it still did not start? Solution: The ICM will start Standard Manager in the next process monitor session or the next time the ICM starts. Use Activate to start a manager immediately. When a manager is deactivated manually, the ICM will not restart it, you will need to set it to Restart, or activate it manually. Problem: When you try to submit a request like Active users or Active responsibilities, request gets submitted. When we view the requests, you find that it is inactive / nomanager. Within 12 to 15 seconds, you refresh-it gets completed. Solution: when this occurs where a request goes "inactive/no manager" and is then processed a short time later, the solution is to either increase the cache size for your Standard manger, or increase the actual number of Standard manager processes. HELPFUL DIAGNOSTIC SCRIPTS The following SQL scripts located under $FND_TOP/sql are useful when diagnosing concurrent manager problems: afimchk.sql Tells the status of the ICM and PMON method afcmstat.sql Lists active manager processes afrqrun.sql Lists all the running, waiting and terminating requests afrqwait.sql Lists requests that are constrained and waiting for the ICM to release them afrqscm.sql Prints log file name of managers that can run a given request. It can be used to check for possible errors when a request stays in pending status. It requires a request id value. afcmcreq.sql Prints the log file name of the manager that processed the request afrqstat.sql Summary of completed concurrent requests grouped by completion status and execution type. It requires number of days prior to today on which to report parameter. afimlock.sql Lists locks that the ICM is waiting to get afcmrrq.sql Lists managers that currently are running a request 1. What is difference between Single Node and Multi Node installation? Single Node - All components of Apps 11i installed on single machine. Means Database, Forms, Reports and Web Server, CM installed on Single machine. Multi Node – All component of Apps 11i installed on more the one-machine. Means Database, Forms, Reports and Web Server, CM installed on more then one machine. 2. What is difference between Single user and multi user installation? Single User - Both Database and Application tier are owned by Single Operating System Account Multi User - 11i Database Tier is owned by one O.S. User where as Application Tier is owned by different user. Important: In both cases Apps is installed as user ROOT 3. What is difference between express install or advanced install? Advanced Install – When we choose advanced installation option, Option define O.S user, Mount Point etc. Express Install – When we choose Express Installation option, installer installed Apps 11i on default location. 4. What is difference between PROD database and VISION database install type? PROD Database is installed with Apps without data. VISION Database is installed with Apps with dummy data. 5. What are various components installed after 11.5.10 (11i) install? 9iAS (1.0.2.2.2) web server, Developer 6i Forms & Reports, Discoverer, Jinitiator 6. What is O.S. level software requirement for installing Apps? ar, ld, make & X Display server for all unix machines (linux, solaris, IBM, HP Unix ) with following additional as per O.S. Linux- gcc, g++, ksh HP-Unix- cc, acc IBM AIX - cc, linkx1C For Windows you need Microsoft C++, MKS Toolkit, GNU Make 7. What is minimum approx. disk requirement for 11.5.10? For 11.5.10 Application Tier File System - 26 GB Database Tier (Fresh install) - 31 GB Database Tier (Vision install) - 65 GB 8. What is staging area? Staging Area is special directory structure where you make dump 11i installation software so that you don’t have to insert CD’s during install and Installer will automatically pick these disks. 9. How you set up staging area ? Coming Soon.