Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Adding the Primary & Secondary Quantities in the Shipment Lot details within OTBI
User_TA43E
Rank 1 - Community Starter
Description
Within the Order Management - Fulfillment Lines Real Time there are fields regarding the Lot and Serial Details. It would be immensely helpful if the primary and secondary quantities shipped would be added at this level as OTBI fields. Currently the quantities shipped by lot are kept in the RCV_SHIPMENT_LINES.QUANTITY_SHIPPED table field but are not accessible within OTBI.
Use Case and Business Need
Having these fields in OTBI would be helpful for lot recall reporting as well as Order Management reporting.
More details
Currently any reporting regarding actual lots shipped needs to be a BI Publisher report that limits the reports abilities and flexibilities.
Original Idea Number: 2c0e43b4b7
1