Prophet E-Business Suite Implementation Felecia Alston .

Uploaded on:
Page 1. About DeKalb County. Holds AAA bond FICO assessment. Populace more than 700,000 . 50 Departments5,400 Acres of Parkland
Slide 1

Prophet E-Business Suite Implementation Felecia Alston/Nancy Peterman January 19, 2007

Slide 2

About DeKalb County Employs 8,200 workers. Yearly spending plan of 1.7 billion Population more than 700,000 Holds AAA bond FICO assessment 50+ Departments 5,400 Acres of Parkland & Greenspace

Slide 3

Oracle Implementation In 2003, DeKalb County started relocating its Financial Systems and Procurement Systems to Oracle. Financials lived on DeKalb County Mainframe. Most of the Procurement capacities were decentralized and taken care of physically. - Oracle Corporation was locked in as essential seller. - Benefits of Oracle ERP application Eliminate centralized server forms Centralized applications/capacities Reduce the cost of upkeep and improvement Minimal Customizations -Production Go-Live May 2004 with discharge

Slide 4

Solution Footprint 2004 Oracle Applications Accounts Payable General Ledger Purchasing Inventory iExpense iProcurement Public Sector Budgeting Enterprise Asset Management Fixed Assets Projects & Grants Accounts Receivable Cash Management

Slide 5

Solution Footprint 2004 - Interfaces PEOPLESOFT Payroll C-PAK Water Billing INFOSPAN P-Card SYNERGEN Water & Sewer Plants ORACLE BAI – Bank Account Interface (Check In) FASTER Fleet UTI Utility Billing PEOPLESOFT Employees POSITIVE PAY (Check Out) STARS Worker\'s Comp

Slide 6

Solution Footprint 2004 - Reports

Slide 7

Upgrades 2005 Upgraded to 11.5.9.CU2 – June 2005 Upgraded Database to – July 2005 Upgraded to 11.5.10 CU2 – Dec 2005 Implemented Project Contracts - Sept 2005 2006 Implemented EAM for Roads and Drainage – Sept 2006 Upgraded AIX to 5.3 - Nov 2006

Slide 8

Upgrades 2006 Implemented Oracle CRM Applications for DeKalb 311 Citizen Help Center – May 2006. DeKalb County will be first Metropolitan province to actualize 311 to handle residents non-crisis calls. DeKalb County opened 311 Call Center in May 2006. Presently Employs 21 Customer Service Representatives. Eight Departments at present utilizing Oracle CRM to track and react to calls from natives. Built up an extra 20+ Custom Reports. Executed GL/Purchasing Encumbrance Tool. Actualized Invoice Import prepare that permit programmed 3-way coordinating 2007 Daily Business Intelligence March 2007.

Slide 9

Customizations Purchasing - Developed Custom Item Search

Slide 10

Customizations Purchasing - Developed Custom Purchasing Blanket Loading Process

Slide 11

Customizations Finance - Encumbrance Tool – Allows for simple compromise

Slide 12

Customizations Finance - Tax Commissioner – Custom Application for Homestead Exceptions and Billing (May 2007)

Slide 13

Key Success Factors/Lessons Learned Executive Sponsorship Documentation Meet Bi-Weekly with County Executive Assistant to CEO Document and test all procedures and systems (Month End/Year End Closures) Maintain Relationships with Department Heads Document application changes (Oracle AIM Methodology) Information Director is exceptionally proficient and steady of Oracle Team Testing Upgrade to new discharges Testing all basic usefulness amid overhauls (Accept truth that things will be broken) Only 4 remarkable TARs with Oracle in 2006

Slide 14

Key Success Factors/Lessons Learned Planning Ask the Experts Plan the quantity of occasions required for generation bolster/improvement ahead of time Engage Consultants if necessary Use Metalink/Oracle Support Networking Get included in Special Interest Groups Attend OAUG and Oracle occasions Join All Associated SIGS User Groups

Slide 15

Challenges/TARS Encumbrance Accounting Oracle has recognized issues with Encumbrance Accounting Paper Invoices Accounting Services is overpowered with number of paper solicitations got. Our present activity is to get electronic solicitations rather than paper solicitations. Office Depot - December 2006 Grainger – First Quarter 2007 End-User Training No coach on staff to prepare new area workers

Slide 16

Questions Q & A

View more...