BizTech Blog

Part 2 - Oracle E-Business, Supply Chain – How to use Oracle BI Publisher based reporting to analyze and reduce your Inventory levels

Author: Bob Bullman Date: Jun 27, 2014 11:40:00 AM

Categories: Oracle E-Business Suite

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

Read More

OBI Won! Utilizing Oracle Business Intelligence with Oracle E-Business Suite

Author: Stephen Goldsmith Date: Feb 7, 2014 2:35:00 PM

Categories: Oracle Business Intelligence, Oracle E-Business Suite

In Star Wars, a New Hope, (the original one, not the sequels, or, gasp, the prequels) Darth Vader meets Obi-Wan Kenobi for what will likely be the last time, a duel of two former best friends. “I’ve been waiting for you Obi-Wan,” he hisses, and proceeds to quickly defeat poor old Obi Wan Kenobi, sending him to meet the Force. So when the two clashed swords (well, technically, light sabers), Vader won and Obi lost.

In the real world (where my mind sometimes resides) I’m often confronted by clients telling me that Oracle EBS, while the number one ERP system in the world, can be a little cumbersome when trying to perform financial analysis. Say I want to review my all of AP invoices, then further sort by one specific vendor, on one specific date and even by one specific location. Essentially I want to know who quickly are we paying our vendors, who is lagging and what are the details? Also, I’d like to export in Excel or PDF and maybe do some more analysis there.

Read More