The Spare Parts business process at Intelligrated was built utilizing a custom application that only one person could support.  It relied on nightly updates of data from Oracle and had a number of manual processes that could introduce inconsistencies to the data that was then sent to customers.  A new tool was built utilizing Oracle APEX that pulls data in real-time from the Oracle Inventory, PIM, Advanced Oracle Pricing and Order Management.  APEX out-of-the-box provides analytic tools for pivoting and building reports to help manage the process.  The new tool also calls Oracle APIs to update UDAs and generate pricing for all parts that are being sent to the customer.  This presentation will show what was built for Intelligrated, and features that are inherent within Oracle APEX.