1 / 15

Integrating CM Receipt to Oracle Apps Using Apex and Webservices Anthony Vendhan Sami Vellaiyan

Integrating CM Receipt to Oracle Apps Using Apex and Webservices Anthony Vendhan Sami Vellaiyan Jan 21, 2008. Metron Consulting Specializes in Oracle Applications Implementations SOA and Web Services Development Java & OA Framework Development OBIEE Development

seoras
Télécharger la présentation

Integrating CM Receipt to Oracle Apps Using Apex and Webservices Anthony Vendhan Sami Vellaiyan

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. Integrating CM Receipt to Oracle Apps Using Apex and Webservices Anthony Vendhan Sami Vellaiyan Jan 21, 2008

  2. Metron Consulting Specializes in Oracle Applications Implementations SOA and Web Services Development Java & OA Framework Development OBIEE Development Web 2.0 Developments using LAMP technologies Custom Reporting Solutions (Using Oracle tools and open source technologies) ABOUT US

  3. Business Scenario Proposed Solution Why APEX Demo Reference Information Questions Agenda

  4. Our customer Uses Contract Manufactures (CM) to ship goods to end customers (Drop Shipments) CMS Receive Finished Goods from Customer CMS work on the Finished Goods and ship the End Product to the end customer Customer Needs the Advanced Shipment Notification (ASN) from the CM to receive against the PO Customer wanted to automate the advanced shipment notification process BUSINESS SCENARIO

  5. Leverage Drop Ship Orders Develop a web form for the CM to sign up and accept goods delivery Upon Booking, send email reminders to the CM to accept delivery of goods. This email notification will have the link to connect to the web form Upon CM acceptance, receive goods in Oracle automatically Use the CM acceptance as proof of delivery PROPOSED SOLUTION

  6. It’s free! Short learning curve OTN and APEX help online Licensed through the DB No Formal training necessary Wizards are adequate Online Sample code Integrates with Oracle Apps WhY apex

  7. What is Oracle Application Express? Formerly HTML DB Web-based application development tool built on an Oracle database. Rapid creation and deployment of Web pages. Standard functionality to call Web Services. Launched via a URL with parameters passed. Based on wizard-generated Oracle PL/SQL (language of Oracle DB) Can also be hosted by Oracle! WhAT IS apex

  8. All Web Pages are built using point-and-click wizards. • HTML is dynamically created by PL/SQL procedures and functions in the database. • With Oracle database 11g or higher, Apex doesn’t user mod_plsql, in stead it uses the database embedded pl/sql gateway Apex ARCHITECTURE(Prior to oracle db 11g)

  9. Apex ARCHITECTURE(CONTD)

  10. Apex HOME PAGE • Application Builder - to create dynamic database driven web applications. • SQL Workshop - to browse your database objects or create queries using the graphical tools. • Utilities - allows data to be loaded and unloaded from flat files, spreadsheets. • .

  11. Reporting • Forms • Charting • PDF Printing • Spreadsheet Upload • Session State Management • User Interface Themes • Flow Control and Navigation • Conditionality on all Components • External Interfaces and Extensibility ( Web Services) • Security Apex FEATURES

  12. Hypertext linked Reports / Drill down Reports Hypertext Linked charts Calendar Report PDF Printing Data entry forms Build in apex

  13. Demo our solution • Quick Overview of building forms and reports in Apex DEMO

  14. Apex for Oracle10G: http://www.oracle.com/technology/products/database/application_express/download.html Oracle Express Edition: http://www.oracle.com/technology/software/products/database/xe/index.html Access Apex Online using Oracle Apex Free Test Site: http://apex.oracle.com/i/index.html Helpful apex links

  15. Questions?

More Related