Landed Cost Automation using Orchestrator saves us thousands of dollars per year!
-
Posted by Quest Customer Learning Team
- Last updated 12/19/23
- Share
Presented at INFOCUS 2023
Session ID: 101080
No Joke! We discovered an issue in our receiving process that was literally costing us thousands of dollars. Many Landed Cost entries were being missed! As a book publisher, we have quite a bit of landed cost that needs to be added for things like Freight, Creative costs, components, Paper, and Signature blocks. We did a review of last year and the total unit costs missed were sometimes upwards of thousands of dollars per title! So, we needed a good solution – and fast!
In this session we will walk through how we solved our issue of the missing landed costs. We created an Orchestration that can read the landed cost lines on the Purchase Orders and once the product is received and put in stock it will automatically apply the landed costs. Creating this orchestration was a bit complex in that we had to figure out how to collect the proper category from the PO line as well as do some calculations based on the actual number of units received. So this resulted in a set of 3 orchestrations running in a sequence – but they handle it all! We only need to review exceptions. We also included notifications for the POs that were successfully completed and another if there was an issue.
No more watchlists getting ignored or Landed Costs forgotten! Unit costs are kept updated and we are saving thousands!
Watch the full-length video
Premium Content: access is limited to Quest Corporate and Professional members.
Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.