Automation Development and Optimization for OR-SIM

Abstract

A new democratic relationship between consumer and retailer is emerging. The single biggest challenge for retailers is to understand, empower and represent the new digitally empowered consumer operating across all touch points including mobile. Oracle explores new retail democracy and establishes opportunities for retailers to get real-time access to store management and reporting functionality wherever it – on the front need register, the back-office PC, or tablet devices. Oracle provides many retail solutions like Oracle Retail Merchandising System, Oracle Retail Store Inventory Management System, Oracle Retail Point Of Sale,etc to helps the retailers work smoothly.

Oracle Store inventory management system helps store to perform in-store operations including item look-up, receiving, adjustments, stock count, and inter-store transfers. SIM helps to maintain accurate inventory positions, track where the inventory is and can provide visibility to this information, saving the sale. OR-SIM manages transfer or return merchandise from warehouse or directly from vendors.

Before releasing a newer version of any product it needs to be thoroughly tested and all the possible scenarios need to be covered. Hence, in this project the current version 14.1 of the Oracle Store Inventory Management product will be tested by automating the various test scenarios. The main objective of this project is to execute the existing test scripts written using VBScripts for automating the regression testing of the OR-SIM product using the automation tool called HP-QTP. These testcases are to be migrated to Oracle's newer solution SYNERGY using JAVA language for getting an optimum automated testing suite for SIM. Also the methods of Data Generation will be written using PL SQL queries in Oracle Database 12c, for creating foundation data for regression testing and addition of new functionality to be done for making automation testing optimized.