Overview of Citi's Oracle E-Business Suite Strategy Session ID: CON3458

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