Inventory Management - EBS (MOSC)

MOSC Banner

mtl_material_transactions ... SUM Produces Multiple Rows?

edited Jul 19, 2023 3:50PM in Inventory Management - EBS (MOSC) 12 commentsAnswered ✓


Can someone please explain to me why the query below is producing multiple rows for a single date?


I am baffled, I need to view the SUM(transaction_quantity) by date but the query produces multiple rows for the same date and I cant figure out why?


SELECT

transaction_date,

SUM(transaction_quantity)

FROM

mtl_material_transactions

GROUP BY

transaction_date

ORDER BY

transaction_date

;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center