Process Manufacturing - EBS (MOSC)

MOSC Banner

For what purpose Lot Cost Process create data in GMF_LOT_COST_DETAILS with negative header_id and ha

edited Dec 4, 2017 4:00AM in Process Manufacturing - EBS (MOSC) 3 commentsAnswered

We are using Lot Cost Type for Fiscal Policy since 2009 with R12.1.2.

Lot Cost Process running by schedule almost every day.

Now if we run this script:

select count(*) from apps.gmf_lot_cost_details lcd

WHERE NOT EXISTS ( SELECT 1 FROM gmf_lot_costs lc WHERE lc.header_id = lcd.header_id) 

the result = 115071808

and 90% with negative header_id

And it will increase from day to day.

The question is Lot Cost Process create data in GMF_LOT_COST_DETAILS with negative header_id and have no link to GMF_LOT_COTS ?

Is it normal or just garbage that need data fixed to cleared that record.

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