A day in the life of an Oracle Applications Consultant

Thursday, December 16, 2004

OAUG Connection Point 2005 - Call for papers now open

If you’re planning on speaking at or attending OAUG Connection Point 2005 the call for papers is now open.

OAUG Connection Point 2005 Conference is taking place in Dallas, Texas from June the 13th - 16th of June, 2005. The conference will be held at the Gaylord Texan Resort and Conference Center, Dallas, Texas, USA. According to the conference web site: -

OAUG Connection Point 2005 will provide you with an unparalleled networking and educational environment and will be attended by users of Oracle Applications who are seeking to maximize their knowledge, experience and understanding of the applications that they use to run their organizations.

The call for papers closes on the 7th of February 2005. I’m certainly hoping to make this conference as the OAUG events are normally very well attended.

Wednesday, December 15, 2004

Finally!! - Oracle Buys Peoplesoft

Well, I guess it’s good news if you are an Oracle Consultant or Implementor like myself. If you’re a JD Edwards or Peoplesoft Consultant or Implementor it could be interesting times.

After a long and protracted take over battle, Oracle has finally bought Peoplesoft. I remember thinking at the beginning of Oracle’s take over efforts that it was going to happen one way or the other and so it has. Fortunately, Oracle in taking over Peoplesoft has also managed to swallow up J.D. Edwards so now they only really have SAP, Microsoft and the Open Source Movement to contend with. You can check out the official press statement here. I noted with interest the following lines in the press statement: -

This merger works because we will have more customers, which increases our ability to invest more in applications development and support. We intend to enhance PeopleSoft 8 and develop a PeopleSoft 9 and enhance a JD Edwards 5 and develop a JD Edwards 6. We intend to immediately extend and improve support for existing JD Edwards and PeopleSoft customers worldwide.

I guess this offers some relief to Peoplesoft and J.D. Edwards customers in the short term but knowing how difficult it could be to integrate these products
into Oracle E-Business Suite I wouldn’t be surprised if Oracle decides to kill both of them and just retain the customers and some of the skills and infrastructure used to build, distribute, market and sell these products.

Also check out the Oracle Peoplesoft Page for more in depth information on the deal.

Tuesday, December 14, 2004

Enabling Timezone feature in Oracle 11i

Timezone (with day light savings!) feature is available in Oracle 9i Release 2 onwards. This post attempts to describe the steps required to enable Timezone functionality in Oracle Service module.

Recently I was at a client site and the client is desperately looking for this feature mainly to handle increasing number of client calls from multiple timezones. When customer support personnel attend a client call, it is important to know the client’s timezone and talk in terms of their timezone. It is also helpful to see all the date/time information in local timezone to better perceieve about the actual start time or scheduled start time for any activity. The database timezone is setup as GMT but the user wants to setup their own timezone based on their work location. This is exactly what Oracle 11i provides ( with Oracle database 9i Release 2 onwards).

After playing with the setups for few hours with some help from the dba I was able to make the timezone feature work in the client’s test instance (11.5.9). We also noticed that new functionality has been added in the calendar popup window to convert date/time into a different timezone. Here is how the new calendar window looks:


The following are the setup steps:

Oracle Environment variable Setup ( DBA Setup)

Please make sure that timezlrg.dat file exists in the database $ORACLE_HOME directory.

[1]. Add ORA_TZFILE environment variable in SID_hostname.env file present in database and application $ORACLE_HOME directory.

a) enter the following command in Unix:

b) save the SID_hostname.env file in the in the database $ORACLE_HOME directory

c) shutdown and restart the database.

[2]. Run the following query in Sqlplus to verify that the v$timezone_names view is populated:

>select count(*) from v$timezone_names;
The number of count should be increased due to new environment variable.

[3]. Try to login to Applications again with the client timezone set.

System Profile Options( Apps sysadmin setup)

Responsibility: System Administrator
Navigation: profile > System

Client Timezone : (GMT -06:00) Central Time
Enable Timezone Conversions : Yes
Server Timezone : (GMT +00:00) GMT
Service: Default value for Service Request Timezone type List Item:  Agent


User Preference( User setup)

Navigation : E-Business Suite Home > Preferences


  • Saturday, December 11, 2004

    Oracle Blogs at OpenWorld San Fransisco

    OpenWorld San Fransisco has just come to an end and I must say I am sad that I wasn’t able to attend. However, the Oracle online offering made up for it - this post highlights the key features of the site.

    I thought the Oracle OpenWorld Online site featuring what was happening at this years conference in San Fransisco was particularly good. Although I missed the conference I felt like I was there since I was able to get updates every day in a variety of media formats as highlighted below: -

    I had a 2 hour train trip from Hengelo to Schipol today so I downloaded some of the keynotes last night and watched them on the journey - it helped ease the boredom. What I thought was particularly good development for the blogging community was the Blogging Center

  • where there were contributions from a number of well known Oracle Bloggers as follows: -

    I enjoyed reading all the contributions but in particular though Mark Rittman’s effort was really good.

    Friday, December 10, 2004

    Discoverer Viewer and Portal Integration Demonstration

    I recently came across two online video demonstrations of Oracle Discoverer Viewer and its Integration into Oracle Portal on Oracle’s Discoverer Page. This post contains the links to the videos.

    According to the Oracle Discoverer Page: -

    Discoverer is an intuitive ad-hoc query, reporting, analysis, and Web-publishing tool that empowers business users at all levels of the organization to gain immediate access to information from data marts, data warehouses, online transaction processing systems and Oracle E-Business Suite.

    Online demos are here: -

    Page 1 of 2 pages  1 2 >