These are included as examples of the work I've done over the years. Subject matter is scattered over the areas that I've worked in. What I consider to be my best work is proprietary for my clients, so could not be included here.
You're welcome to download them and use them as long as you give TheAppsFactory credit. Click on the link to download it. All except the spreadsheet are in .pdf format.
| Document | Comments |
|---|---|
| Adventures in Lead Times | I wrote this at the end of my first consulting engagement. It was my first exposure to Oracle MRP and I couldn't reconcile the documentation available with what I saw in the application. I was a thorn in the side of Oracle Support for a couple of months until we got it figured out! It describes how Lead Times, Order Modifiers, Bills and Routings interact together in the planning process |
| SQL is My Friend | Having come to consulting from the functional, rather than technical side, I think I relied on my techie friends for far too long. This is an attempt to remove the fear factor for functional consultants, show them some simple SQL commands and show them how they can use them to a client's, and their own, benefit. It's based on Oracle's new SQL Developer tool. |
| Service Contracts Electronic Renewals | Oracle introduced this in 11.5.9 and, once we got it working, it produced lots of "ooh's" and "aah's" from the client. The documentation was a bit sketchy at that time, so this was a how-to document for the client after the consultants rolled off. |
| Making DFFs Organization-Specific | This was part of a thread in the Inventory Forum on Metalink. It shows how to make a DFF show up in one Inventory Organization, but not in others. |
| iExpense Spreadsheet | I think that iExpenses is a nice tool, but it has a couple of drawbacks. First, data entry is a little bit clunky - forms based apps are far easier for volume data entry - and second, you can only use it when you're on line. Oracle did provide a spreadsheet that you can download, complete and then upload into the application, but it's still not that easy to use. This version sits on top of the Oracle spreadsheet and is much simpler. The client enabled DFFs for airline and mileage information, so there's quite a bit of Visual Basic in the background that guides a user through entering valid information. |
Oracle Applications on Windows Vista
Oracle Applications on Windows 7