Extract System vs Counted Quantity for Physical Inventory (Before/After Approval - not yet posted)
Hi,
Is there a way to generate or extract a report in Oracle Fusion Cloud that shows both the system on-hand quantity and the counted quantity for a physical inventory before or after approval, using standard functionality or OTBI only?
Ideally, I’d like to view or export data that includes:
- Inventory Organization
- Subinventory
- Locator (if applicable)
- Item Number and Description
- System Quantity
- Counted Quantity
- Quantity Variance
- Count/Approval Status
I’ve checked the “Approve Physical Inventory Adjustments” page, but it doesn’t have an export option. We’re avoiding custom BI Publisher reports for now and hoping there’s a standard way (e.g., OTBI, data extract, or seeded report) to access this information.