OracleAppsBlog
A day in the life of an Oracle Applications Consultant

Documentation

Wednesday, February 15, 2006

Connecticut State Governments integrated Financial, HR and Payroll System

I came across the Core CT site today and found it to be a site with a wealth of information relating to systems implementation.

According to the site:

Core-CT is the system that has replaced Connecticut state government’s core financial and administrative computer systems including central and agency accounting, accounts payable, payroll, time and attendance, worker’s compensation, personnel, and other legacy systems. For years before Core-CT was implemented, these systems were plagued by poor integration, redundant data entry, and time-wasting reconciliation. They were written in a number of different languages, resided on many platforms, and included numerous databases. This older technology was not adaptable to workflow and e-commerce.

The state’s central administrative agencies - the Office of the State Comptroller, the Departments of Administrative Services and Information Technology, and the Office of Policy and Management - banded together to undertake the transition to a new, integrated system encompassing virtually all major administrative functions and all executive-branch state agencies. The system uses enterprise resource planning (ERP) software to tie together all functions, using an integrated suite of software applications, a common database, and a unified technical architecture.

The Core-CT fact sheet outlines what modules and systems were implemented as follows:

Core-CT is Connecticut state government’s central financial and administrative computer system. Using PeopleSoft’s ERP suite, the system encompasses central and agency accounting functions, including modules for general ledger, purchasing, accounts payable, accounts receivable, billing, assets, and inventory, with projects and contracts scheduled to be implemented in 2006; as well as PeopleSoft’s Human Resource Management System, with modules for payroll, time and labor, human resources, and benefits. Core-CT covers all these functions for executive branch agencies, and some of its functions are also used by the Judicial Branch, the General Assembly, and state institutions of higher education. In addition, Core-CT uses PeopleSoft’s EPM ad-hoc reporting function to allow queries on its vast database.

Currently, the system uses PeopleSoft Financials version 8.4 but will be upgrading to version 8.8 around July 2006; HRMS uses PeopleSoft version 8.3 and will be upgrading to 8.9 around May 2006. Some 7,600 state workers use Core-CT. They pay the state’s bills in a $15.3 billion annual budget (fiscal year 2006), including the payroll for all state employees.

Launched in 2003, Core-CT is based at the Department of Information Technology’s East Hartford, CT office; it is managed jointly by the Office of the State Comptroller, the Department of Administrative Services, and DOIT; these agencies hold the statutory authority for the system’s functions.  Approximately 150 people work in the development and maintenance of Core-CT.

Other interesting areas of the site include the Presentation Library, Document Library and Chart of Accounts Documentation. I also thought the catalog of online financial reports provides a good example of how reports should be documented.

Thursday, February 09, 2006

Oracle 11i Test Scripts

I recently uploaded some test scripts for the following modules to the Oracle Apps Forum:

If anyone else has some test scripts they would like to share then please feel free to upload them to the documentation section of the forum.

Friday, February 03, 2006

Oracle Navigation and ADI Tip Sheets

Last year I worked with Nici Aldridge on an IMSCAN document management and scanning solution for an Oracle E-Business Suite implementation. Nici is an Oracle Applications Consultant who does quite a substantial amount of Oracle Training - read her profile here. She shared with me some “tip sheets” she has produced for Oracle Applications Navigation and Oracle’s Application Desktop Integrator (ADI). These tips sheets are very short documents which are aimed at providing users with the basic information they need to get started with.

Other tip sheets are available for:

  • Office 2000 - Generic Information for Office 2000
  • Word 2000 - For those converting to Word 2000
  • Outlook 2000 - For those converting to Outlook 2000
  • PowerPoint 2000 - For those converting to PowerPoint 2000
  • PowerPoint for Presenters - Suggestions for using PowerPoint effectively in PC-based presentations
  • Visual Aids - Suggestions for choosing and using visual aids, including PC slides

Sunday, August 14, 2005

A Better Learning Environment (ABLE) at Harvard University

This post discusses the Harvard University systems support site and the use of Oracle 11i and Peoplesoft at this institution.

A Better Learning Environment (ABLE) is a support site for users of Harvard Universities systems. More specifically, the site provides support for Financial Applications (Oracle), HR Applications (Peoplesoft), Reporting Applications (Financial and HR) and for Harvard’s Central Administration Staff.

The resources available at the site include: -

  • Forms
  • Policies
  • Rates & Schedules
  • Work Instructions & Processes

Of particular interest is the section on Chart of Accounts (CoA) which outlines the account structure they implemented at Harvard.

For Financial Applications Harvard runs Oracle eBS and you can read about their upgrade to 11i from 11.0.3 in January 2003 here. According to the newsletter the upgrade introduced a new look and feel, new login techniques, and a new method of navigation for Web Voucher, General Ledger, Accounts Payable, Accounts Receivable, Budget Tool, AWS2, HUDINI, and Applications Administration.

In November 2004 the University upgraded from 11.5.5 to 11.5.9 which you can read about here.

The Universities Administrative Systems e-news is an interesting insight into how ERP systems are run and maintained. According to the site:

The Office of Human Resources publishes a semimonthly electronic newsletter for users of University financial, HR, and reporting systems, policies, and procedures. It contains:

  • Updates on projects underway to build or improve University administrative systems
  • Information about new University financial, HR, and reporting policies, procedures, and forms
  • Reminders about upcoming deadlines and cutover dates
  • Tips and tricks for working more easily or productively

On the e-news site you will also find back issues of the publication as well as a useful index by topic.

Tuesday, August 09, 2005

Some interesting IT, ERP and Oracle Job Sites

Over the last two weeks I’ve come across a variety of interesting job sites which I wanted to specifically highlight to readers. It seems that more job sites are getting in to the blogging thing as well as providing RSS support. The concept of job sites having RSS support appeals to me since it means that I can find out about the latest jobs without have to wade through tonnes of e-mail subscriptions.

Firstly, I wanted to point out that Jobserve now has RSS support for job searches. Monster, another really large job site now has a blog as well as an RSS feed available on their Career advice site. Jobster also has a blog here.

IT Jobs Watch is another interesting site I came across that gives you a good indication of earnings in the UK IT Sector. According to the site:

ITJobsWatch offers you a unique perspective on today’s UK IT jobs market. Our aim is to present you with a concise and accurate map of the prevailing IT jobs market conditions. Our goals include helping you:

  • Determine the level of demand for particular IT skills with a guide to the average salary and contractor rates offered.
  • Discover how various IT skills interrelate.
  • Determine which IT skills are popular in specific locations.
  • Determine the level of demand for a certain IT skills required by specific IT Job Titles.

ERPMate.com is a job site which has a forum mainly consisting of SAP job vacancies and advertisements. GeekInterview.com is an open database where you can share interview questions. They have 102 questions for Oracle Apps. Also of note is the site Exforsys.com which has a number of tutorials for Oracle Applications 11i. To mention a few:

From an Oracle perspective you should check out the official Oracle Jobs site as well as this OracleJobSite which has an array of RSS feeds you can subscribe to.

Once again, I wanted to point out that I’m frequently updating my del.icio.us job site listing with new sites I come across such as the ones mentioned above, hence I recommend you subscribe to the OracleAppsBlog jobs RSS feed. You’ll also find a listing of Job sites in the Jobs folder of the OracleAppsBlog Blogroll. If you want to see a job site with an interesting and sometime humorous twist, check out Simply Fired.

Anyone know of any other job sites that have RSS feeds?

Page 2 of 7 pages  < 1 2 3 4 >  Last ›