Oracle R12 at Leicestershire, 1 Year On ''

1
Oracle R12 at Leicestershire, 1 Year On ..

• Ged Moss,
• Leicestershire County Council

2
Agenda
ltInsert Picture Heregt

• Introduction to Leicestershire
• CRM (Teleservice) SOA
• Financials iProcurement
• HR Payroll

3
Leicestershire
ltInsert Picture Heregt

• Population 650,000
• 7 District Authorities
• Leicester City (unitary) at the centre
• City population 200,000

• Sun Solaris platform
• 1 x DB server
• 3 x Apps server
• Circa 4000 users

4
Applications
ltInsert Picture Heregt
HCM R12 2009 iExpense
Fin R12 2009 iProc
Fin 11.5.10 2005 iProc

• Teleservice 12.0.4
• Financials 12.0.6
• HCM 12.0.7

Fin 11.5.10 1992 G/L, AR, AP
Teleservice R12 2007 SOA, Email
Fin R12 2009 G/L, AR, AP
5
CRM UpdateCustomer Relationship Management R12
(Dec 2007)
Fin

• Teleservice
• Customer helpdesk quick and intuitive service
  request data capture
• Priortised work queues

Teleservice
E-mail Centre

• Customer hub middleware
• Link between EBS and MapInfo Confirm using
  customer details as the key

Marketing
6
Key FactorsCustomer Relationship Management R12

• Why R12?
• Need to stay up to date
• Improvement to Email Centre
• Removed the need for future upgrade

7
IssuesCustomer Relationship Management R12

• Jan 2007 release
• Shortage of R12 resources
• Shortage of R12 training courses
• Skills gap for SOA/BPEL
• Separate instance

8
IssuesCustomer Relationship Management R12

• Still on 12.0.4 Changes in 12.0.5 have removed
  some Note fields used by our interfaces and
  delayed upgrade.

9
Whats Live Today
Whats Live TodayFinancials Procurement R12
(since Mar 2009)

• Accounts Receivable
• Expert debt administration

• Purchasing
• Expert buyers
• Self service procurement

Purchasing i-Procurement
Receivables
Payables

• General Ledger
• Recording and reporting of budgets and actuals
• iPayments
• eTax
• Sub-Ledger Accounting

• Accounts Payable
• Expert payment administration

10
Early IssuesFinancials Procurement R12

• Limited windows of opportunity
• Re-install or Upgrade?
• Time Required
• Tax configuration
• Bank branch data
• Supplier site data

11
Early IssuesFinancials Procurement R12

• Limited windows of opportunity
• Re-install or Upgrade?
• Time Required
• Tax configuration
• Bank branch data
• Supplier site data

Bank
R11
Branch
Branch
upgrade
Bank
Bank
R12
Branch
Branch
12
Early IssuesFinancials Procurement R12

• Limited windows of opportunity
• Re-install or Upgrade?
• Time Required
• Tax configuration
• Bank branch data
• Supplier site data

Header
R11
Site Address
Site Address
upgrade
Header
R12
Address
Address
Site
Site
13
Early IssuesFinancials Procurement R12

• Upgrade documentation not complete
• Accounts Receivables open interface
• Accounts Payables
• G/L download
• Purchase functions using fax or email

14
Upgrade PreparationFinancials Procurement R12

• Dress rehearsal
• Advanced Customer Support
• Daily Service Request Calls
• Critical Account Status
• Assess whether internal resources can support
  24x7 support

15
Upgrade ProcessFinancials Procurement R12

• Limited windows of opportunity
• Complete upgrade takes gt 60 hours
  (Fri/Sat/Sun/Mon) of 24x7 working
• Main upgrade patch takes 9 hours
• Deadlock/restart encountered twice
• RUP 6.0 takes another 6 hours
• Note 567515.1 since been issued.

16
Post Implementation IssuesFinancials
Procurement R12

• Java 1.6.7 delayed screen refreshing
• FSG problems relating to dependant segments
  (7545993.992)
• Collections problem with batches of gt 1,000
  transactions
• Several cheque printing problems in payments

17
Post Implementation IssuesFinancials
Procurement R12

• Skip function for spoilt cheques had a variety of
  issues
• Payments module generally!
• Variety of other issues for which no other
  solution is available except upgrade to next RUP
  (with accompanying risk and time required to
  regression test).

18
SupportFinancials Procurement R12

• Raise SRs early
• Update regularily
• Document business impact
• Use Hub 0870 4000900 number to maintain pressure
• Remain calm professional

19
SupportFinancials Procurement R12

• Making best use of priority levels
• P3
• P2 project threatening issues
• Escalated P2
• P1 production issues, requires on call cover

20
Whats Coming NextHR Payroll R12

• HR
• Approvals hierarchy
• Self Service

• Payroll
• Monthly payrolls
• Weekly payrolls
• Agency staff

HR
Payroll
Expenses

• i-Expenses expenses and imprest claims

21
IssuesHR Payroll R12

• Parallel running
• Getting a common hierarchy right
• Payables Expenses v Payroll?
• Rationalising pay elements
• Rationalising (weekly) payrolls

22
i-ExpensesHR Payroll R12

• What types of expenses (accomodation, mileage,
  etc
• Taxing at source?
• Do mileage rates fall within HMRC limits?
• Are expenses settled monthly or as and when?
  (cant be both)
• Known bug where GL is using dependant segments
  (7491718.993)

23
i-ExpensesHR Payroll R12
i-Expenses
Oracle/XMS interface
Expense detail
Payables
Payroll
It has to be one or the other!
VAT
NI
Remit advice
Pay slip
24
Whats Coming LaterFinancials Procurement R12

• Shared Services
• Probation service
• District payrolls
• EMSS with Nottinghamshire
• LFRS?

• Other modules
• Learning management
• Asset management
• Project costing

Finance
i-Procurement
HCM
25
Questions?
26
(No Transcript)