Transaction Processor Error and Java Exception when Trying to Transact Move Orders, Complete Work Orders (Doc ID 1172503.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
TrxProcessor.class (TrxProcessor.java)
Transact Move Order
Work order-less transactions form, Lot/Serial
This note includes all versions of Oracle E-Business Suite 11i and Release 12


Symptoms

When trying to complete work order-less transactions, or transact move orders for shipping, users can't save the records and Transaction Processor Error message pops up.

A) Steps to Reproduce

1) Order Management: Pick release sales order
Oracle Inventory: Transact Move order: Enter the move order number and find. Click on first line of the sales order and click on Transact. "Transaction Processor Error" error message appears on the screen.

2)Work in Process: Work order-less transactions form: Enter assembly item, quantity.
Click on lot/serial and enter serial numbers. Click OK.
Click Save. Get "Transaction Processor Error".

B) All material transactions above get stuck in Pending Transaction mtl_material_transactions_temp (MMTT) and show the "Transaction processor error" in the Error_code column
(See Inventory Pending Transactions in MMTT Data Collection Test <Note: 398699.1>)

C) Obtain Inventory Debug by following steps below:

Attempt to resubmit one of the stuck transactions in MMTT ( Inventory > Pending transactions) and capture inv debug:
Enable inventory debug per <Note 148651.1>. The details follow for your convenience:
INV:Debug Trace = YES
INV:debug level = 11
INV: Debug File = /tmp/invdbg_TAR.db

Inventory debug shows error below:

[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: Exception while exploding
[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: Done with MMTT cursor insrowcnt=1 failedrowcnt=0
[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: l_process: 1
[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: ***Calling TM **
[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: ERROR : Code-29532,Msg:ORA-29532: Java call terminated by uncaught Java exception: java.lang.VerifyError: (class: oracle/ap
[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: no record found in mmtt
[09-AUG-10 12:04:47] INV_LPN_TRX_PUB: Exiting PROCESS_LPN_TRX with exception from_mti= trx_hdr_id=21406655

D) There are no Inventory locks in the database:

desc MTL_ONHAND_LOCK_TEMP
>> table empty.

Packages INV_TABLE_LOCK_PVT are valid per Apps Check:

INV_TABLE_LOCK_PVT INVLOCKS.pls 115.0.115100.10 SPEC VALID
INV_TABLE_LOCK_PVT INVLOCKB.pls 115.1.115100.13 BODY VALID

 

E) Checking for file version in the database results in similar Java error:

Execute the following commands:

set serveroutput on
1) execute fnd_aolj_util.getClassVersionfromDB('oracle.apps.inv.transaction.server.TrxProcessor');
2) execute fnd_aolj_util.getClassVersionfromDB('oracle.apps.inv.transaction.server.QtyManager');

You get similar results when you execute commands:

1) execute fnd_aolj_util.getClassVersionfromDB('oracle.apps.inv.transaction.server.TrxProcessor');

Exception in thread "Root Thread" java.lang.VerifyError: (class:
oracle/apps/inv/transaction/server/TrxProcessor, method: createTrx signature:
(Ljava/sql/ResultSet;)Loracle/apps/inv/transaction/server/BaseTransaction;)
Wrong return type in function
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:187)
at oracle.apps.fnd.common.VersionInfo.displayClassVersion(VersionInfo.java:318)
at oracle.apps.fnd.common.VersionInfo.displayClassVersion(VersionInfo.java:300)
at oracle.apps.fnd.common.VersionInfo.displayClassVersion(VersionInfo.java:291)
BEGIN fnd_aolj_util.getClassVersionfromDB('oracle.apps.inv.transaction.server.TrxProcessor'); END;

*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.VerifyError: (class: oracle/apps/inv/transaction/server/TrxProcessor,
method: createTrx signature:
(Ljava/sql/ResultSet;)Loracle/apps/inv/transaction/server/BaseTransaction;)
Wrong return type in function
ORA-06512: at "APPS.FND_AOLJ_UTIL", line 126
ORA-06512: at "APPS.FND_AOLJ_UTIL", line 137
ORA-06512: at line 1

Changes

No changes, no patches applied

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