iPhone App integrated with Oracle Applications

Posted by in Uncategorized

With the advent of Mobile devices, specially smart phones, it becomes imperative to be able to let users access Oracle Apps using their mobile devices to improve sales and service while on the move. iBizSoft has developed various iPhone UIs that let’s users Create Orders, Track Orders, Check on Item status etc.

Mobile Apps with Oracle ADF

* Extensions for Oracle Applications but also build Mobile Apps for Oracle Application

* There are 2 ways one can design mobile apps using
* ADF Mobile Browser
* ADF Native Client

* In this presentation we will focus on mobile apps designed using ADF Mobile browser

* ADF Mobile browser is built upon the component model of JSF , using which on can develop mobile applications incorporating the same methodologies as developing JSF applications on a desktop.

* JSF provides a Model-View-Controller(MVC) mechanism

* The ADF mobile browser renderer ensures that content can be consumed correctly by the target browser.

* ADF Mobile browser application is almost identical to ADF Web application development , except the ADF Mobile browser application development uses only mobile JSF pages that consist of Apache Myfaces Trinidad components. In this way one can re-use the desktop browser application’s model and controller layers to assemble a new view layer for mobile devices by using similar Apache MyFaces Trinidad Components.

To Create a ADF Mobile browser application

* Configure the environment by creating an application and Project.
* Add a Model Project for ADF-BC ( if Required).
* Add a Web Project
* Add the JSF pages using Apache MyFaces Trinidad components.

Goal : Create Sales Order in Oracle Order Management from Mobile Device.

Approach –
* Create PL/SQL wrapper API for Order Creation API OE_ORDER_PUB.
* Create Web Service from pl/sql API ( Created in Step#1).
* Design Mobile UI from this web service with ADF Mobile Browser.
* Deploy and Test Mobile Browser
* Access Mobile Browser App from iPhone /Any other Smart Phone.

Step #1 – Create Wrapper API on OE_ORDER_PUB
declare
l_status VARCHAR2(1000);
BEGIN
l_status:= XXMBSALESORDER.createOrder(1437,1005,1024,1000,’USD‘,’PO-9090‘,149,1,’Location’);
end;

Step #2 – Create Web Service Based on Wrapper API Created in Step #1