Oracle Fusion Cloud Enhancement and Support


Oracle Fusion Cloud Enhancement and Support


Client Overview

It is a broad-based hotel, tourism, transport and catering group, part of which is owned by the Abu Dhabi government. The company's hotel division acts as a hotel developer and operator - partnering with Hilton, Sheraton, Sofitel and Meridien for some of its flagship properties.

Project Scope

  • Enhancement and support to the day to day activities.
  • Integration of Point of Sales (POS) with Fusion using Oracle Integration Cloud.
  • Custom PaaS solutions for capturing and monitoring Inventory transactions.
  • BI Reports for data extraction.


  • Oracle Fusion Cloud Application

Business Situation

  • Short turnaround time for the Implementation.
  • Testing for quarterly patch updates and version upgrades.
  • Oracle Fusion Cloud Enhancement and Support

Key Challenges

  • Data is manually entered with reference to the Sales and Stock consumptions from POS to Oracle Fusion Financials (AR and GL)
  • No control of material request from outlets between Warehouse team and POS team.
  • No tracking for spoilage and stock return items
  • No systematic tracking for Journal creation for sales in fusion.
  • No process for Material request, Stock Return and Journal Approval 
  • No control and transparency for inventory 
  • Manual computation of stock availability reports


  • Whenever sales/sales return is completed in POS (Focus), respective quantity will be deducted/added from POS inventory and same will be interfaced to Fusion Inventory using Oracle ICS.
  •  Spoilage items are interfaced to Fusion Inventory
  •  Developed the custom form for Material Request (Request from POS to custom form then send to Fusion once review and submitted by warehouse team)
  •  Developed the custom form for Stock Return ( Outlets returned items are moved to fusion once submitted by warehouse team)
  •  Developed the Journal approval form (Cash Sales are interfaced to Fusion GL on next day. Custom form to approve the Journal which interfaced from POS. Once approved, the same will be interfaced to Fusion GL.)
  •  Capturing and monitoring the transactions in PaaS form.
  •  Synchronized the on hand quantity items between fusion and custom form which handled through custom scheduler form by time interval
  •  Scheduled the Stock Availability Report to all outlet in charges and warehouse on daily basis.
  •  Material transfer from Warehouse to Outlet, the same will be interfaced from Fusion Inventory to POS at the end of the day.

Business Process Flow


  • Real time stock consumption integration with POS and Fusion
  • Daily integration on sales with Fusion
  • Manual loads reduced by automating the daily sales calculation and inventory process.
  • Reduced the manual loads for stock consumption and spoilage
  • Able to track Material Request and Stock Return from different outlets
  • Able to analyze the sales revenues between the outlets
  • High data accuracy
  • Inventory Transparency 
  • Easy to monitor and tracking the daily transactions
  • Systematically implemented the Sales and VAT calculation to avoid the manual errors.


No items found.