My Oracle Support Banner

When Running Transaction Source Type Summary (Quantity) , Sales Order quantity is 0 for All Items (Doc ID 2061715.1)

Last updated on JUNE 06, 2021

Applies to:

Oracle Inventory Management - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


Actual Behavior
When running Transaction Source Type Summary Report (Quantity), the Sales Order quantity is 0 for All Items

Expected Behavior
Expect to see Sales Order Quantity displayed correctly for the items


  1. Inventory Responsibility - Reports - Transactions
  2. Select Inventory Org
  3. Select "Single Request" and enter/choose report "Transaction source type summary"
  4. Enter Report Parameters:
    Sort By: Item
    Selection Option: Quantity
    Enter Transaction Date Range
    Category Set: (default)
    Source Type for Column One: Sales Order
    Source Type for Column Two: RMA
    Source Type for Column Three: Purchase order
  5. Submit the report, the review the output and see column Sales Order shows zero for all items


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

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