Supplier Lot to Internal Lot Report in Business Intelligence

Summary: Need to view Supplier Lots with our Internal Lots for Inventory On Hand Balance. We work with Contract Manufacturing, so keeping track of their Lot with our own internal Lot is critical.

Content: There are currently zero Subject Areas that house the Supplier Lot and Internal Lot numbers. The only way to do this is to build a custom query, linking the Warehouse Tables to others, which is not very straight forward, and not in everyone's skill sets.

Two questions:

-Does Oracle have this enhancement in their roadmap? To map Suppler Lots to the Inventory Tables? Particularly On Hand Balance Real Time?