OFIT - Agency Day

1. OFIT - Agency Day May 22, 2014

2. ARC Service Lines • Financial Management • 37 customers - (12) Treasury, (25) non-Treasury • 12 consecutive years of clean SSAE16 (formerly SAS70) audits • 200+ clean financial statement audits in support of customer agencies • Successfully upgraded customers to Oracle R12 on schedule • with minimal down time • included new CGAC requirements • implemented new Oracle Projects and Costing module • Other ARC Service lines • Procurement - Human Resources • Travel - Information Technology

3. Financial Management System • Oracle E-Business Suite Platform • Oracle Federal Financials - Release 12 • Customer agency staff leverage a shared multi-tenant instance • Standard shared functions maintained such as: • CGAC compliant accounting code structure • SGL definitions • BOC (budget object class) definitions • Vendor lists • Optional agency specific functions such as: • Open/closing past periods • Data validation edits • Accounting structure segments such as internal org, project code, etc. (Six elements are available for customer use)

4. Financial Management Services • Platform Service • Customer agency staff process transactions and perform required reporting • ARC staff perform system administration for core financial system and ARC-hosted feeder systems used in support of the customer agency • ARC staff provide agency user training and help desk support • Full Service • Customer agency staff initiate transactions, monitor/review data and review/approve reports • ARC staff process transactions and perform required reporting • ARC staff perform system administration for core financial system and ARC-hosted feeder systems used in support of the customer agency • ARC staff provide agency user training and help desk support

5. Financial Management Services • In addition to the two basic service levels (platform and full service), customers have flexible bundling options from which to choose. • The following slides provide a matrix of ARC’s offerings in Financial Management Services, including the available options to tailor services to meet an agency’s needs. Services are designated accordingly: • Included = Part of ARC’s bundled Full Service • Included if needed = A service that is included in ARC’s bundled Full Service, if applicable to the customer • Available = Optional add-on services, not required • Recommended = Services we recommend to accompany the FM Full Service due to their integrated nature; these services are not required • Customer = Services that are not currently offered by ARC and therefore are performed by the Customer

6. Financial Management Services

7. Financial Management Services

8. Integrated Oracle Federal Financials Platform

9. Custom Built Oracle Extensions

10. E-Payroll to Oracle Reporting (EOR) • ARC’s custom built extension which processes payroll and personnel data from any of the four E-Payroll providers • Used to process payroll and personnel data files as well as • Payroll and annual leave accruals • Corrections of accounting strings • Redirection/split of accounting string supplied by E-Payroll provider • Weekly batch interface of the summary accounting impact of payroll transactions to Oracle • Weekly batch interface of detail payroll transaction and bi-weekly batch interface of personnel data that supports the summary accounting transactions in General Ledger to custom Oracle tables used for reporting

11. ARC Predict • ARC’s custom built extension to provide payroll projections capability • Used by customer agency and ARC staff to combine payroll actuals data from EOR along with various user provided projection parameters (e.g., promotions, terminations, new hires and lump-sum payments) to produce projection reports • User-initiated projections are prepared on demand

12. ARC IPAC • ARC’s custom built extension used to streamline the processing of IPAC collections from federal trading partners • Used to generate bulk IPAC files, process IPAC accepted and rejected transactions and record cash receipts in Oracle • On-demand, user-initiated interface to generate bulk IPAC files • A portion of the data elements needed to generate an IPAC bulk file are supplied by Projects Costing and Billing • A portion of the data elements needed to generate an IPAC are supplied by Accounts Receivable

13. Integrated Third Party Systems

14. PRISM • Commercial off-the-shelf federalized procurement system hosted with Oracle E-Business Suite in commercial cloud • Electronic creation, routing and modification of requisitions, purchase orders, contracts, and other award related documents • Contract writing module • Integration with Federal Procurement Data System-Next Generation (FPDS-NG) • Used by agency requisitioners, approvers and contracting officers • Real-time integration between financial purchasing module and purchasing system (Oracle/PRISM) • Funds checking • Vendors • Accounting code values • Requisitions and awards

15. WebTA • Commercial off-the-shelf federalized time and attendance system hosted internally at ARC • Electronic creation, routing and approval of leave and premium pay requests • Used by timekeepers, employees and supervisors to enter time and attendance data • Batch interface provides data to USDA’s National Finance Center (NFC) • Interface is scheduled to run per customer requirements or on demand

16. Concur • Government-wide, web-based E-Gov Travel Service (ETS) system • Electronic creation, routing and approval of travel authorizations and travel vouchers • Used by agency travelers, document preparers and approving officials • Provides reservation and cost estimating capabilities • Daily batch interface of travel authorizations to Oracle • Daily batch interface of travel vouchers and vendor invoices to Oracle

17. moveLINQ • Commercial off-the-shelf relocation system hosted internally at ARC • Used by ARC staff only to plan, document and process employee relocations • Daily batch interface of relocation authorizations to Oracle • Daily batch interface of travel vouchers and vendor invoices to Oracle

18. InvestOne • Treasury’s commercial off-the-shelf mainframe back-end investment accounting system • Used via web-based front end application (FedInvest) by federal agencies that have investment authority in Government Account Series Securities to execute investment transactions and manage federal investment portfolios • Daily batch interface of the summary accounting impact of investment transactions to Oracle • Daily batch interface of detail investment transaction data that supports the summary accounting transactions in General Ledger to custom Oracle tables used for reporting

19. System for Award Management (SAM) • General Service Administration’s government-wide, web-based acquisition and award support system • Used by contractors, federal assistance recipients, and other potential award recipients who need to register to do business with the government, look for opportunities or assistance programs • Used by government contracting and grants officials responsible for activities with contracts, grants, past performance reporting and suspension and debarment activities • Provides an automated comparison between Oracle and SAM • Daily and monthly batch interface of suppliers to Oracle

20. HHS Grants Payment Management System (PMS) • Health & Human Services’ custom-developed system used to manage grant payment requests and disbursement reporting activities • Daily batch interface to upload grant obligations and amendments to PMS • Daily batch interface of invoices to Oracle to reflect disbursements processed by HHS

21. Invoice Processing Platform (IPP) • Treasury’s web-based system to manage government invoicing from purchase order through payment notification • Electronic creation, routing and approval of accounts payable invoices • Used by vendors, agency invoice approvers and ARC staff • Daily batch interface of purchase orders to IPP • Daily batch interface of approved invoices from IPP to Oracle • Daily batch interface of invoice status (scheduled payment date and invoice cancellations) from Oracle to IPP • Daily batch interface of supplier updates from Oracle to IPP

22. Citidirect • Citibank's web-based government purchase card system • Used by purchase cardholders to review, reconcile and assign accounting to the purchases on their electronic statements • Used by approving officials to approve electronic statements submitted by cardholders • Daily batch interface of invoices to Oracle upon statement approval or autoclose

23. Secure Payment System (SPS) and Payment Automation Manager (PAM) • Treasury systems used by federal agencies to submit payment schedules for disbursement by Regional Finance Centers • Daily batch interface to upload payment schedules to SPS and PAM • Do Not Pay • Treasury systems used by federal agencies for verification of payments • Weekly batch interface using DNP’s continuous monitoring functionality to compare Oracle suppliers to various lists of prohibited vendors

24. IPAC • Treasury system used for as a standardized interagency fund transfer mechanism for Federal Program Agencies (FPAs). • IPAC facilitates the intragovernmental transfer of funds, with descriptive data from one FPA to another. • On-demand, user-initiated interface to generate bulk IPAC files

25. Discoverer Reporting

26. Oracle Discoverer • Allows for real-time standard or ad-hoc queries to be built against most data elements in any application hosted by Oracle on Demand • Oracle Federal Financials suite of modules • PRISM • InvestOne detail investment transaction data • EOR detail payroll transaction and personnel data

27. Oracle Discoverer - two versions offered to users • Discoverer Viewer • Most commonly used version • For users who need to view pre-established reports and make changes to the report layout, data format and sorts • Provides drill down, drill up and drill to related field capabilities • Allows for export in multiple file formats including spreadsheet • Discoverer Plus • Expert version • For users who have a solid understanding of Oracle databases and data structures and who need to create reports or make changes other than to the report layout, data format and sorts permitted by Discoverer Viewer • Provides all the same functionality offered by Discoverer Viewer

28. Hosting Model

29. Hosting Model • Cloud-based hosting at Oracle Federal Managed Cloud Services (previously known as Oracle on Demand) • Contract flexibility to ensure scalability, storage, capacity and performance needs can be met with rapid turnaround • FedRamp certified • Multiple active power and cooling distribution paths, redundant components, fault-tolerant computing devices , and 99.995% availability • 24x7 automated and human monitoring of the data center and infrastructure • Hot disaster recovery site

30. Roadmap

31. Roadmap • Improve data integration capabilities, e.g. implement web services • Establish documented and repeatable customer agency discovery and on-boarding processes that leverage contractor support • Expand use of contractor support for staff augmentation • Expand use of contractor support for customer on-boarding • Business functionality improvements: • Implement new functionality in the areas of grants management, property management and business analytics • Provide additional system integration between core financial management system and common government-wide functions such as Centralized Receivable Service, International Treasury Service and Intragovernmental Solution • Implement end-to-end automation of common functions such as accruals, accounting corrections and intragovernmental transactions • Improve financial statement preparation process • Evaluate additional reporting tools