Inventory Management - EBS (MOSC)

MOSC Banner

NEW_COST and PRIOR_COST columns in MTL_MATERIAL_TRANSACTIONS table

edited Nov 30, 2011 1:59AM in Inventory Management - EBS (MOSC) 8 commentsAnswered
Hi,

I would like to know how are PRIOR_COST and NEW_COST columns getting populated in MTL_MATERIAL_TRANSACTIONS table.

We have a custom form which is based on Miscellaneous transactions form, INVTTMTX.fmb (Inventory responsibility) where we are populating Unit Cost field. The original form, INVTTMTX.fmb does not populate Unit Cost field. The only way I see MTL_MATERIAL_TRANSACTIONS table getting populated is through our custom form. We are populating Actual_Cost and Transaction_Cost columns in MTL_MATERIAL_TRANSACTIONS  but I am not sure how Prior_Cost and New_Cost columns are getting populated. Any help is much appreciated. 

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