Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to Retrieve Supplier Name for Project-Linked Miscellaneous Inventory Issues Using Lot Numbers?

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
-
Hi @skhan,
If response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
Thanks,
Riyaz Ali0
Answers
-
0
-
You can check the Genealogy tables.
GenealogySerial Number Details for Inventory TransactionsLot Details for Inventory Transactions0 -
sure i will go through it and get back to you thanks for your response.
0