Custom Schemas Naming Convention in Oracle Applications.

Have we ever questioned ourselves, why custom schema names always start with ‘XX<some_name>‘? Before getting into the detail let’s check what happens if the custom schema name doesn’t start with ‘XX’.

If you don’t have a custom schema name starting with ‘XX’, be assured that this schema will be no longer available in our instance when we perform an UPGRADE. During upgrade Oracle apps will clear all unregistered schemas, which doesn’t start with ‘XX’.

Oracle had assured its customers that it would not touch any schemas that start with ‘XX’. This is the main reason why we find custom schema names starting with ‘XX’.

Oracle 11i forms crash in IE

Unable to open forms due to IE Error in 11i or Forms crashes with IE Error or Jinitiator Issue.This is due to jvm incompatibility used by other Application or tools.

Solution : o Go to program files java ==> jre1.6.0_07 (Or recent jre we can download from java.sun.com). Path : C:\Program Files\Java\jre1.6.0_07\bin\client
o Copy the jvm.dll file o Go to C:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot o Take the backup of current jvm.dll file o Copy the jvm.dll file, which you have copied from the above jre directory. o Close all the browsers and restart Now can access the forms now.