Installing an Oracle Server

This is an example of a reasonable priced Oracle server. The configuration below was around £700. From R12.2 an Oracle Weblogic Server is included so you will need a lot more power to install R12.2 in a reasonable time. You could install and run R12.1 on a 4Gb Atom CPU based server but for R12.2 […]

Posted in: Installation, Technical Knowledge by Kent Willumsen Comments Off on Installing an Oracle Server , , , , ,

Data Migration Strategy – a Functional Approach

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 […]

Posted in: Data Migration, Functional Knowledge, Technical Knowledge by Kent Willumsen Comments Off on Data Migration Strategy – a Functional Approach , ,

SQL Plus Instant Client

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, […]

Posted in: SQL, Technical Knowledge by Kent Willumsen Comments Off on SQL Plus Instant Client

SQL Developer Tips

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 […]

Posted in: SQL, Technical Knowledge by Kent Willumsen Comments Off on SQL Developer Tips

WebADI and Excel 2013

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 […]

Posted in: Office Tools, Technical Knowledge by Kent Willumsen Comments Off on WebADI and Excel 2013 ,

Excel for E-Business Suite

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. […]

Posted in: Office Tools, Technical Knowledge by Kent Willumsen Comments Off on Excel for E-Business Suite , , , , ,

Internet Explorer for E-Business Suite

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 […]

Posted in: Office Tools, Technical Knowledge by Kent Willumsen Comments Off on Internet Explorer for E-Business Suite , , , ,

Internet Explorer 10

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 […]

Posted in: Office Tools, Technical Knowledge by Kent Willumsen Comments Off on Internet Explorer 10 ,

Fixing R12.1.3

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 […]

Posted in: R12 Installation, Technical Knowledge by Kent Willumsen Comments Off on Fixing R12.1.3

Managing R12.1.3

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 […]

Posted in: R12 Installation, Technical Knowledge, Virtual Manager by Kent Willumsen Comments Off on Managing R12.1.3 , ,