Extract System vs Counted Quantity for Physical Inventory (Before/After Approval - not yet posted) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!