Apr 21, 2010

Data Flow in SLA and COGS Revenue Matching

Session that I presented in OAUG Collaborate 2010 in Las Vegas, NV on 21-Apr-10

Mar 28, 2010

Upgrading IE (Internet Explorer)

With Microsoft announcing the beta release of IE9, many companies would be planning to upgrade from the (once?) stable IE6. Both 11i & R12 versions of Oracle Applications pose a challenge with respect to compatibility issues with different JRE versions. Careful consideration to different client operating systems (XP SP2, XP SP3, Vista, 7) should be given as well.

So here I am sharing my experience with upgrading the client machines. There are ActiveX controls to tweak for WebADI and also one needs to test the below to make sure the IE upgrade does not break anything:
  1. BI publisher reports
  2. MSCA (this requires a lower version of Java)
  3. WebADI
  4. Timeout (Automatic sign-on without loosing the form session - Profile values "ICX: Session Timeout" and "ICX:Limit Time")

The registry key (HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}\1.1\0\win32\) in Windows should have the below values:
  • shdocvw.dll for IE6
  • ieframe.dll for IE7

Both the above dll's are located normally under c:\windows\system32 folder.

The below metalink notes detail the recommended browsers for Oracle E-Business Suite (Certification Compatibility Matrix) for both IE & firefox browsers.
  • 285218.1 - Recommended Browsers for Oracle E-Business Suite Release 11i
  • 389422.1 - Recommended Browsers for Oracle E-Business Suite Release 12

Feb 25, 2010

Client - Server Interoperability Support

There are times when the oracle client on one's computer and the server version levels would not match (particularly when the DBA's are fast enough to get to the current level). One can see warning messages like this in TOAD.


So pl refer the metalink note 207303.1 (Client / Server / Interoperability Support Between Different Oracle Versions) which details the different versions that are supported at both client & server levels.

Note the version on the client can be same or newer than the server's.