170 likes | 446 Views
Oracle e-Business Suite V11.5.10. Presentation by Edgen for the Baton Rouge Oracle Users Group . Who/What is Edgen?. Formed in 1996 through purchase of Thomas Pipe and Steel – $45MM sales; one location; 30 employees
E N D
Oracle e-Business SuiteV11.5.10 Presentation by Edgen for the Baton Rouge Oracle Users Group
Who/What is Edgen? • Formed in 1996 through purchase of Thomas Pipe and Steel – $45MM sales; one location; 30 employees • Acquisitions in 1997 (Arrow), 1998 (Bartow), 1999 (Radnor), 2000 (Resource), 2001 (ProMetals), 2002 (SISCO), 2005 (Western Flow) • $280MM+ sales; 15 locations; 235 employees • Number 7 in Top 100 privately held companies in Baton Rouge (2005 revenue)
Who/What is Edgen? • Formed in 1996 through purchase of Thomas Pipe and Steel – $45MM sales; one location; 30 employees • Acquisitions in 1997 (Arrow), 1998 (Bartow), 1999 (Radnor), 2000 (Resource), 2001 (ProMetals), 2002 (SISCO), 2005 (Western Flow) • $280MM+ sales; 15 locations; 235 employees • Number 7 in Top 100 privately held companies in Baton Rouge (2005 revenue) • MIM acquisition/merger in 2005 - $700MM+ sales; 20 locations; 375 employees
Support for Global FunctionalityOperate in One World with One Solution So: Why Oracle Apps? • No Language Boundaries • Support for 30 languages • Multi-lingual external documents • All languages installable in same Unicode instance • No Currency Boundaries • No Legislative Boundaries • Customers operating in 100+ countries • Support for statutory & customary local requirements
Oracle Delivers EfficiencyAccelerate the Close Process Rapidly Consolidate Financial Information Across Different Entities and for Multiple Currencies, Charts of Accounts, Periods Streamline Inter-Company Accounting and Reconciliation AcceleratedCloseProcess Automate Labor Intensive Processes Achieve Performance Scalability
Ledger Drilldown and IntegrationEnhance the Reconciliation and Analysis Process • Drill down from General Ledgerto sub-ledgers • Display accounting impact of transactions in General Ledgerand in sub-ledgers • T-account format • Trial balance format GeneralLedger Sub-Ledgers Payables Assets Receivables Work inProcess Projects Purchasing Inventory
Oracle Financial Management VISIBILITY Deliver Better Business Information CONTROL Attain Sustainable Compliance EFFICIENCY Improve Business Processes at the Lowest Cost
Oracle Apps History • Spring 2001 – Negotiation and purchase of software • Late fall 2001 – Begin implementation process with vendor • Summer 2002 – Kick vendor out • Fall 2002 – Restart implementation process with Oracle Consulting Svcs. • Jan. 2003 – Live with first Edgen Division • Dec. 2003 – Final Division converted
E-Business Suite – what’s in it? • Financials (AP,AR,GL, FA) • Order Management • Inventory Management • Purchasing • Human Resources • Business Intelligence, Marketing, Manufacturing, Projects, Service (contracts) • Workflow
Activity at Edgen (all numbers are 2005 monthly averages) • 3300 Sales Orders • 3600 Invoices • 900 Purchase Orders • 3475 Shipments • 3100 A/P Checks
Oracle Technology Stack 2-tier Architecture • Apps and database both run on RS6000 (db – AIX v5.3; apps – AIX v5.2) • Apps server – IBM630; 4-way; 1.45GHz Power 4+ processors; 8GB RAM • DB server – IBM570; 4-way; 1.9GHz Power 5+ processors; 16GB RAM • Storage – IBM FAStT700; approx. 400Gb (three environments - PROD & 2 test)
Oracle Technology Stack • Enterprise Edition Database – V9.2.0.6.0 • Oracle Forms – V6.0 • Discoverer – V4.1.48 • FormScape – V3.3 • FileNet - VP8 3.5.2 • TOAD – V8.06 • STAT – V5.22 Oracle Enterprise Edition database (and other software used in support of the Oracle applications)
Oracle Technology Stack Oracle Enterprise Edition database • 134 schemas • 7,442 tables • 23,183 views • 405 tablespaces • 35,450 objects (triggers, packages, etc.) • 1378 Oracle “responsibilities”
Architecture Portal Servlet Engine JDBC (Thin) Java Server Pages (JSP) http AOLJ Web Listener Data Server Tier Discoverer TNS (Net8) PL/SQL Gateway Clients Reports Forms Concurrent Manager Application Tier
Edgen Support Staff: Chris, Shannon, and Miranda!!! Edgen staff is augmented as needed through relationships with third-party vendors such as DCC.