Social Security Administration Online Accounting and Reporting System

1
Social Security Administration Online Accounting
and Reporting System

• SSOARS

2
Oracle at SSA

• Implemented EBS in 2003
• Post EBS Implementations
• Upgrades to EBS currently running 11.5.10.2
• RAC
• Multiple Interfaces and Real-Time Integrations
  with Feeder Systems
• 170 Markview System for Invoice Imaging/Control
• Oracle Portal Technology
• Reporting System - integrated Crystal Reports
• Accounting Correction Capability
• Budget Allocations

3
Release 12 Upgrade

• Three-Phase Approach
• Analysis
• Conference Room Pilot (CRP)
• Implementation

4
Release 12 Upgrade

• Interested Release 12 Features and Benefits
• Sub Ledger Accounting (SLA)
• Increased Labor Efficiencies
• Simplified Configurations/Setups
• Improved Data Integrity between GL/Subledgers
• Trading Community Architecture
• Payment Manager
• Minimizing Extensions
• Better Performance

5
Release 12 Upgrade

• Issues/Challenges
• Transition to SLA and Payment Manager
• Response time from Oracle Support and Oracle
  Development
• Lack of Release 12 experienced resources
• FSIO Certification
• Required Downtime for Installation/Upgrading
• BPR/End user Training

6
Oracle On-Demand

• Agency objectives
• Obtain better service
• Lower costs
• Meet FMLoB Requirements

7
Oracle On-Demand

• At Customer model
• Support EBSO Prod and two pre-prod instances
• Support OTO Prod and Pre-Prod
• Advantages
• 2 DBAs vs. 15 DBAs
• OC and OoD working together
• Expertise
• Production Assessment

8
Oracle On-Demand

• Challenges
• US Based employees
• VPN Remote connectivity
• Change Management

9
SOA Implementation

• SOA Suite is used for real-time, highly available
  integration between Carson Wagonlit Travel and
  SSOARS
• Web services are designed and implemented for
  communication between EBS and the Travel system
• BPEL used for applying business rules
• Additional security being handled by Datapower
  security gateway before being handled by SOA Suite

10
Other Projects

• CBSV integration with SOA
• P-Card Integration with SOA
• eBusiness Intelligence with OBIEE