How do we determine what currencies to use for our ledgers? Accounting regulations like FASB52 and IAS21 (see regulatory limitations below for details) does not put many limitations on us. Neither does the Oracle R12 ledger setup – at least not evidently according to the FCG (see references section below for acronyms). FASB52 and IAS21 […]
Having been on a few projects now where the data migration was treated as a technical exercise and felt the impact of this – now it’s time to describe the data migration from a functional perspective. Data migration strategy also called data conversion strategy is the basis for this. Focusing on the functional perspective helps […]
As a functional consultant you’re often asked to run a SQL*Plus script from Oracle Support however these scripts does not always behave well with SQL Developer. So instead you can use a little tool called SQL Plus Instant Client. Installation You need to download: Instant Client Package – Basic: All files required to run OCI, […]
This is my little collection of SQL Developer tips for functional consultants like myself – so nothing complicated really but good to know. Default Output directory: When running in script mode and you use the spool commend your output will be located in: %APPDATA%\SQL Developer Due to the space be sure to use "s: dir […]
Office 2013 (or Office 365) has been released a now we all wonder if it will work with WebADI? You need to set the usual Internet Options and Excel Options. And it works: But there are a few quirks… Worst bit is the Oracle Add-In button is missing. It works ok but you need to […]
Decided to gather all Excel settings in one place for my own sake really. It might be redundant with some existing posts here but I like it to be easily accessible. The settings below should work with the latest versions of Excel – so far 2007; 2010 and 2012. Pictures below are from Excel 2010. […]
Decided to gather all IE settings in one place for my own sake really. It might be redundant with some existing posts here but I like it to be easily accessible. The settings below should work with the latest versions of IE – so far IE8; IE9 and IE10. Version specific settings are at the […]
Windows 8 has arrived with a new version of Internet Explorer. However will it work with Oracle e-Business Suite? Even if you follow my IE9 instructions you will be faced with two issues. Login Screen having garbled buttons: Menu Screen having “undefined” responsibility names and buttons garbled: Well, the solution is simple – click the […]
This is a part of the post of how to install R12.1.3 from a VM template. This post describes various fixes to the R12.1.3 functional and technical content of the VM template. BNE UIX Physical Directory is not configured When trying to use WebADI you get the error: BNE_UIX_PHYSICAL_DIRECTORY is not configured In R12.1.3 and […]
This is a part of the post of how to install R12.1.3 from a VM template. Start OVM in VBOX Start Virtual Box: This also starts the Oracle VM manager database as you can see on the last line above. Login to OEL6.1: Username: oracle Password: oracle Start Firefox in OEL6.1 and click Oracle VM […]
