Categories
Supply Chain

Oracle jumps into the SaaS market with SaaS Sourcing

Oracle jumps into the SaaS market with SaaS Sourcing | Technology and the Global Supply Chain | ZDNet.com.

Interesting to see that this is Oracle’s first foray into SaaS outside of the Seibel CRM products.

Oracle ERP salespeople tended to point customers towards the embedded Sales product; On Demand people touted their product. It will be interetsting to see which offering the ERP folks push now that they have a choice within their stable.

Categories
Technical

Oracle Applications on Windows 7

My geek nature meant that I had to try Windows 7 Beta on at least one of my computers. I can’t say I was as down on Vista as most people who leave comments online, but 7 seems to be a great leap forward. I like it. Getting the apps to run on Windows 7 is very similar to getting them to run on Vista:

Internet Explorer and Firefox:

  1. Download and install the latest version of Java (such as Version 6, Update 11). You can get it here.
  2. Copy the file C:\Program Files\Java\jre6\bin\client\jvm.dll to folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\bin\hotspot. (Overwrite the existing jvm.dll.)
  3. In folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib, rename “font.properties.zh.5” to “font.properties.zh.6” and “font.properties.zh.5.1” to “font.properties.zh.6.1”
  4. If you use multiple languages, use a text editor (such as Notepad) to open file “C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib\font.properties”. Search for “\u5b8b\u4f53=SIMSUN.TTF” and change it to “\u5b8b\u4f53=SIMSUN.TTC”. This is an optional step

Internet Explorer:

Go to Tools> Internet Options> Advanced. Disable 3rd Party Extensions by unchecking as below:

Click the Compatibility Viewer button to the right of the address bar as below and follow the instructions:

(My thanks to Garry Martin, CTO of Fujitsu’s Microsoft Practice in the UK for this IE8 tip.)

You should be good.

Firefox:

  1. Go to C:\Program Files\Oracle\Jinitiator 1.3.1.21\bin. Find “NPJinit13121.dll” and copy it.
  2. Paste it into C:\Program Files\Mozilla Firefox\plugins\.

Good luck!

Categories
Technical

Oracle Applications on Windows Vista

I bought a new laptop about a year ago and had Vista installed. I showed up at the client site the following Monday and spent the better part of a day trying to get Oracle to come up. Nothing I tried worked. That night, 3 days after the laptop arrived, I “upgraded to a previous version” and installed XP. I never gave a thought to Vista again until a colleague of mine brought his bright shiny new laptop into work a couple of weeks ago and nonchalantly mentioned that Oracle was working just fine with his Vista Ultimate. Like a red rag to a bull…!

Much Googling that evening – yeah I’m competitive!- led me to this solution. I’ve tried it on a couple of different computers and it seems to work well:

You should be able to make it work by following these instructions:

Internet Explorer and Firefox

  1. Download and install the latest version of Java (such as Version 6, Update 11). You can get it here.
  2. Copy the file C:\Program Files\Java\jre6\bin\client\jvm.dll to folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\bin\hotspot. (Overwrite the existing jvm.dll.)
  3. In folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib, rename “font.properties.zh.5” to “font.properties.zh.6” and “font.properties.zh.5.1” to “font.properties.zh.6.1”
  4. If you use multiple languages, use a text editor (such as Notepad) to open file “C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib\font.properties”. Search for “\u5b8b\u4f53=SIMSUN.TTF” and change it to “\u5b8b\u4f53=SIMSUN.TTC”. This is an optional step.

This should be all you need to get Oracle running on IE7. However, if IE7 crashes every time Jinitiator tries to open Oracle Forms, you should try disabling third-party browser extensions. In IE7, go to Tools> Internet Options> Advanced and uncheck the box as below:

If you are using IE8, you will also have to click on the Compatibility button to the right of the address bar as below:

(My thanks to Garry Martin, CTO of Fujitsu’s Microsoft Practice in the UK for this IE8 tip.)

Firefox

These additional steps are required if you plan to use Firefox:

  1. Go to C:\Program Files\Oracle\Jinitiator 1.3.1.21\bin. Find NPJinit13121.dll and copy it.
  2. Paste it into C:\Program Files\Mozilla Firefox\plugins\

Good luck!

Categories
Technical

SQL is my Friend

I think I’m a functional consultant with just enough technical knowledge to make himself very, very dangerous!

I’ve always been in awe of my developer friends and always will be. For many years I thought they practised some form of witchcraft. What you don’t understand always seems like magic, doesn’t it?

After several years of looking over the shoulders of some very patient friends – Ravinder Goyal and Sarath Yeturu, I owe you! – I started to pick little pieces of it up. I still don’t know a fraction of what these guys do, but I do know enough to be able to provide value to a client and I think that’s important. Anyone who can keep an SR moving by running scripts, create some table validated DFF’s and do some Forms Personalizations without having to wait for a developer to be available is more valuable to a client than someone who can’t.

SQL is my Friend is a document that I wrote with Pete Stees of Oracle Consulting. It shows how a functional consultant or BSA can pick up the basic SQL skills and how they might be used in an Oracle Applications context.

Categories
Planning

Adventures in Lead Times

I was working at my first client, a contract electronics manufacturer, in Ft Lauderdale, FL in the late 90’s and was responsible for implementing MRP. I was trying to figure out why I was getting wierd suggestions from my planning runs and didn’t find the documentation to be very helpful at all.

This was back in the days when Oracle Support was a phone call, not a website and I went on a tear for about a month calling multiple times every day until I could find someone who could answer my questions. Everything I was able to pry from them, or figure out myself ended up in this document, Adventures in Lead Times.

It follows the planning process through Item, BOM and Routing setup, explaining what order modifiers do and how the various lead times are calculated. It shows the effect that all of these have on MRP output. Many years later, I still think it’s a good introduction to the topic.

Categories
Uncategorized

Welcome to the Blog

Hi. I’m Dave Ireland, Principal at TheAppsFactory. We’re an Oracle Applications consulting company based in Lafayette, Colorado. My experience is in all things non-Financial. I’ve consulted in the CRM, Supply Chain and Manufacturing areas for over ten years.

I’m a very happy geek who loves his chosen profession!

TheAppsFactory Blog has been around for around 18 months, but was disconnected from the main website. After a suggestion from a website reader, who wanted to leave a comment on one of the posts, I decided to combine the blog and the website.

I want to use the blog to post tips, tricks and workarounds that I come across as I work with my clients. Comments and contributions are eagerly solicited!

Cheers,

Dave