Company Type
Macmillan / MPS Distribution, the distribution and fulfillment plant of an international book publisher; prototype within the reconciliation program; Macmillan headquarters took over further development.
What Drove the Need
Matching thousands of Amazon payment and charge rows to A/R records was manual
Business Impact
MVP delivered; Macmillan headquarters took over further development — a validation of the prototype's value
Systems/Data Integration
Feeds matched assignments into the reconciliation platform (SE-18)
Design
ML text and row matching over payment/charge descriptions and A/R records inside the APEX platform
Technology Stack
Oracle APEX Cloud / PL/SQL
Oracle Analytics — machine-learning text matching
Oracle APEX A/R Chargeback Transaction Text & Row Matching (ML)
Application prototype with machine-learning text matching for auto-assigning Amazon payments and charges to MPS A/R records.
