Friday, November 23, 2012

Analytic FIFO multiplied - part 3

This is part 3 of a three part posting on analytic FIFO picking of multiple orders. Part 3 shows how to combine the FIFO developed in part 1 with the analytics used for the better route calculation in an earlier blog post.

Analytic FIFO multiplied - part 2

This is part 2 of a three part posting on analytic FIFO picking of multiple orders. Part 2 shows an alternative way of doing the same thing as part 1 did - but this time using recursive subquery factoring in Oracle v. 11.2.

Analytic FIFO multiplied - part 1

I have blogged before about Analytic FIFO picking as well as talked about it at KScope12 and will do again at UKOUG2012.

A few days ago Monty Latiolais, the president of ODTUG, had a need to do this - not just for one order which he already had developed the technique for, but for multiple orders, where the FIFO picking for the second order should not consider the inventory that was already allocated to the first order, and so on.

So here is a three-part demo of how to do this.

Wednesday, November 21, 2012

Ready for UKOUG2012

I think I am about ready for UKOUG conference 2012. Hope I haven't forgotten something :-)

  • Train ticket to airport - check
  • Plane ticket to get to Birmingham - check
  • Hotel reservation - check
  • UKOUG2012 registration - check
  • Planned my agenda - check
  • Chairing a session - check
  • Uploaded presentation for my session - check
  • Discovered where to get Oracle beer near ICC - check
Yup - checklist done :-)

If you're interested, come to my session Wednesday Dec. 5th at 12:10 and see if I can speak fast enough to go though 130 slides in an hour showing these cases of using analytic functions:
  • Case 1: Top selling items 
  • Case 2: Picking by FIFO 
  • Case 3: Efficient picking route 
  • Case 4: Picking efficiency 
  • Case 5: Forecasting sales 
  • Case 6: Forecast zero firework stock

See you in Birmingham :-D

Thursday, November 15, 2012

A bit of fun expressing ratios

Sometimes answering questions on the OTN forum leads to a little fun trying to be creative in SQL ;-) A user wished to express a ratio as 1:1 or 1:2. That lead to a little fun with CONNECT BY on DUAL for recursion.