Overview of Citi's Oracle E-Business Suite Implementation with a Global Single Instance Strategy Session ID: CON3458 Shirish Ghade, Tarun Gulati September 28 – October 2, 2014 Citi | Chief Technology Office (CTO) | Global Functions Technology Services (GFTS) Information Classification: Public Citi Overview Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services and wealth management. 2 Citi | CTO | GFTS Information Classification: Public Overview of Citi’s Implementation of the Oracle E-Business Suite (EBS) • Citi’s Oracle EBS system enables employees, using a web browser, to request goods and services, obtain approvals electronically, and pay for the goods and services purchased. • This global initiative uses financial applications encompassing Accounts Payable, Fixed Assets, Expense General Ledger, and Procurement to leverage the power of a single integrated database with common data processes and standards. • Citi’s Oracle EBS system meets funding and prepaid accounts requirements, handles Citigroup legal entity and asset location codes, and maintains a structured approval process that meets Citigroup standards. • The Internet Procurement application is integrated with Oracle's Global Exchange (an electronic market place), which hosts supplier catalogs; and the Accounts Payable application supports electronic submission of supplier invoices, as well as electronic payments via existing Citigroup payments services. • Citi’s Oracle EBS system also includes an innovative web-based, decentralized invoice entry feature, e-Invoice, that can be used where appropriate. • Vision: Consolidate multiple legacy systems to one solution by implementing Citi’s Oracle EBS system in all Countries that Citi has businesses in and capture near 100% of expenses. 3 Citi | CTO | GFTS Information Classification: Public E-Business Suite Modules & Module Architecture E-Business Modules • • • • • Internet Procurement Purchasing Accounts Payable Fixed Assets Expense General Ledger Project Accounting • Accounts Receivable Note: Self-Service Banking is an application that allows employees to enter their bank information for expense reimbursements. e-Invoice is a self-service web based tool for entering invoices. CTE (Citi Travel and Expense) is a self-service web based tool for entering travel and entertainment expenses. BAW is a business activity data warehouse used for reporting and analytics. 4 Citi | CTO | GFTS Information Classification: Public Software Technology Components Platforms: • • UNIX (RED HAT Red Hat Linux Advanced Server v5) – E-Business Suite Application and Database Servers WINTEL Operating Systems (MS Windows Server 2003/2008) – Imaging/Fax Application Servers Languages: • HTML, JavaScript, Java, JSP, SQL, PL/SQL, C-shell, Korn shell, Oracle Forms & Reports RDBMS: • • Oracle v11G Rel 2 with 3 node Oracle RAC – E-Business Suite Microsoft SQL Server SQL Server 2008 use with RightFax Software (PO Faxing) Supporting Software: • • • • • • • • • • • • 5 Oracle e-Business Rel 12.0.6 IBM STERLING COMMERCE Connect:Direct (aka NDM) v4.0 o HP Project and Portfolio Management (PPM) Deployment Management module version 9.14 o VERTEX Sales Tax Q Series v4 CA FKA COMPUTER ASSOCIATES Siteminder (Corporate SSO) 6.0 Oracle Discoverer v10.1.2.55.26 OPEN TEXT RightFax 9.4 CA FKA COMPUTER ASSOCIATES Autosys Job Management R11.3 SERENA SOFTWARE / MERANT PVCS Version Manager APACHE SOFTWARE FOUNDATION Apache HTTP Server v1.3 Oracle Preventive Controls Governor Oracle Preventive Controls Governor v 7.3 Oracle BI Publisher and Oracle Developer Suite 10g Oracle WebCenter Imaging v11 and Kofax for Payables - Markview System v7.01 o Oracle Portal v10.1.4.2 Oracle Dataguard v11g Citi | CTO | GFTS Information Classification: Public Country Coverage Citi’s Oracle EBS system is live in 55 countries. User Metrics • All Citi employees/temps are auto provisioned (260K) • Approximately 100K Active Users • 4,000 Average Peak Concurrent Users 6 Citi | CTO | GFTS Information Classification: Public Modules / Customizations Modules Citi’s Oracle EBS system implemented the following Oracle E-Business Suite modules: • Accounts Payables • General Ledger • Purchasing and Internet Procurement • Fixed Assets • Accounts Receivables Apart from the above, Citi’s Oracle EBS system also has custom/third party applications modules that have been tightly integrated: • e-Invoice o Custom application developed by Citi for the end users to submit invoices. o Allows users to enter invoices o Follows the approval process o Imports the invoices to core AP • 7 Self Service Banking o Custom self-service application developed by Citi o Provides flexibility to the employees to enter/update their banking details o Optimizes the process, wherein employees do not have to send the banking details to VMU’s Citi | CTO | GFTS Information Classification: Public Localizations Oracle localizations have been installed to cater to the country’s legal and regulatory requirements. 8 Citi | CTO | GFTS Information Classification: Public Purchasing (IP/PO) Approval Create Purchase Requisitions APPROVAL HIEARCHY CREATE PURCHASE ORDERS APPROVAL HIEARCHY RECEIVING INVOICING Approval CATALOG NON-CATALOG HR SHELL EDI PO SENT TO SUPPLIER PO TRANSMISSION XML FAX SUPPLIER EMAIL 9 Citi | CTO | GFTS Information Classification: Public Supplier Details & PO Metrics • Automated process to inactivate the suppliers for no invoicing or payment activity after certain number of months. • Processing of suppliers through Vendor Maintenance Units (VMU) located in 5 countries. • OFAC listing is used for determining prohibited vendors. Purchase Orders FY 2012 PO Volume Daily Average PO Volume PO Transmission Method XML FAX EMAIL EDI Citi | CTO | GFTS 800K 3K % 29 16 50 5 Information Classification: Public Accounts Payables (AP) SUPPLIER / BUSINESS INVOICE TRANSMISSION SELF SERVICE BANKING (EMPLOYEES) FLATFILE EDI CONVERSIONS Vendor Setup · · · XML Supplier / Employee Bank & Bank Branch Bank Account NON-PO MATCHED INVOICES ASSET INVOICES INVOICE MAKER CHECKER INVOICE CREATION GL INVOICE VALIDATION Cit Travel and Expense System PAYABLES TRANSFER TO GL INVOICE APPROVAL INVOICE ENTRIES EINVOICE ACCOUNTING PAYMENTS PAYROLL SYSTEM PAYMENTS ENTRIES PAYMENT PROVIDERS (EMPLOYEE PAYMENTS) CPS 11 Citi | CTO | GFTS CMPS TAX REPORTING MANUAL INVOICE ENTRY FA PAYABLES JOURNALS PO MATCHED INVOICES MANUALLY TAX SYSTEM FC IMPS CEEMEA GTS Information Classification: Public Fixed Assets (FA) AP CONVERSIONS EXTERNAL UPLOAD MANUAL ENTRY ASSET INVOICES ASSETS TRANSFERS / RECLASSIFICATION ASSETS DEPRICIATION ASSETS ADDITIONS Account Generator ASSETS RETIREMENT CREATE JOURNAL ENTRIES GL 12 Citi | CTO | GFTS Information Classification: Public General Ledger (GL) AP FA MANUAL JOURNAL ENTRY External Upload 13 Citi | CTO | GFTS FUNDING ENTRIES WEB ADI JOURNAL ENTRIES POSTING CREATE JOURNAL ENTRIES LEGACY SYSTEMS Information Classification: Public Job Scheduling and Interfaces End of Day and Month End • Autosys is the tool that Citi’s Oracle EBS system uses for scheduling concurrent program jobs. • These jobs are monitored by a Citi job scheduling/monitoring team 24*7 to cater to round the clock operational global processing. This team also assists with manual starts and restarts as necessary. • There is a high complexity of dependency defined between these jobs in order to cater to the cut off times for the payments, GL interfaces, interface partners and also the operational processing times. • For failure of each job, issue triage and escalation mechanism have been defined. • Daily regional email notifications are sent regarding job status, failures and cut-off to integration system partner status. Citi | CTO | GFTS Information Classification: Public Operational Process, Regional Service Centers, Help Desk Operational Processing has the below high level functions : • AP shop • FA activities • Recon and GL maintenance • Procurement Regional Service Centers (RSC) are used for processing. Regional Help Desk Support teams are used to assist users. Production Support • Citi’s Oracle EBS system uses Managed Services. Citi | CTO | GFTS Information Classification: Public Patch Strategy • Patches are applied semi-annually. • Oracle Patch Wizard tool is utilized to obtain the recommended list of patches. • Latest QSP’s are bundled with the semi-annual patching process. • Regression testing is performed for the semi-annual patching process. • High Volume and Countries with complex processes are involved in the patch testing process. Citi | CTO | GFTS Information Classification: Public Current Issues • Database size continues to grow, thus there is a need for an archive and purge strategy, as well as a tool • Accounting issues • Trial balance issues • Slow progress on Oracle resolving identified application vulnerability testing issues • Semi-Annual Patching – extensive time and effort required Citi | CTO | GFTS Information Classification: Public Future Plans 2015 2016 • Upgrade to E-Business Suite 12.1.3 • Upgrade to E-Business Suite 12.2 • Upgrade to Oracle WebCenter Portal v11 • Implement replacement product for Oracle Discoverer • Implement Oracle Endeca • Implement Oracle Application Testing Suite (OATS) Citi | CTO | GFTS Information Classification: Public Thank You Shirish Ghade GFTS Project Manager & Application Manager [email protected] Tarun Gulati GFTS Development Manager [email protected] © 2014 Citigroup Inc. CITI and Arc Design is a registered service mark of Citigroup Inc. 19 Citi | CTO | GFTS Information Classification: Public
© Copyright 2024