Integrating CM Receipt to Oracle Apps Using Apex

Integrating CM Receipt to Oracle Apps Using Apex and Webservices Anthony Vendhan Sami Vellaiyan Jan 21, 2008

ABOUT US 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)

AGENDA • Business Scenario • Proposed Solution • Why APEX • Demo • Reference Information • Questions

BUSINESS SCENARIO • 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

PROPOSED SOLUTION • 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

WHY APEX • • 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

WHAT IS APEX • 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!

APEX ARCHITECTURE (PRIOR TO ORACLE DB 11 G) • 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 11 g or higher, Apex doesn’t user mod_plsql, in stead it uses the database embedded pl/sql gateway

APEX ARCHITECTURE (CONTD)

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. .

APEX FEATURES • 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

BUILD IN APEX Hypertext linked Reports / Drill down Reports Hypertext Linked charts Data entry forms Calendar Report PDF Printing

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

HELPFUL APEX LINKS Apex for Oracle 10 G: 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

QUESTIONS?