Throughout my many years of Application Interface development, I have grown to love designing and implementing custom Oracle interface processes. No matter how many times you develop an Order Management Interface or Suppliers conversion, no two are alike. One particular module that has landed on my favorite’s list is Oracle Projects. What a cross-combination of items: customers, employees, assignments, locations, accounting and of course the Projects module objects themselves. With Projects you have Templates, tasks, budgets, expenditures, costing and billing, just to name some of the key aspects. Developing conversion and interface processes for this module has become a specialty of mine.
This will be the first in a series of blogs on Oracle Projects, as I pass on the major features for developing custom interface processes into Projects. The first interface I will detail, utilizes standard Oracle Project API’s, to create and update Project records. In subsequent blog entries, I will describe how to interface expenditure data to projects using Oracle’s standard Projects Interface table.