Process Manufacturing - EBS (MOSC)

MOSC Banner

Transaction quanity and primary quantity differnce?

edited Apr 29, 2014 12:00PM in Process Manufacturing - EBS (MOSC) 3 commentsAnswered

hello experts,

while doing OPM Reconciliton,

when i finding output of -

select sum(transaction_quantity), sum(primary_quantity)  from mtl_material_transactions where inventory_item_id = 8

and organization_id in (86) and transaction_date >=  TO_DATE('31-Dec-2009 00:00:00','dd-mon-yyyy hh24:mi:ss')

and transaction_date <=  TO_DATE('30-apr-2013 23:59:59','dd-mon-yyyy hh24:mi:ss')

it gives ->

SUM(transaction qty) = -13893227.775

SUM(primary qty)  =  42423

can Transaction qty and primary qty must be same???

in my case ,why this happens???

waiting for valuable update

Kunal.

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