Move Order Transactions APP-FND-01388: Cannot read value for profile option INV_DEBUG_TRACE in routine &ROUTINE ORA-20000: MTL_MMTT_T:S12:ORA-06508: PL/SQL: could not find program unit being ca (Doc ID 1520166.1)

Last updated on MAY 15, 2016

Applies to:

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

Symptoms

On : 12.0.6 version, Inventory Transactions

Move order transactions

Can not transact sales order

gets error message:
APP-FND-01388: Cannot read value for profile option INV_DEBUG_TRACE in routine &ROUTINE.
--------------------------------------------------------------
ORA-20000: MTL_MMTT_T:S12:ORA-06508: PL/SQL: could not find program unit being ca
ORA-06512: at "APPS.MTL_MMTT_T", line 647
ORA-04088: error during execution of trigger 'APPS.MTL_MMTT_T'
--------------------------------------------------------------
FRM-40509: ORACLE error: unable to UPDATE record
 

From Inv_Trace.log, see INV_TRX_UTIL_PUB.CALL_RCV_MANAGER: Unexpected Error occurred - ORA-06502: PL/SQL: erro: character string buffer too small



ERROR
-----------------------
APP-FND-01388: Cannot read value for profile option INV_DEBUG_TRACE in routine &ROUTINE.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Attempt to transact MO


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