Lot Creation Errors wih - MTL_TRANSACTION_LOTS_TEMP Has Unprocessed Rows for This Lot

(Doc ID 404684.1)

Last updated on JANUARY 19, 2018

Applies to:

Oracle Shop Floor Management - Version to [Release 11.5]
Information in this document applies to any platform.
Checked for relevance 16-SEP-2012
** Checked for relevance on 20-Aug-2014 **


When attempting to create a new Lot via the Lot Creation form the following error occurs:

'MTL_TRANSACTION_LOTS_TEMP has unprocessed rows for this lot'

Expect lot-based transactions to progress without becoming stuck in any pending statuses and to leave no orphaned rows in temp tables.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms