BizTech Blog

In response to many recent requests, I’ve included tactical details and technical code used to create SLOP (slow moving obsolete product) report. This post is geared toward all of the die-hard Oracle techies and serves as a returned favor for all the code posted in other resources that has assisted me.

Using BI Publisher with Oracle E-Business Suite to Analyze Inventory

Recently, I arrived bright and early to support the first month-end close after a large client R12 upgrade from 11.5.9 to support closing of the books. The invoices for the month were 10 million dollars, but the revenue in General Ledger was only 5 million and the CFO looked a bit concerned. Where was the rest of the revenue hiding?

As a follow-up to my prior Advanced Supply Chain Planning (ASCP) post, I decided to provide a more detailed write-up.

What is ASCPA, and what does it do?

Successful supply chain management starts with efficient supply chain planning. The scope of this discussion pertains to one section of the Value Chain that I often refer to as, “inside the four walls of the Supply Chain". It will guide you through both planning and scheduling of supply and demand while utilizing Oracle E-Business Suite MRP to achieve efficient supply chain planning.

Strategic Initiatives

Having spent more than a decade focusing on improving Supply Chain, and a high percentage my energy was spent using quantitative information. KPI’s, Cubes, Dashboards, Briefing, Portals, , Data Marts and the list go on. The algorithms have not changes to much. Future projected turns was one recent change for me, but there has been a lot of renaming or repackaging of proven techniques. A colleague of mine decided to rename an old inventory analysis process or classification of Excess and Obsolete (E&O) to Slow Moving Obsolete Product (SLOP). It’s a bit more descriptive than E&O, and has a slight humorous tone.