OracleAppsBlog
A day in the life of an Oracle Applications Consultant

Version or Release

Friday, March 18, 2005

Project Fusion - merging the Oracle, J.D. Edwards and Peoplesoft Software

In a press release in January 2005, John Wookey unveiled the combined Oracle and PeopleSoft product roadmap and support plans. This post contains the details of Project Fusion, the new effort to merge the JDE, Peoplesoft and Oracle Software.

According to the press release, Project Fusion is "revolutionary technology that will follow an evolutionary path."

Wookey stated: -

The new “Project Fusion” is a new information age architecture based on industry standards that will be modularized for flexible deployment, optimal performance and easy maintenance. New information-driven applications will incorporate key strengths of all product lines and focus on business process automation, industry-specific capabilities, superior usability, real-time information access and reporting, and a shared data model to provide customers with a single source of truth. The “Project Fusion” architecture will leverage the latest Oracle technology for scalability, availability, security and performance. The new architecture and the results companies will achieve will be truly revolutionary, but the path to the new successor product line will be evolutionary.

What was most interesting to see that there is already a timeline for the rollout of the upcoming releases of the software under discussion as well as an estimated release date for Project Fusion which is as follows: -

  • PeopleSoft Enterprise 8.9 (2005)
  • Oracle E-Business Suite 12 (2006)
  • PeopleSoft Enterprise 9 (2006)
  • JD Edwards EnterpriseOne 8.12 (2006)
  • Ongoing JD Edwards World enhancements planned to be delivered continuously
  • First Project Fusion components, specifically data hubs and transaction bases, (beginning in 2006)
  • Initial "Project Fusion" applications (2007)
  • "Project Fusion" applications (2008)

The press release also contains support milestones and other useful links. There’s also an interesting page on the Oracle site entitled Strategic Direction and Vision that has more information on Project Fusion. It states that Oracle will continue to support Peoplesoft until 2013 and has the following to say about Project Fusion:

Project Fusion: The Successor Product
In addition to continuing development of the three existing lines, we plan to develop a successor suite of products—which is called ‘Project Fusion’—where we hope to merge the features and functions of the J.D. Edwards products and the PeopleSoft products and the Oracle products together. We’ll build, if you will, a super-set application suite using modern technology.

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:

image


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.

Example:
a) enter the following command in Unix:
ORA_TZFILE=$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat
export ORA_TZFILE

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;
COUNT(*)
—————
1286
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

image

User Preference( User setup)

Navigation : E-Business Suite Home > Preferences

image

  • Wednesday, December 08, 2004

    Oracle E-Business Suite 11.5.10 - Vision Instance

    This post contains details of a publicly accessible Oracle Application 11.5.10 Vision instance.

    When I met Karen Brownfield at an Atlanta Oracle User Group  meeting two weeks ago she mentioned that Solution Beacon  (who currently host a freely accessible 11.5.8 and 11.5.9 Vision Instance) would shortly be hosting a publicly accessible 11.5.10 instance. I noticed over the weekend that this instance is now available. I think providing this type of facility for public access is extremely cool. All you have to do is fill out the free registration and you are allocated a user name and password.

    I’ve noticed there’s quite a few new modules and a slightly new look and I hope to be writing on these over the next couple of months. You can access this instance here and you will need to run through the installation of the new version of Jinitiator (1.3.1.18). I would advise you to de-install any existing Jinitiator versions you have. I performed the install on my new IBM X40 laptop (which came with my new job) and since there were no prior versions of Jinitiator I haven’t run into any issues. Also remember that if you have any pop up blocking software installed, you should allow pop ups for the Vision Instance URL as the Jinitiator software install will not start with popup blocking on the URL.

    Well done to Solution Beacon for providing this instance and I hope readers enjoy accessing this system and taking a look at what’s new.

    Release 11.5.10 Financials - New Features

    Two weeks ago I spoke at the Atlanta Oracle Applications User Group meeting and also attended a breakout session headed up by Karen Brownfield of Solution Beacon which discussed the new features in 11.5.10. This post contains the presentation which Karen kindly agreed for me to upload and also has links to other sources of information on 11.5.10. 

    The presentation in question was presented at the OAUG Connection Point 2004 Conference and I thought it would be useful to share it with readers of the blog. It covers the following areas of Financials: -

    • Payables
    • Internet Expenses
    • Cash Management
    • Property Manager
    • Assets
    • iAssets
    • Receivables
    • Bill Presentment
    • Advanced Collections
    • iReceivables
    • General Ledger
    • Enterprise Budgeting and Planning

    Credits for the preparation of this presentation on Release 11.5.10 Financials New Features should go to the following: -

    Additionally, you can visit the Oracle 11i10 page for various presentations and videos on the latest release of Oracle E-Business Suite 11i.

    Saturday, November 20, 2004

    11.5.10 (11i10) Release and Documentation

    11i10 was released by Oracle last week. This post contains the link to the new downloadable documentation CD (note if you have not already done so, you will have to register with OTN).

    You can now download the 11.5.10 documentation CD as I understand 11i10 was released last week. It contains documentation according to the following categories: -

    • Technology
    • Intelligence
    • Marketing and Sales
    • Order Management
    • Logistics
    • Supply Chain Planning
    • Procurement
    • Manufacturing
    • Maintenance Management 
    • Service
    • Projects
    • Product Lifecycle Management
    • Financial
    • Human Resources
    • Customer Data Management
    • Interaction Center Technology
    • Communications/Utilities
    • Public Sector University
    • Financial Services
    • Healthcare
    • Aerospace, Defense and Transportation

    The zipped documentation file is about 475MB and I understand it explodes to more than 1 CD now. There’s lots of new products and functionality - happy downloading and reading.

    Page 3 of 6 pages  < 1 2 3 4 5 >  Last ›