You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Physical Inventory Adjustments Stuck in Pending Transactions!

Summary:

Physical Inventory Adjustment transactions stuck in Pending Transactions with error: inv_tm_txns.process_lot_serial-6 procedure. Error: User-Defined Exception. Items are lot controlled but not serial controlled. Lot quantities match transaction quantities. Tried purging but issue persists.

Content (please ensure you mask any confidential information):

We have Physical Inventory Adjustment transactions stuck in Manage Pending Transactions.

Error Message:
You can't process the transaction because an error occurred in the inv_tm_txns.process_lot_serial-6 procedure. Error: User-Defined Exception.

Error Code: INV_MATRX_INT_SQLCODE

Transaction Details:

  • Transaction Temp ID: 300002282413242, Item: 03-50-964-07405-51548, Qty: 30, Lot: LOT21501, Subinventory: HOP_OPPH

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!