Download - Oracle MAF to improve WMS
![Page 1: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/1.jpg)
Using Oracle MAF to improve
efficiency in Oracle WMS
SROAUG, July 2015
![Page 2: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/2.jpg)
Disclaimers
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
Pleases note that this PowerPoint presentation is an educational tool that is general in nature. All materials included herein are for demonstration purposes only and should not be relied upon without extensive testing. Please report errors in this presentation to the authors. Computer Technology Resources , Oracle and the authors do not warrant that this document is error-free.
Computer Technology Resources, Inc. © 2015
![Page 3: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/3.jpg)
Presenter
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Emil Varghese
Technical
11 years experience
![Page 4: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/4.jpg)
About CTR
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Oracle System Implementer since 1998
• Offices in US, Canada and India
• Services Portfolio
eBusiness Suite
Fusion HCM
PeopleSoft HR
Big Data Analytics
Business Intelligence
SOA and Middleware
Managed Services
Cloud Solutions
Mobile Applications
Training
![Page 5: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/5.jpg)
Agenda
Revised: December 2013 R12 New Features: Inventory
1.Overview of Oracle MAF
2. Oracle Integration
3. Extending Oracle WMS to Mobile
4. Reference Documents
5. Questions
![Page 6: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/6.jpg)
Mobile Application Development
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Native Apps Developed specifically for one platform (Objective C for iOS, Java
for Android) Take full advantage of all the device features.
• Mobile Web Apps Developed using HTML5, JavaScript and server side languages or
application frameworks like Rails, PHP, Python etc. Runs in the web browser of the device
• Hybrid Apps Combines elements of both native and web apps. Uses HTML5 and CSS to render the user interface in the mobile
platforms Web View
![Page 7: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/7.jpg)
Oracle MAF
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Cross Platform development Built Once and run on multiple platforms
• Easier UI development Integrated into both jDeveloper and Eclipse. Both IDEs provide integration with iOS and Android SDKs. Visual and Declarative development capabilities.
• Java, JavaScript and HTML-5 based application development.
• Access to native device features Open source Apache Cordova into MAF for access to device
features.
• Support for offline mode using local SQLite database. • Mobile Security
![Page 8: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/8.jpg)
Oracle MAF Architecture
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
Device Features
Apache Cordova
Java VM
![Page 9: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/9.jpg)
UI Implementation
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Web View Uses a mobile device's web engine to display and process web-based content. In a MAF application, the web view delivers the user interface by rendering the application markup as HTML 5.
MAF AMX Declarative interface and Visual
development (XML format) Renders into HTML5 and JavaScript at
runtime.
Local HTML Programmatic HTML5 with any third
party frameworks.
Server HTML User interface, page flow logic, and
business logic are delivered from a remote server.
![Page 10: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/10.jpg)
Device Features Interaction
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Apache Cordova The Apache Cordova JavaScript APIs integrate the device's native
features and services into a mobile application. Email SMS Contacts GPS Camera Files
![Page 11: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/11.jpg)
Business Logic
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Java Virtual Machine
Provides Run time environment for MAF. JVM is implemented in device-native code. Embedded into each instance of the MAF application as part of the native
application binary.
Business Logic Implemented using Java Managed Beans
Model Connects business logic components with user interface. Provides execution logic to invoke SOAP/REST services.
JDBC JDBC API enables the model layer to access the data in the
encrypted SQLite database through CRUD (Create, Read, Update and Delete) operations.
![Page 12: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/12.jpg)
Security
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Authentication HTTP Basic Integration with Oracle
Access Manager for Mobile and Social server
OAuth
![Page 13: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/13.jpg)
Development Environments
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• jDeveloper 12c • Eclipse • MAF 2.0.1 • Xcode • Android SDK • EBS 12.1.3
![Page 14: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/14.jpg)
Set up with iOS
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Needs a MacOS with XCode • jDeveloper - Tools -> Preferences
• Update with the iOS info.
![Page 15: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/15.jpg)
Set up with Android
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Download and install the Android Stand-alone SDK Tools • jDeveloper - Tools -> Preferences
• Update with right entries • Start Android SDK
![Page 16: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/16.jpg)
Agenda
Revised: December 2013 R12 New Features: Inventory
1. Overview of Oracle MAF
2.Oracle Integration
3. Extending Oracle WMS to Mobile
4. Reference Documents
5. Questions
![Page 17: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/17.jpg)
Integrated SOA Gateway
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• A complete set of service infrastructure to provide, consume, and administer Oracle E-Business Suite Web services.
• All Oracle E-Business Suite integration interface definitions are accessible through the Oracle Integration Repository
• SOAP and REST (from 12.2) support. • Supports custom integration interfaces. • Supports multiple authentication types for security • Ability to monitor services. • Function security and role-based access control security.
![Page 18: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/18.jpg)
Supported Interfaces
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• PL/SQL • XML/ EDI Gateway • Concurrent Programs
• Business Events • Interface Tables/Views • Java
![Page 19: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/19.jpg)
Custom Integration Interface
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• The Integration Repository will recognize integrations through annotations in the PL/SQL code.
• Only the package spec should be annotated.
![Page 20: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/20.jpg)
PL/SQL Api’s
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Package has Procedures / Functions that can be exposed as web services.
![Page 21: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/21.jpg)
Importing into ISG
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Create an iLDT file (Integration Repository loader file) that is uploaded to the Integration Repository. Use irep_parser.pl perl script to generate ildt file
• Upload to IR using Use $FND_TOP/bin/FNDLOAD $FND_TOP/patch/115/import/wfirep.lct
![Page 22: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/22.jpg)
Custom Packages in ISG
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Once imported, the interface will be available in Integrated SOA gateway
![Page 23: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/23.jpg)
Deploy services
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Generate WSDL
• Once WSDL is generated, used the Deploy option to deploy the web service.
![Page 24: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/24.jpg)
Deployed services
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
![Page 25: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/25.jpg)
WSDL
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• The URL can be used to call the custom package with the required parameters
![Page 26: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/26.jpg)
Grants
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Grant access to the web service for users
![Page 27: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/27.jpg)
Agenda
Revised: December 2013 R12 New Features: Inventory
1. Overview of Oracle MAF
2. Oracle Integration
3.Extending Oracle WMS to mobile
4. Reference Documents
5. Questions
![Page 28: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/28.jpg)
Task Planning in the warehouse
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Release work to the warehouse floor to optimally run the day-to-day warehousing operations.
• Tasks are comprised of demand pick tasks for sales orders, work orders, and replenishment.
• Tasks are also comprised of inbound receiving and put away tasks, slotting inventory transfer tasks, inventory control related cycle counting tasks, and inbound-outbound hybrid cross-docking tasks.
![Page 29: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/29.jpg)
WMS Control Board
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Tool for warehouse supervisors to monitor, plan, control, and execute various warehouse operations, including the following Query tasks Plan tasks Release tasks Assign, reassign, prioritize the progress of tasks Perform manual scheduling Cancel cross-dock tasks
![Page 30: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/30.jpg)
Extending Control Board to Mobile
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Mobile application is integrated with Oracle EBS instance via web services in Integrated SOA Gateway
• Oracle EBS security is used for authentication. • Includes Inbound, Outbound, Warehousing and
Manufacturing Tasks • Ability to search tasks by Status, Task Types, Employee, Item,
Dates, Sub inventories, Locators, Manufacturing and Warehousing.
• Real time actions using Manage Tasks. • Real time Inventory Position View
![Page 31: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/31.jpg)
Functionality – Find Tasks
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Task Status- Unreleased, Pending Queued, Dispatched, Active Loaded, and Completed. Multi Select should be allowed.
• Task Source- Inbound, Outbound, Warehousing, Manufacturing and Cross Docking.
• Task type and Priority • Item Details- Item and LPN • Resources: Employee and
Equipment • Location
![Page 32: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/32.jpg)
Functionality – Find Tasks By Outbound
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Order Details - Sales Order Number ,Order Type ,Pick Slip Number, Customer name and Customer Number
• Shipping Details - Delivery Number ,Trip, Carrier, Ship Method, Priority and Ship Date Range
• Ship To- State ,City and Zip Code
![Page 33: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/33.jpg)
Functionality – Find Tasks By Inbound
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• By Purchase Order
• RMA • Requisition • Shipment
![Page 34: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/34.jpg)
Functionality – Find Tasks By Manufacturing
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• By Job • Assembly • Department • Job Dates
![Page 35: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/35.jpg)
Functionality – Find Tasks By Warehousing
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Move Order type • Move Order range • Sub inventory Transfers • Select Moves – Staging and Material
![Page 36: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/36.jpg)
Manage Tasks
July 2015 Using Oracle MAF to improve efficiency in Oracle WMS
• Update Status • Assign Employee • Assign Task Type • Set Priority • Increment Priority • Decrement Priority • Task Split , Qty. & UOM change and employee assignment • Delivery LPN Qty. Adjustment • Task Cancellation
![Page 37: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/37.jpg)
Reference Documentation • Oracle E-Business Suite Integrated SOA Gateway Developer's Guide
• Get Started with Mobile Application Framework with Jdeveloper
• Oracle Warehouse Management User's Guide
Using SLA to Process Prepaid Invoices in Payables April 2015
![Page 38: Oracle MAF to improve WMS](https://reader031.vdocuments.us/reader031/viewer/2022020103/58e595291a28abdd148b5ce5/html5/thumbnails/38.jpg)
Q&A
Revised: December 2013 Oracle Quality