Inventory Receiving Transactions Fail With Error: RVTII-060: INV_TXN_MANAGER_PUB.process_Transactions Code-449 Msg:ORA-00449 Background Process 'MMON' Unexpectedly Terminated With Error 448 (Doc ID 1932406.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to save Deliver transactions in Receiving Transactions window, the following error occurs:


When further debugging per <Note 299497.1>, Inventory debug log file shows:

[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: Exception while exploding
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: before calling java TM transaction quantity=2000
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: before calling java TM secondary transaction quantity=
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: before calling java TM primary quantity=2000
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: Done with MMTT cursor insrowcnt=1 failedrowcnt=0
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: l_process: 1
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: ***Calling TM **
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: ERROR : Code-449,Msg:ORA-00449: background process 'MMON' unexpectedly terminated with error 448
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: no record found in mmtt
[03-OCT-14 14:04:13] INV_LPN_TRX_PUB: Exiting PROCESS_LPN_TRX with exception from_mti= trx_hdr_id=971091
[03-OCT-14 14:04:13] INV_TXN_MANAGER_PUB: Error from PROCESS_LPN_TRX..
[03-OCT-14 14:04:13] inv_receiving_transaction: TXN_COMPLETE - Enter txn_complete : 10: 2014-10-03 02:03:13
[03-OCT-14 14:04:13] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.1: p_group_id - 12995
[03-OCT-14 14:04:13] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.2: p_txn_status - FALSE
[03-OCT-14 14:04:13] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.3: p_txn_mode - PROCESSOR

Steps
The issue can be reproduced at will with the following steps:
Navigate to Receiving / Receiving Transactions RCVTXERT form 
Deliver Standard Purchase Order with Inventory Destination

Cause

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