sun_p2p_xml_v6
TRANSCRIPT
Uncover the XML jewels in Oracle PO and AP and how it transforms Sun global procure to pay processes
[email protected] – IT Architect
Sun Microsystems Inc.
May 2009
Copyright © 2009 by Sun Microsystems Inc
AgendaAgenda• Introduction – Sun Microsystems, IBIS project
• XML Primer
• Oracle XML Integration
• Sun Procure to Pay Quick Tour
• Sun iProcurement Punchout
• Sun XML PO Outbound
• Sun XML Invoices Inbound
• Sun XML Bank Payment
• Oracle XML Gateway Setup
• Lessons Learnt
• Q&ACopyright © 2009 by Sun Microsystems Inc
Sun Microsystems Inc• Head Office in US• Innovator of technologies that powers the internet
which include Solaris, Java, UltraSparc, MySQL, Unified storage systems
• Selling IT hardware, software and services• Doing business in over 100 countries via local Sun’s
owned entities and partners channels• Fiscal 2008 revenue ~ USD13.8 billion • Business activities including sales,
services, manufacturing, partners management, logistics, corporate functions
www.sun.comCopyright © 2009 by Sun Microsystems Inc
As of August 2008, Sun has implemented General Ledger, Payables, Purchasing, iProcurement, iExpense, Projects, Service, Marketing, Service Contracts, Pricing, TCA etc. covering 58 legal entities with 140 GL books worldwide.
Sun’s Global 11i (IBIS**) Project
IBIS** stands for Integrated Business Information Solution
Sun took advantage of the versatile XML B2B messaging functionality within Oracle EBS and Sun Java CAPS, and implemented the following; 1) provide iProcurement punch out to supplier online store; 2) send electronic PO and receive electronic invoices via supplier networks; 3) create XML bank payment for suppliers. This paper provides an overview on how XML messaging technology greatly automates the company procure to pay processes.
Copyright © 2009 by Sun Microsystems Inc
<OrderRequest>
<OrderRequestHeader orderID="630000024" orderDate="2008-05-28">
<ItemDetail><UnitPrice>
<Money currency="USD">200</Money></UnitPrice><Description xml:lang="en">Canon Printer</Description><UnitOfMeasure>EACH</UnitOfMeasure><Classification domain="UNSPSC">UNSPSC</Classification><Extrinsic name="customersPartNo">Color Printer</Extrinsic>
</ItemDetail>
</OrderRequest>
XML Primer (eXtensible Markup Language)
Begin tagEnd tag
Extensible user defined tag
Copyright © 2009 by Sun Microsystems Inc
XML Standards and Common Usages• Examples of XML standards
• Use of XML document• Web Services, Messages• Formatted Document, Application Data
• Transfer of XML document• http(s), ftp• Email, Copy File
Copyright © 2009 by Sun Microsystems Inc
Oracle e-Business Suite - XML Integration
FinanceService
SalesManufacturing
Oracle XML Publisher
InvoiceReports
ContractsPOSOInvoiceReports
Oracle XML Gateway
Trading Partners
ContractsRemittances
OrdersInvoice
Oracle e-Business Suite
Transactions
Oracle Business Events
Internet
Copyright © 2009 by Sun Microsystems Inc
Sun Procure to Pay Quick Tour
iProcurement
Purchasing
Payables
iExpense
iSupplier
Banks
Internet
Credit Card Statements
Procurement Card Statements
Punchout
Supplier Networks
PO
SuppliersCopyright © 2009 by Sun Microsystems Inc
Sun iProcurement PunchoutSupplier Exchange
Internet
XMLfor
Authentication
XMLOrder
54
3
2
1
Supplier
Requisition
Catalog
Sun
6
Copyright © 2009 by Sun Microsystems Inc
Authentication
Highlights - Sun iProcurement Punchout
• Benefits• Zero maintenance on supplier catalog
• Rich shopping cart experience at supplier sites
• Challenges
• Complicated system configuration tasks
• Not many suppliers are capable of providing punchout integration
Copyright © 2009 by Sun Microsystems Inc
Sun XML PO Outbound
Oracle XML Gateway
OAGXMLPO
SupplierNetworks
Suppliers
cXMLFlat FilePO
Internet
Sun
Purchase Orders
EDIXMLPO
PO
cXMLEDIFlat filePO
Copyright © 2009 by Sun Microsystems Inc
PO
OAGcXMLPO
Highlights - Sun XML PO Outbound• Benefits
• Low implementation cost for Sun to integrate new suppliers
• Supplier network supports multiple PO document formats for suppliers
• Automated PO delivery to suppliers
• Challenges
• Sun had to implement different XML format with each supplier network
• Not many suppliers are connecting to supplier networks Copyright © 2009 by Sun Microsystems Inc
Oracle XML Gateway
SupplierNetworks
Suppliers
cXMLFlat FileInvoice
Internet
Sun
Invoices
EDIXMLInvoice
Invoice
cXMLEDIFlat fileInvoice
Sun XML Invoices Inbound
InvoiceOpen
Interface
PayablesOpen
InterfaceImport
Invoice
OAGcXMLInvoice
Copyright © 2009 by Sun Microsystems Inc
POAuto
Match
Highlights - Sun XML Invoices Inbound• Benefits
• Low implementation cost for Sun to integrate new suppliers
• Supplier network supports multiple Invoice document formats from suppliers
• Automated invoice import
• Challenges
• Sun had to implement different XML format with each supplier network
• Not many suppliers are connecting to supplier networks Copyright © 2009 by Sun Microsystems Inc
Sun XML Bank Payment
File
OAGXMLPayment File
Oracle XML Gateway
Internet
Sun JCAPS corporate messaging backbone
Bank of America
ISO20022XMLPayment File
Sun
Payments
Suppliers
Payments
Copyright © 2009 by Sun Microsystems Inc
Highlights - Sun XML Bank Payment
• Benefits• One electronic payment solution for 50+ countries
• Capable of handling ACH, EFT, checks, international wires
• Low maintenance costs
• Challenges
• Emerging standard for XML payment
• Complex mapping from Oracle OAG to ISO 20022 XML format
Copyright © 2009 by Sun Microsystems Inc
Oracle XML Gateway Trading Partner Setup
Payments
Invoice Inbound
Supplier or Bank Name
Purchase Order Outbound
Custom mapping from cXML to open interface table
Supplier Network
From view to OAG XMLCopyright © 2009 by Sun Microsystems Inc
Lesson Learnt
• Scalable global solutions
• Let suppliers and banks to integrate to our solutions
• Outside US, almost non existence of punchout and supplier network
• Too many XML standards
• New XML standards are buggy
• System security demands complex network configuration
• Testing, testing, testing
Copyright © 2009 by Sun Microsystems Inc