My Oracle Support Banner

Web Reports Gen 2: Building Inventory - Location Report Not Showing All Locations (Doc ID 2683124.1)

Last updated on JULY 23, 2020

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 20.2 and later
Information in this document applies to any platform.

Goal




How to build an inventory report with the following fields:
- Article
- LPN
- Pallet (optional)
- Location
- Current Qty
- Lock code (optional)
When attempting to  make a join between "Container" and "Location" tables, using Container.Current_Location_id=Location.id, the reports doesn't return all locations. 
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.