All work
2023

Oracle Royalty Management Tool (ORMT)

Replaced macro-Excel and email templates with a self-service tool that auto-calculates royalties and submits straight to AR.

75%
reduction in manual processing time
4d → 1d
per royalty cycle
18K+
submissions to date (~20/day)
Role
Program Manager, Requirements & Change Management
Timeline
Rollout across partners and internal teams
Stakeholders
Royalty ops, Legal, Finance, AR, Partner Support
Tools
Oracle ApexOracle R12VisioSharePoint
01Context

Partner royalty submissions ran on a manual macro-Excel process: partners emailed templates, support pulled agreements, cross-validated line by line, and routed to AR. Slow, error-prone, and a compliance risk.

02Problem

Each submission took days of manual validation, and inconsistent handling made compliance hard to guarantee at scale.

03Approach
  • 01Program-managed requirements, rollout, and change management end to end.
  • 02Translated the operational pain points into defined requirements for automated validation against pre-loaded partner terms.
  • 03Managed rollout to partners and internal teams, running change management so the tool was adopted rather than worked around.
  • 04In parallel, drove the digitization of the Partner Store's Non-Standard Request Form.
04Build
  • Self-service submission that auto-calculates royalties from partner-entered sales against pre-loaded terms and submits straight to AR.
  • Automated validation requirements translated from real operational pain points.
  • Digitized Non-Standard Request Form for the Partner Store.
05Impact
4d → 1d
cycle time (75% reduction)
18K+
submissions processed to date
Champion
multiple Quarterly Champion wins