Migrating Workflow Changes Between HR.NET Instances

This blog post is a click-by-click guide to migrating changes from one HR.NET instance to another.The obvious first step is to log onto the source server were you have been developing/ testing your new workflow and run the HR.NET Admin Console provided by Vizual as part of the standard install.PrerequisitesObviously you'll need two HR.NET instances, you'll need to be able to run the Admin Console for the two instances (i.e. you will need a HR.NET...

Read More

How to Schedule A Meeting with Doodle

The Doodle scheduling tool allows you to put out a range of dates, or options, to a group of people and have each one express a preference. You can then view a summary of the results.The first step, as you would expect, is to open your web browser and go to the website Doodle.Click on the "Schedule event >>" button the the right of the page.On this page you need to specify the title for your meeting (i.e. "To Agree A Time For A Local Meeting")....

Read More

Oracle EBS: Monitoring Oracle e-Business Suite Using SQL

This Knol covers adding a stored procedure and some tables to the Oracle database that will allow you to monitor settings within Oracle so that, for example, if you clone your live system to a development machine and then apply a patch you will be able to instantly see what has changed.How It WorksThis couldn't be simpler; the table SYSCHECKLIST contains many small SQL queries. Each of these returns "OK" (a single row) when it is successfully run against the Oracle database.It's probably easiest to look at an example. If we take Profile Options....

Read More

Oracle EBS: Linking Directly to SQL Server Reporting Services from Oracle e-Business Suite

This blog post covers (with a fairly simple example) a way of having a menu item in Oracle "punch out" to a SQL Server Reporting Services Report (or any other URL).The reasoning behind doing this is that if you have a process driven by Oracle and need a report users don't want to then have to bring up Internet Explorer, browse to the Report website, and finally select their report. Using this process makes the join practically seemless to the end...

Read More

Oracle EBS: Currency Conversion in Oracle Internet Expenses (OIE.K)

This blog post aims to explain where the conversion rate in Oracle Internet Expenses is derrived from and how setting a policy can have quite a significant effect on the total value returned.The exchange rate used to convert a non-GBP expense claim back into GBP to be paid is handled in two parts within Oracle.In the General Ledger (GL) there is a table of "Daily Rates";This shows the currency conversion rate entered into the system for a specific...

Read More

Oracle EBS: Viewing General Ledger (GL) Daily Currency Conversion Rates

NOTE: This SQL works in version 11.5.10.2, your version might be different!Many companies like to have "one version of the truth" (I say "like to" as we all know how hard this is to actually achieve!). One of the ways this can be achieved is a standardised set of currency conversion rates across an organisation.The SQL in this blog post gives you a quick and easy report showing the currency conversion rates currently being used in the GL.If your company is using Oracle Finance software (i.e. General Ledger) and the currency conversion rates are...

Read More

Oracle EBS: Updating Vendor and Vendor Site (Supplier) Information in Oracle e-Business Suite (11i)

This blog post covers how you update Vendor and Vendor Site records in Apps 11i. The included example shows how you clear the Tax Code associated with both types of record (this is particularly useful in the UK where our Sales Tax has changed).The ProblemChanges quite often need to be made to the records in the PO_VENDORS and PO_VENDOR_SITES tables that involve changes to a large number of records . For example when the Sales Tax (VAT) rate changed...

Read More

Installing Systems Centre Operation Manager (SCOM) 2007 with SP1

This guide is intended as a simple checklist of things you need to do in order to get a "working" SCOM test environment up and running under some form of "virtualising" technology (we use Microsoft's Hyper-V, but exactly the same instructions should work in VMware Workstation, VirtualBox etc). In order to put this guide together I've made the following assumptions (well, OK, there weren't really any assumptions - this is how the environment I had to use was configured);Your server operating system is Windows 2003R2 SP2 32-bit. The links below will...

Read More