Oracle EBS R12 WebADI: Make it work with MS Office 2010

In Excel 2010

Go to File > Options. Following screen will open

Select Trust center

Click on Trust center settings

Select ActiveX Settings and make sure setting match following screen

Then click on Macro Settings and make sure settings match as following

Click on Protected View and make sure setting match as following

Click on External Contents and make sure setting match as following

Press Ok. Then again Press OK.

Should work now.... !! If it doesn't, check your IE settings

Now in Internet explorer

Go to Tools > Internet Options

Click on Security

Select Internet and then on Custom Level

Scroll Down to Download portion and match settings with following

Then Scroll down to miscellaneous section and match setting with following

Then Scroll Down to Scripting section and match setting with following

Press OK. Then again press OK.

Cheers!

Credit: http://mhizbullah.blogspot.se/2012/05/r12-web-adi-make-it-work-with-ms-office.html

Delete Balance Level Reporting Currency from Accounting Setup Manager (Oracle GL)

Deletion of Balance Level Reporting Currency is not supported by Oracle EBS. Workaround is to stop running translation. But I needed to get rid of the reporting currency anyway. So I've tested the deletion from the oracle base table where it stores the Relationship of the ledger with the reporting currency. It worked!


delete from GL_LEDGER_RELATIONSHIPS where relationship_id = 1001;

Of course, I took a backup of the table before running the statement ;-)

Cheers!