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

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 Introduction

• 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

5
USJade Introduction (Cont.)

• Domain knowledge and Industry specialization
• Successful track-record of customer satisfaction
• Client-focused approach
• From initial strategy to deployment that best
  meet our clients 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

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 USJades 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. Telegents Challenges Needs
• 3. USJade Solution
• 4. OA Framework
• Overview
• Architecture
• Application Screen Captures
• OA Framework Benefits
• 5. Questions

12
Telegents 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
Inventory
WIP
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
OA Framework Architecture
Application Server
Data Server
Client
Data
Servlet Engine
UIX
Listener
OA Controller
MDS Repository
BC4J
20
OA Framework Architecture (Cont.)
Application Module (contains Business Method)
Entity Objects (save and Retrieve to Database)
View Objects (Mediator Between EO AM)
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.)

• 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

OA Controller

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

A
Q
30
Contact Us
Parag Mone Principal Consultant USJade
Corp pmone_at_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
31
(No Transcript)