The Customer is a industry leader providing store fixtures to chain retailers throughout the world was using Main Frames and Oracle EBS. We Integrated both the systems by Using Oracle Standard API’s.

Engagement Highlights

  • Integration of Account Payables, Purchase Order and Material Transactions with Legacy System.
  • Seamless design for all the Interfaces .
  • Processing and Reprocessing for all Transactions..
  • Error Form on OAF for Processing Error Records.
  • Emailing of Error Log files for IT for failed processes.
  • Reports on Completion of each Master programs.

How did we Deliver?

  • Developed Interface programs for Account Payables, Purchase Order and Material Transactions.
  • Designed Control Files to Load data based on the file name as Parameter and do basic data conversions on codes in the flat file
  • Used standard API’s for loading the Data into Base Tables.
  • Automated all the processes by designing a single program to execute each Process.
  • Any Error at any stage stops the complete process and send the Log file to desired users given in parameter.
  • Designed an OAF page to reprocess Error Records .
  • PDF Report with complete details of Status of records on completion of Master Program.

What Did Customer Like?

  • Delivering in aggressive time lines
  • Solution design for Processing and reprocessing
  • Technical Expertise in delivering complex requirements
  • Introduction and Adherence to best Practices