1 / 31

Oracle E-Business Suite Integrated Custom Applications using Oracle Applications Framework

Oracle E-Business Suite Integrated Custom Applications using Oracle Applications Framework. Parag Mone, Senior Consultant USJade Corp. Vijay Rao, Business Systems Analyst Telegent Systems, Inc. NorCal OAUG Training Day - January 21, 2009. Program Agenda. Introductions

gunnar
Download Presentation

Oracle E-Business Suite Integrated Custom Applications using Oracle Applications Framework

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle E-Business Suite Integrated Custom Applications using Oracle Applications Framework Parag Mone, Senior Consultant USJade Corp. Vijay Rao, Business Systems Analyst Telegent Systems, Inc. NorCal OAUG Training Day - January 21, 2009

  2. Program Agenda • Introductions • Telegent Systems – Challenges • USJade Solution • OA Framework • Overview • Architecture • Application Screen Captures • OA Framework Benefits • Q & A

  3. Presenters Vijay Rao Business Systems Analyst Telegent Systems USA, Inc., Sunnyvale • Over 8 yrs of experience in the IT industry focusing on analysis, design, development, Consulting and Delivery of Java, J2EE and Oracle applications  • Fabless Semiconductor Operations, WIP Integration • Key player and Project Manager at Telegent to implement a B2B solution for Lot Processing Parag Mone Senior Consultant USJade Corp, San Jose • Over 5 yrs of experience in the IT industry focusing on analysis, design, development, Consulting and Delivery of CRM Applications.

  4. USJade provides mission critical business solutions, delivering cost effective, revenue-impacting results Enterprise System Integration & Consulting firm Founded in year 2000 by former BIG4 consultants and industry experts Corporate Headquarters: San Jose, CA Offshore “Center of Excellence” in Pune, India “Right Shore” Delivery Model Experience with Global Implementations Over 160 Consultants Worldwide Certified Oracle Partner Oracle Business Accelerator: Exclusive Solution Provider for Fabless Semiconductor USJade Introduction

  5. Domain knowledge and Industry specialization Successful track-record of customer satisfaction Client-focused approach From initial strategy to deployment that best meet our client’s needs Vendor-neutral Methodology With ability to make unbiased recommendations based exclusively on client's individual needs, objectives and technology environment Cost-effective, no compromise, revenue-impacting solutions Unparalleled passion for quality, dedication, and innovation Highly qualified and experienced team Committed to exceeding customer expectations Global Project Collaboration Model Utilizing cost effective Offshore Consulting resources USJade Introduction (Cont.)

  6. Services Overview • Supply Chain Planning • Manufacturing • Warehouse Mgmt. System • Purchasing, Inventory, Costing • Order Management • Product Lifecycle Mgmt. • Financials & HRMS • Enterprise Process Management • Oracle CRM Applications • Oracle Data Warehousing • Business Intelligence • Information Management Services • Strategic Services • Enterprise Application Integration • Independent Testing • Technical Implementation • Infrastructure Support Services • Business Continuity & Disaster Recovery • IT Optimization / Green IT • IT Security & Identity Management

  7. Services Overview (cont.)

  8. Some of USJade’s Customers

  9. Telegent Systems, Inc. • Leading Fabless CMOS semiconductor company • Fastest growing Fabless Company – Making Television Mobile • Provide high performance, single-chip solutions enabling free-to-air and pay-per-view mobile TV in mobile handsets, portable devices and consumer electronics • Founded 2004, 158 employees, VC funded • Headquartered in Sunnyvale, US • Subsidiaries in Netherlands, Singapore, China and Hong Kong

  10. Telegent & USJade: a Partnership • Guidance on Best Practices • Implementation of ERP and other Systems • Integration of IT Systems • Customization of IT Systems • Development of Process and IT Solutions • Ongoing Production Support • Telegent-USJade relationship – 1.5 years and ongoing

  11. Program Agenda 1. Introductions 2. Telegent’s Challenges & Needs 3. USJade Solution 4. OA Framework • Overview • Architecture • Application Screen Captures • OA Framework Benefits 5. Questions

  12. Telegent’s Challenges & Needs • Rapidly growing business and transaction volume. • Vendor Inventory Snapshot Reporting Not Comprehensive • Manual transaction processing – Time Consuming and prone to errors • Small OPS team at Telegent • Need for low cost and low risk solution • Need ability to also switch to manual transactions when desired • Need for multi level- validations • Need for B2B Error management • Need to manage by Exception

  13. Agenda 1. Introductions 2. Telegent Challenges 3. USJade Solution 4. OA Framework • Overview • Architecture • Application Screen Captures • OA Framework Benefits 5. Questions

  14. USJade B2B Solution- Integrated Lot Tracking System Oracle e-Business Suite B2B Admin Error Console B2B Loader B2B Database B2B Setups Console B2B Preprocessing and validations B2B Reports B2B Adapters OAF Application USJade B2B Application OSFM WIP Inventory Oracle Manufacturing Suite

  15. B2B Objects • Loader: Loads transactions from vendor reported files to B2B canonical tables • Preprocessing and Validations: • Converts business events to ERP transactions • Validates report for business and ERP level validations • GUI for manual intercepts in processing • Adaptor: • Loads validated transactions in OSFM, INV, etc interfaces • Provides feedback to the B2B database and GUI • Setups and User Admin GUI: Provides GUI for admin and transaction management (error handling and manual intercepts) • B2B Reports: Statistical analysis of vendor reporting performance

  16. B2B Key Features • Automation and Single Error correction console • Automated file processing for business transactions (WIP, INV, SO, PO, AP etc) • File Loader (Manual, FTP, B2B, EDI others) • Canonical Mapping • Custom Adapter for Oracle • HTMLDB/R12 ADF – Web application for error management • Vendor Reporting Guide • The solution can be scaled to a fully automated real-time B2B/EAI solution using middleware technologies like: Oracle SOA Suite, TIBCO, Gentran, Web Methods, Oracle EDI/XML gateway etc.

  17. Agenda • 1. Introductions • 2. Telegent Challenges • 3. USJade Solution • 4. OA Framework • Overview • Architecture • Application Screen Captures • OA Framework Benefits • 5. Questions

  18. OA Framework Overview • OA Framework is the development and deployment platform for Oracle Applications • Based on the J2EE MVC architecture, and features industry standards such as XML, Java/JSP, SQL and Web Services • OA Framework provides several benefits including sophisticated personalization/extension capabilities , high end-user/developer productivity and improved performance • OA Framework is closely tied in with Oracle Applications AOL (Application Object Library), which provides many services to OAF, including security, messages, flexfields etc. • Utilizes JDeveloper to build and debug applications

  19. Browser(HTML) View Controller Model Page definitions, regions included in pages, etc. OA Framework Architecture Application Server Client Data Server Data Servlet Engine UIX Listener OA Controller MDS Repository BC4J

  20. OA Framework Architecture (Cont.) Application Module (contains Business Method) View Objects (Mediator Between EO & AM) Entity Objects (save and Retrieve to Database) Controller Objects (Derive Business Logic & calls Events) HTML Request B2B Schema HTML Response UI X Pages (User Keys in Setup & Mapping)

  21. OA Framework Architecture (Cont.) OA Controller • Controller • The Controller is an OA Framework Java interface with two main methods: processRequest, processFormRequest • UIX • The View is defined using OA Framework metadata, rendered using UIX • BC4J • Multilayered to maximize separation of business logic (Application Module) from data shaping and selection • Entity Objects encapsulate the definition and business rules (validations, actions) associated with a row in a database table • View object encapsulates a database query. After a query is executed, a view object provides iteration over the result set UIX BC4J

  22. OA Application – Screen Captures Systems Set-up: Lookups

  23. Lookup – Underlying Components • AOL Components • Responsibility : B2B_Admin • Menu: B2B_System_Lookup • Functions: System Lookups • OA Objects • UIX Pages: B2BSystemLookupPG.xml • Controller: B2BSystemLookupCO.java • View Object • B2BSystemLookupVO.java • B2BSystemLookupVO.xml • Entity Object: B2BSystemLookupEO.java • Application Module: B2BSystemLookupAM.java

  24. OA Application – Screen Captures Systems Set-up: Vendor Site Mapping(Complex UI)

  25. OA Application – Screen Captures OA Framework contains Export to Excel component and can be easily attached to table

  26. OA Application – Screen Captures Edit Lot Correction(Complex UI)

  27. OA Application – Screen Captures Edit Lot Correction(Complex UI)

  28. OA Framework Benefits • Oracle Application Object Library (AOL), which provides many services to OAF, including security, messages, flexfields, etc are readily available. • Developers using OAF also use the OA Extension, which is a JDeveloper add-in bundled with JDeveloper in specific EBS development environment patches. • OA Extension is an extension to JDeveloper 9.0.3 for EBS 11i, and to JDeveloper 10g (10.1.3) for EBS 12. AOL and OA Extension are not parts of the ADF technology stack for the Fusion Applications. • Maintenance is lower since deployed on Oracle EBS Server. • OAF offers standard Look and Feel.

  29. & Q A

  30. Contact Us Parag Mone Principal Consultant USJade Corp pmone@usjadecorp.com Office: 408-802-8115 USJade Corp 2001 Gateway Place, Suite 570W San Jose, CA 95110 http://usjadecorp.com USJade Ltd. E-Space IT Park, A-3, 2nd Floor, 102 D/E, Wadgaon Sheri, Pune-Nagar Road, Pune 411-014

More Related