Oracle EBS Learnings

Fix SQL Developer loading issue in Mac: Let's say that you didn't like  default SQL developer PL/SQL Schema syntax and you are playing around with some custom syntaxes and in process have screwed the setting of your SQL developer and it doesn't load. Whenever you double click on the sql developer and it just hangs saying loading SQL extensions or gives some other reason or Let's say IT department being how frugal they are had given you a used MAC and you are trying to install SQL Developer and suppose it already had an version of SQL Developer all install and it doesn't let you open the existing you couldn't find out what is missing or wrong with your setup. You have uninstalled and reinstalled the SQL developer several times and still SQL Developer is stuck in the loading phase. You have ensured correct version of Java JDK is installed and you are following all the steps mentioned in the installations steps of Oracle SQL developer, you can do either of ...

Oracle applications R12.X forms don't open with Mac OS 10.X out of the box. It requires some work around to ensure that the forms open with firefox. This Blog post explains the workaround I used to open forms in firefox. STEP1: Uninstall existing firefox application Firefox version later than 52.X don't open the JAR/JAVA Files for Oracle Applications hence I have to uninstall any later versions of Firefox by removing Firefox from the applications folder for mac and thrashing it for good.  STEP2: Download older version of Firefox. Download the dmg file from  https://archive.mozilla.org/pub/firefox/releases/52.1.2esr/mac/en-US/ Once downloaded install firefox on mac and move the binary to applications folder. On the firefox to the preferences (or Developer options) and set the update option to 'Never check for updates' in the Advanced tab. Note: Since this firefox version is old it won't have all the security patches installed so use  STEP3 : Add t...