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
Introduce WMS Integration status column in OTBI
Organization Name
MASSIMO ZANETTI BEVERAGE GROUP SPA
Description
We are creating a report using OTBI with the "Shipping Real Time" subject area.
We couldn't find the column named Integration status that we have in Manage shipment lines in the Inventory Management screen. Customers needs it because he has to develop an inventory analysis to check the shipment lines that have been transferred to WMS/3PL but not yet picked/shipped and to check the lines that are not transferred yet to WMS/3PL according to Schedule ship dates.
The values for Integrations status are stored in table WSH_DELIVERY_DETAILS column WMS_INTERFACED_FLAG.
Use Case and Business Need
The user wants to have the opportunity to see in a report the order lines linked or not linked to external systems as WMS/3PL and he wants to verify if there are any shipment delay from the external systems side (WMS/3PL). This information is crucial for the user to better understand the analysis.
Original Idea Number: 59a6fee26d
Comments
-
0
-
This would be a great planned option, Current client is implementing Cloud SCM with Oracle WMS and want's the ability to see the WMS movements linked to Cloud orders
0 -
Important column to be added in this subject area
0 -
wms_interfaced_flag from wsh_delivery_details
CONFIRMED
INTERFACED
READY
select distinct wms_interfaced_flag from wsh_delivery_details0
