My Oracle Support Banner

Getting Error "ORA-12906:error in materialized view log on "INV"."MTL_ONHAND_QUANTIIES_DETAIL" While Transacting Move Order (Doc ID 3002064.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Users unable to perform Move order transaction.Getting following error in Transact Move Order Form when trying to transact.

ERROR
-----------------------
Transaction processor error
Ex..in updateOnhand ..java.sql.SQLException: ORA-12906:error in materialized view log on "INV"."MTL_ONHAND_QUANTIIES_DETAIL" ORA-00606 :internal error code ,arguments :''kcl_mismatch_1],[nnnnnnn],[1],[0][0],[0],[],[],[],[],[],[]

The issue can be reproduced at will with the following steps:
1. Login to applications
2. Go to Inventory responsibility
3. Navigate to Move Orders >Transact Move Order



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.