How to Retrieve Supplier Name for Project-Linked Miscellaneous Inventory Issues Using Lot Numbers? — Oracle Analytics

Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to Retrieve Supplier Name for Project-Linked Miscellaneous Inventory Issues Using Lot Numbers?

Accepted answer
44
Views
4
Comments

We are currently using lot-controlled inventory in Oracle Fusion Cloud, where all inventory issues—including miscellaneous issues linked to projects—are processed using lot numbers.

Our requirement is to trace each inventory issue back to the original supplier, based on the lot number used for issuance.

I have tried building a report in OTBI using the subject area “Inventory - Inventory Transactions Real Time” to extract item and lot number information against each miscellaneous issue. However, the analysis returns no output, and this subject area doesn't appear to expose supplier information.

We’re specifically looking to answer:

  • Can we trace supplier name for issued materials by lot number?
  • Is there any OTBI subject area or method to link lot numbers in miscellaneous issues back to their original purchase receipts and suppliers?
  • If not in OTBI, can this be achieved through BI Publisher using secured views or a supported workaround?

Any guidance on how to build such a traceable report or whether this linkage is supported in Fusion Cloud would be appreciated.

Best Answer

Answers