Oracle Release 12, Windows 7, Internet Explorer - IE 10, Firefox, Safari Browser Settings

Recommended Internet Explorer Browser Settings: 

Security Zones

Microsoft Internet Explorer offers four different security zones to run your application through. Which zone is used is dependent 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:

It is recommended that Oracle E-Business Suite is run through the 'Trusted Sites' zone, with a 'Medium' Security Setting.

Setting up Oracle E-Business Suite to run through the 'Trusted Sites' zone, with a 'Medium' Security Setting. (If Required)

Step 1: Select Tools -> Internet Options -> Security tab -> Trusted Sites icon -> Sites button from the Internet Explorer Menu Bar.

Step 2: Set the 'Security Level for this Zone' to 'Medium' if it is not set already.

Step 3: In the 'Add this Web site to the zone:' field, enter the 'hostname and domain' of the environment you are running the Oracle E-Business Suite, 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. i.e. *.

(If you are entering an http://... or '*.' domain address, you must ensure that the 'Require server verification (https:) for all sites in this zone' is not checked).

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 Oracle Knowledge Base  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. 

Importing an SSL Certificate into Internet Explorer on Windows Vista, Windows 7 and Windows 8 

Note: Windows 8 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:

1. Enter the URL in the browser 
2. From the browser menu select: Tools -> Internet Options -> Security -> Trusted Sites icon. Security setting should be 'Medium' by default 
3. Make sure the 'Enable Protected Mode' option is off (not checked) 
4. 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) 
5. Save the changes and close the browser window 
6. Enter the URL in a new browser window 
7. 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)'. 
8. In the task bar click on the Red certificate error 
9. An Untrusted Certificate Window Pops, click on 'View Certificates' 
10. Click on Certification Path 'Tab' 
11. Highlight the Root certificate (will probably have a white cross in a red background next to it) and press 'View Certificate' 
12. Click on Install Certificate 'button' and press next 
13. Select  'Place all the certificates in the following store' 
14. Click 'Browse' and tick the 'Show physical Stores' box. 
15. Click the + next to 'Trusted Root Certification Authorities' folder 
16. If a folder exists called 'Local Computer' Click on it and select 'Okay' 
17. If that folder does not exist, highlight 'Trusted Root Certification Authorities' folder and select 'Okay' 
18. Press 'Next' followed by 'Finish' 
19. When the Security Window pops asking if you wish to install it, say 'Yes' then hit the 'finish' button 
20. Close the pop-up and the browser, when you next login, it should be fine. 
21. 
    

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 

Known Issues for Internet Explorer Users

• Windows 8 Specific Issues 
• Internet Explorer 8, 9 and 10 Specific Issues 
• Windows Vista and Windows 7 Specific Issues 
• General Internet Explorer Issues 
• Internet Explorer 6 Specific Issues 

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'

Internet Explorer 8, 9 and 10 Specific Issues

Display Issues in FWK (IE9 and 10) 

To prevent display issues within some FWK pages it is advisable to run your Oracle E-Business Suite environment through IE 'Compatibility Mode'. 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 dose not display properly. 

To workaround these issues, set the webpages to run through Internet Explorer 'Compatibility Mode'. 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 Mode' should correct any button, font or other display issues:

Buttons in Compatibility Mode will display properly. 

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, IE9 and IE10) 

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 Error 

Oracle E-Business Suite 12.0 and 12.1.1 users may see the following error in the browser window when launching forms based application: 

'Internet Explorer has modified this page to prevent a possible cross-site scripting attack'

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'.

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 

Users wishing to use this function should remain on IE8 until a fix is made available. 

Note: The password signature for workflow notifications will continue to work normally using IE9 or IE10. 

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 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.2 

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

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:

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 Firefox versions 3.6.x and higher only support next-generation java plug-in releases (JRE 1.6.0_10 or higher). Forms based products cannot be launched using 'classic java' versions (JRE 1.6.0_07 or earlier). If a 'next generation java' plug-in version is not available on the desktop client the browser will display the message, 'Additional plugins are required to display all the media on this page'. If an appropriate version is available from the Oracle E-Business Suite web server it can be downloaded and installed in the usual way. Alternatively, clicking the 'Install Missing Plugins' button or the 'Click here to download plugin' box will activate the Firefox 'Plugin Finder Service' which will offer the latest available version of the JRE plug-in for download and install. 

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 Firefox versions 3.0.x, 3.5.x, 3.6.x and ESR 10.x are no longer supported by the vendor. Vendor support for ESR 17.x ends on 3rd December 2013. It is recommended that any users running these versions upgrade to Firefox ESR 24.x. 

3rd Party Software Support Lifecycle

Oracle's certification of the various third party client operating system and browsers aligns with the respective vendor's support life cycle. 

Firefox versions 3.0.x, 3.5.x, 3.6.x and ESR 10.x are no longer supported by the vendor. Firefox ESR 17.x is currently due to be de-supported by the vendor on 3rd December 2013. It is therefore recommended that any users running Firefox upgrade to Firefox ESR 24.x. 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 is certified as a client browser on Windows XP SP3, Windows Vista SP1 & SP2, Windows 7 (32-bit & 64-bit) and Windows 8 (32-bit and 64-bit) with the following prerequisite requirements: 

• Oracle E-Business Suite Release 12.2. 
• Oracle E-Business Suite Release 12.1.3 
• Oracle E-Business Suite Release 12.0.6 with: 

1. Applications Framework Patch 7602616 
2. 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 3.5.x, 3.6.x, ESR 10.x, ESR 17.x are certified as client browsers on Windows XP SP3, Windows Vista SP1 & SP2,Windows 7 (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. 

Firefox: Known Issues

• General Firefox Issues 
• Windows Vista and Windows 7 with Firefox 

General Firefox Issues

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 

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: Safari for Mac Users

• Safari: Certification Matrix
• Safari: Recommended Browser Settings
• Safari: Known Issues 

Safari: Certification Matrix

The tables below outlines the currently certified Browser, Operating System and the certified JRE versions. Please also review this document for further specific certification information and requirements:

For further information and patch requirements for Apple Macintosh OS X version 10.7 and 10.8, please see Document 1533334.1, titled 'Oracle E-Business Suite Release Notes Release 12 for Apple Macintosh OS X version 10.7 and 10.8'.

For Internationalization information please see Document 393320.1, titled 'Internationalization Update Notes for Release 12'. 

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 

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 

The above posted contents are collected from various documents from the web. 

Thanks & Regards,

S.Grace Paul Regan 

Mocrosoft Add-Ins Error !

You may land in to simple errors while trying to install new add-ins to any of your Microsoft products . As a thumb rule always install .NET Framework (4.0) or later - Restart  and then install Visual Studio 2010 Tools for Office Runtime or later Restart and try to install your Add-Ins it may work.

For the above simple installations I wasted 2-hours to get the fix.

Thanks & Regards,
S.Grace Paul Regan

Oracle Apps in Windows 8

Just recently I started using windows 8 Consumer Preview and found all my Oracle related software and application process are running smooth. If not still I have the option to install the software in compatibility Mode.

Toad 9 & 11

Forms & Report 6i

Jdeveloper

BI Publisher

Oracle Database Server 11g

Oracle Application Forms Screen 11i & R12

Do not update your JRE version to 7 if you are using Internet Explorer 10 in windows 8. This will give you hell a lot of problem when you open Oracle Application Forms screen.

So far things seems to be good and will keep you posted if I encounter issues.

Fell free to upgrade your OS to Windows 8 it gives a bit of new experience.

Thanks & Regards,
S.Grace Paul Regan

ERROR 1723 - Java Error

Error 1723: Can not uninstall JRE update 1.6.9.21 from Windows 7 or Windows 8. I got this error after JRE 7 update. I was unable to open Oracle Application forms screen in R-12 instance.

Previously I have faced such issues and after long research and several trial and error methods, I have reinstalled my OS to fix the corrupt missing files - "but not this time"

Java Runtime Environment or Initiator will call the system stored dll files to open the Oracle forms screen. JRE 6 is the certified version with Oracle Forms Application when you update JRE 7 your jinitiator version stored in your system will not match with the jinitiator stored in the server from where you will be calling the run time environment files, hence you will get "You have a lower version of jinitiator you will have to upgrade to a latest version of the jinitiator",  but to do that you will have to remove the JRE 7 update and will have to manually install JRE 6 update.

If you try to install JRE 6 your system will give you error stating that you cannot install this version as a copy of this version already exists in your system and the will ask you to remove the update.

You should be very careful when you remove Java updates as these will leave a Trace deep in your system that will become a mess if you will be trying to install or remove JRE updates.

Try to remove the updates through the standard windows Add and Remove program that is available through your Control Panel or check for the JAVA in your control panel and you can remove it. But occasionally if you have deleted the Java files from the C:/Program Files system will nor allow you to remove the JAVA from the control Panel add and remove programs in such coactions you will have to go to REGEDIT

Incorrectly editing your registry may severely damage your system. At the very least, you should back up any valued data from your computer before making changes to the registry.
You can use the File->Export functionality of the registry editor to save the registry key before deleting. Then, in case you deleted the wrong registry key, you can restore the registry from your saved backup file, by using the strong>File->Import functionality in the Windows Registry Editor.

Steps to Edit/Delete Java registry entries through Registry Editor

1. Run the Windows Registry Editor by clicking Start->Run and entering the program name regedit in the Open edit field.
2. Navigate to the following registry node:
   HKEY_LOCAL_MACHINE/Software/Microsoft/
Windows/CurrentVersion/Uninstall
   
   
3. Under this Uninstall node, you will find many registry entry names enclosed in curly braces. e.g. {26A24AE4-039D-4CA4-87B4-2F83216013FB}
4. Click on each registry entries in the left pane and that will display its associated data on right pane of Registry Editor.
   or
   Click on Edit->Find tab in Registry Editor window and then enter Java version that you want to find Keys for
   For example: searching for Java(TM) 6 Update 24 finds this:

5. Delete the registry entry found for Java, by right clicking on the registry key name, and selecting Delete.
6. Click Yes on the Confirm Key Delete message box.
7. After you finish above steps, go back to the Windows Control Panel
   For Windows XP: Add or Remove Programs
   For Windows 7: Uninstall programs
   The entry for Java should no longer appear.

After performing the above steps you will remove java completely from the system but this will remove all the required DLL files that has to be in the system to support Java installation. Its a easy way to restore the same is to copy the JAVA files from other system where jinitiator is running fine. Once your JAVA files with the BIN folder are there in the system Program Files the system will allow you to install required version of JRE updated to work with.

Now you will have a commanding feel

"System should do what I say if not I will fuck its registry the hard way it dose what I say"


Most of the above contents were typed by me hence bear the mistakes and some of them copied and composed from various sites.

Thanks & Regards,
S.Grace Paul Regan

 

Remove Approve, Reject, Forward and Approve & Forward Links on Oracle Notification or Email Notification for Requisitons or PO

1.Open the workflow in workflow builder for example PO Approval workflow.

2.Look for the notification you want to change. eg. Approve PO Notification. The message assigned to this is 'Approve PO'.

3.Look at the properties for this message. select the 'Result' tab. Note the Lookup Type. In this example it is 'PO Approval Action'

4.Then in workflow builder you will see the lookup type 'PO Approval Action' here it has the attributes 'Approve, Reject, Approve and forward, Forward'

5.You can remove the options you want.
6.Then save the workflow and load it into the database

Installing Oracle 10g Client in Windows 7 Screwed My System!

Dear All,

Take extra precautions before you install Oracle 10g or any other client in Windows-7 operating system (even in compactible mode).

I faced the same problem some six months back, that “time” was critical as I did not have time to research to resolve this issue, I just reinstalled my OS to make my system work, but again the same issue happened yesterday with my Laptop as soon as you install the Client in your PC it locks your C:\ drive. System will be working but when you try to open the C:\ drive system will throw you error “Access Denied” I tried all possible ways to recover from this error, I tried with our Microsoft Support guys, Our Company IT guys, System Restore Option from my recovery disk, System Repair or (System Image Recovery – did not work because there was no image recovery in the system as it has to be done manually) or accessing C:\ drive through command prompt and all the system gurus in the net and was left helpless.
You cannot even uninstall hence you will not find the installed client in your add and remove program or you cannot access C:\ drive (even through command prompt) to delete the installed folders as C:\ is locked and you find yourself nicely and tightly screwed up in a right situation when you cannot afford to lose time.
Finally I decided to reinstall my OS and obviously it has to work unless I have hardware problem.

So my dear friends, I don’t want this to happen for any of you guys, so be extra careful before you install the client. Take a backup or image recovery to a latest date and then try to install Oracle Client hence always you have an option to restore your image recovery only if you have taken a recent backup manually because system does not take an automatic image recovery instead it just has the snapshot points for system restore which will not help you, read the compactable notes of the client before you install the client.

Through some note I came to know that Oracle 11g is compatible with windows 7, hence downloaded Oracle 11g database from Oracle site and installed with lots of care and it worked finally.

If any of you guys got any solution, kindly let me know.

Thanks & Regards,
S.Grace Paul Regan

Hyperlink Leads To Production Instance or Different Instance!

Dear ,

After cloning a Instance from Production there are some profile options which has to be updated with the present instance link for the hyperlinks sent through notification to work properly. Follow the below steps:

Using the System Administrator responsibility, go to profiles -> system
- Search for the profile option "POS: External URL"
- Set the profile option to:
http or https://external_web_server_machine:port/
- Search for the profile option "POS: Internal URL"
- Set the internal profile option to:
http or https://internal_web_server:port/
- After setting the above profile options run the following script as APPS: $POS_TOP/patch/115/sql/pos_upg_usr.sql

The above script updates the user level values of profile option Applications Framework Agent and Application Servlet Agent for all supplier users using the new values in the profile option POS: External URL.

Every time the value of profile option POS: External URL is changed, it is necessary to run this script.

Thanks & Regards,
S.Grace Paul Regan

How To Create Basic Personalizations?

Download and save the document White Paper - Basic Personalizations for instructions on how to do this

Thanks & Regards,
S.Grace Paul Regan

What profile options are relevant when setting up personalization in OA Framework?

1. Set FND: Personalization Region Link Enabled (FND_PERSONALIZATION_REGION_LINK_ENABLED) to Yes

Now Personalize Region links should appear above each region in a page. Each link takes the user first to the Choose Personalization Context page, then to the Page Hierarchy Personalization page with focus on the region from which you selected the Personalize Region link.


2. Personalize Self-service Defn (FND_CUSTOM_OA_DEFINTION)

You should set this profile option to Yes at the user level for an administrator. If you set this profile option to Yes, then when you log on as the Administrator, a global Personalize Page button appears on each OA Framework-based application page. When you select the global Personalize Page button on any page, the personalization user interface prompts you for the scope and administrative level at which you wish to create your personalizations before displaying the OA Personalization Framework UI.



3. Disable Self-service Personal (FND_DISABLE_OA_CUSTOMIZATIONS)

This is a system profile option specifically created for use by Oracle Support. You can set this profile option to Yes at the site or application level. If this system profile option is set to Yes, any personalizations you make, regardless of the level at which you make the personalizations, will not be applied. Only the original base definition of each OA Framework-based application page is ever displayed. Use this profile option to help Oracle support staff determine whether a problem arises from applied personalizations or from the base application. The default is No.

Thanks & Regards,
S.Grace Paul Regan

Discoverer Error : oracle.disco.bibeans.parameter.LOVException: OK

500 Internal Server Error
oracle.disco.bibeans.parameter.LOVException: OK:

After you open the discoverer report

Go to Perferences> Under Query Governor heading you will find your LOV name > Change the default value from 15 to 60 or 120 then apply and try back.

This will solve most of the above error.

Thanks & Regards,
S.Grace Paul Regan

Windows-7 Audo Drivers (Work Around) !

Dear All,

Hope by this time most of the Techie should have installed windows-7 operating system like me if you have installed the OS in some old machines you will find some difficulty in downloading the Audio drivers and other drivers

Before you search for the driver with Microsoft windows-7 release or your PC manufacturers site (Eg: HP Driver Support Site) go to Control Panel > Sound > Speaker > Properties > Controller Information > Properties > General Tab Check for the Manufacturer name if its different from Microsoft (Eg: Realtech) then go the manufacturers site to download the driver, If its Microsoft go to Microsoft's site or go to the next tab Driver and press the update driver button to download the driver from the Internet. Most of the PC manufacturers has not updated their driver support data base with the windows-7 compatible drivers, So you will not find the drivers with your PC Manufacturer.

These tips above are very simple but if you are confused where to find the driver please follow these instructions to download the driver.

This works for other supporting hard ware drivers also like Web-Cam, USB Port, Sync ..

Thanks & Regards,
S.Grace Paul Regan
965(66382159)

Oracle Application on Windows-7

Internet Explorer and Firefox:

1. Download and install the latest version of Java (such as Version 6, Update 11).
You can get it here.

2. Copy the file C:\Program Files\Java\jre6\bin\client\jvm.dll to folder C:\Program
Files\Oracle\Jinitiator 1.3.1.21\bin\hotspot. (Overwrite the existing jvm.dll.)
In folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib,

3. rename “font.properties.zh.5″ to “font.properties.zh.6″ and “font.properties.zh.
5.1″ to “font.properties.zh.6.1″

4. If you use multiple languages, use a text editor (such as Notepad) to open
file “C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib\font.properties”. Search
for “\u5b8b\u4f53=SIMSUN.TTF” and change it to “\u5b8b\u4f53=SIMSUN.TTC”. This is
an optional step

5. Go to Tools> Internet Options> Advanced. Disable 3rd Party Extensions by
unchecking

Firefox:

Go to C:\Program Files\Oracle\Jinitiator 1.3.1.21\bin. Find “NPJinit13121.dll” and copy it.
Paste it into C:\Program Files\Mozilla Firefox\plugins\

Thanks & Regards,
S.Grace Paul Regan

Oracle Real Application Clusters (RAC)

Dear All,

Some FAQ about RAC which I came across very recently.

What is RAC and how is it different from non RAC databases?

RAC stands for Real Application Clusters. It allows multiple nodes in a clustered system to mount and open a single database that resides on shared disk storage. Should a single system fail (node), the database service will still be available on the remaining nodes.

A non-RAC database is only available on a single system. If that system fails, the database service will be down (single point of failure).


Can any application be deployed on RAC?

Most applications can be deployed on RAC without any modifications and still scale linearly (well, almost).

Applications with 'hot' blocks (the same data blocks continuously accessed by processes on different nodes) may not work well. This is because data blocks will constantly be moved from one Oracle Instance to another. In such cases the application may need to be partitioned based on function or data to eliminate the contention.


Do you need special hardware to run RAC?

RAC requires the following hardware components:

A dedicated network interconnect - might be as simple as a fast network connection between nodes; and
A shared disk subsystem.
Example systems that can be used with RAC:

Windows Clusters
Linux Clusters
Unix Clusters like SUN PDB (Parallel DB).
IBM z/OS in SYSPLEX
HP Serviceguard extension for RAC


How many OCR and voting disks should one have?

For redundancy, one should have at lease two OCR disks and three voting disks (raw disk partitions). These disk partitions should be spread across different physical disks.

How does one convert a single instance database to RAC?

Oracle 10gR2 introduces a utility called rconfig (located in $ORACLE_HOME/bin) that will convert a single instance database to a RAC database.

$ cp $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC.xml racconv.xml
$ vi racconv.xml
$ rconfig racconv.xml
One can also use dbca and enterprise manager to convert the database to RAC mode.

For prior releases, follow these steps:

Shut Down your Database:
SQL> CONNECT SYS AS SYSDBA
SQL> SHUTDOWN NORMAL
Enable RAC - On Unix this is done by relinking the Oracle software.
Make the software available on all computer systems that will run RAC. This can be done by copying the software to all systems or to a shared clustered file system.
Each instance requires its own set of Redo Log Files (called a thread). Create additional log files:
SQL> CONNECT SYS AS SYSBDA
SQL> STARTUP EXCLUSIVE

SQL> ALTER DATABASE ADD LOGFILE THREAD 2
SQL> GROUP G4 ('RAW_FILE1') SIZE 500k,
SQL> GROUP G5 ('RAW_FILE2') SIZE 500k,
SQL> GROUP G6 ('RAW_FILE3') SIZE 500k;

SQL> ALTER DATABASE ENABLE PUBLIC THREAD 2;
Each instance requires its own set of Undo segments (rollback segments). To add undo segments for New Nodes:
UNDO_MANAGEMENT = auto
UNDO_TABLESPACE = undots2
Edit the SPFILE/INIT.ORA files and number the instances 1, 2,...:
CLUSTER_DATABASE = TRUE (PARALLEL_SERVER = TRUE prior to Oracle9i).
INSTANCE_NUMBER = 1
THREAD = 1
UNDO_TABLESPACE = undots1 (or ROLLBACK_SEGMENTS if you use UNDO_MANAGEMENT=manual)
# Include %T for the thread in the LOG_ARCHIVE_FORMAT string.
# Set LM_PROCS to the number of nodes * PROCESSES
# etc....
Create the dictionary views needed for RAC by running catclust.sql (previously called catparr.sql):
SQL> START ?/rdbms/admin/catclust.sql
On all the computer systems, startup the instances:
SQL> CONNECT / as SYSDBA
SQL> STARTUP;


How does one stop and start RAC instances?

There are no difference between the way you start a normal database and RAC database, except that a RAC database needs to be started from multiple nodes. The CLUSTER_DATABASE=TRUE (PARALLEL_SERVER=TRUE) parameter needs to be set before a database can be started in cluster mode.

In Oracle 10g one can use the srvctl utility to start instances and listener across the cluster from a single node. Here are some examples:

$ srvctl status database -d RACDB
$ srvctl start database -d RACDB
$ srvctl start instance -d RACDB -i RACDB1
$ srvctl start instance -d RACDB -i RACDB2
$ srvctl stop database -d RACDB
$ srvctl start asm -n node2
Before Oracle 8.0, use the following command sequence from each node (using the old server manager):

SVRMGR> connect INTERNAL
SVRMGR> set retries 5
SVRMGR> startup parallel retry .. or SVRMGR> startup shared
You can also use the SET INSTANCE instanceN command to switch between instances (if defined in TNSNAMES.ORA).


Can I test if a database is running in RAC mode?

Use the DBMS_UTILITY package to determine if a database is running in RAC mode or not. Example:

BEGIN
IF dbms_utility.is_cluster_database THEN
dbms_output.put_line('Running in SHARED/RAC mode.');
ELSE
dbms_output.put_line('Running in EXCLUSIVE mode.');
END IF;
END;
/

For Oracle 8i and prior releases:

BEGIN
IF dbms_utility.is_parallel_server THEN
dbms_output.put_line('Running in SHARED/PARALLEL mode.');
ELSE
dbms_output.put_line('Running in EXCLUSIVE mode.');
END IF;
END;
/

Another method is to look at the database parameters. For example, from SQL*Plus:

SQL> show parameter CLUSTER_DATABASE
If the value of CLUSTER_DATABASE is FALSE then database is not running in RAC Mode.


How can I keep track of active instances?

You can keep track of active RAC instances by executing one of the following queries:

SELECT * FROM SYS.V_$ACTIVE_INSTANCES;
SELECT * FROM SYS.V_$THREAD;
To list the active instances from PL/SQL, use DBMS_UTILITY.ACTIVE_INSTANCES().


Can one see how connections are distributed across the nodes?

Select from gv$session. Some examples:

SELECT inst_id, count(*) "DB Sessions" FROM gv$session
WHERE type = 'USER' GROUP BY inst_id;
With login time (hour):

SELECT inst_id, TO_CHAR(logon_time, 'DD-MON-YYYY HH24') "Hour when connected", count(*) "DB Sessions"
FROM gv$session
WHERE type = 'USER'
GROUP BY inst_id, TO_CHAR(logon_time, 'DD-MON-YYYY HH24')
ORDER BY inst_id, TO_CHAR(logon_time, 'DD-MON-YYYY HH24');


What is pinging and why is it so bad?

Starting with Oracle 9i, RAC can transfer blocks from one instance to another across the interconnect (cache fusion). This method is much faster than the old "pinging" method, where one instance had to write the block to disk before another instance could read it.

Oracle 8i and below:

Pinging is the process whereby one instance requests another to write a set of blocks from its SGA to disk so it can obtain it in exclusive mode. This method of moving data blocks from one instance's SGA to another is extremely slow. The challenge of tuning RAC/OPS is to minimize pinging activity.


Thanks & Regards,
S.Grace Paul Regan

Open Oracle Application R-12 screen in Mozilla Firefox Web Browser

JRE Client Plug-in Download

The JRE Plug-in will not automatically download from the server, if the correct JRE version is not already installed on the client, when using the Firefox browser. This is due to bug 5855986, which is scheduled to be fixed in release 12.1
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 taskbar.

•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. This will open another window which will say;
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.

Tab functionality in the Firefox Browser

Firefox 2.0.x uses tabbed browsing by default. This facility can also be enabled in Firefox 1.5.x from the browser menu through Tools > Options > Tabs. Forms in the 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 at,
http://www.mozilla.org/editor/midasdemo and http://www.mozilla.org/editor/midasdemo/securityprefs.html.

BIDI Language Users

BIDI Languages are not supported with Self Service Applications using the Firefox Browser.

Thanks & Regards,
S.Grace Paul Regan

Oracle Application User Creation

I have attached a small video secession of User Creation and Responsibility addition in Oracle Application using sys-admin responsibility.

User Creation and Responsibility Addition Video Secession
Click Me - Google On-line streaming Video
Click Me - Download .wmv format video session

Any comments or up-dates can be mailed to : regan.gpr@gmail.com, Help this free learning link grow and reach the needy with your valuable comments.

Thanks & Regards,
S.Grace Paul Regan.

Oracle Application on IE-7

Dear All,
Its a common issue that most of the guys get issue on opening Oracle Application in Internet Explorer 7. One of the shortest way to change the settings of internet explorer 7 is to

1. Go to Tools>Internet Options>Advanced>Restore Advanced Settings and Reset... after resetting, restart the Internet Explorer and try to Open Oracle Applications again and you may suceed.
2. Always keep the Pop-up blocker and Pishing filter in OFF mode, Most of the time your Pop-up bocker and Pishing filter may block the Oracle jinitiator screen.To turn off the Pop-up blocker go to >Tools>Pop-Up blocker>Turn Off Pop-up blocker, To turn off the Pishing Filter go to>Tools>Turn off automatic web site checking.....

The above simple steps will most of the time help you resolve the issue in viewing Oracle Application in Internet Explorer-7. Still if you face issues please do post your queries, I will try my best to help you.

Thanks & Regards,

S.Grace Paul Regan