Oracle Apps UI Improvement for Productivity

Business Need

Provide rich, web 2.0-style user interface features to users of Oracle Apps’ iProcurement module, ease the various associated workflows by integrating multiple screens functionality into a single one and provide all this without affecting their current business process

Scope of Work

iProcurement’s requisition approval screen and requisition creation screen was identified as the key portion that required improvement over the traditional features provided by Oracle 11i business suite, including:

• Simplify Requisition Creation process by enabling Rich UI with seamless integration to Oracle's Requisition Approval UI
• Ability to select/process multiple requisition approvals/rejections in one action
• Provide advanced search facility to approvers for easier access
• Ability to see requisition/line level details on same page for corresponding requisition selection for faster response
• Displaying search, requisition header information, requisition line details, and additional information to user in one page
• Interactive web-application with Web 2.0 features like RSS feeds, feedback and communication widget

Solution Details

The iProcurement screens were built using the following technologies at different layers:

Web/ Presentation layer

• Advanced widgets like excel-like data grids, tab panels, dynamic forms, toolbars and menus
• JSON library
• JavaScript
• CSS
• Google Chart API to convert data into PNG images
• Jasper API for print, Emailing, exporting data to excel & PDF formats
• JFree chart to create professional quality charts

Business logic layer

• Spring controllers

Data Access Layer

• Spring DAO’s

Integration with Oracle Apps

• The web client integrated with Oracle Apps framework
• Use of user authentication, authorization and session management APIs from Oracle Apps framework
• Use of DB connection APIs

Benefits

The new web client for Oracle Apps iProcurement provided better user experience. Some of the benefits included:

• Combined and optimized screens reducing number of clicks and providing comprehensive input to the user
• “Assisted” search using AJAX (giving in-place alternatives) simplified search process for the user

Screen Shot