My Oracle Support Banner

Min-Max Planning Report (INVISMMX) Failing with Error ORA-06502 in Procedure INV_MMX_WRAPPER_PVT.exec_min_max (Doc ID 1281032.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Report: INVISMMX.RDF - Min-max planning report

Symptoms

Min-max planning report (INVISMMX) completes with Error status, no report output gets generated and the below error is shown in the request log.

Error
"MSG-00070: INV_MMX_WRAPPER_PVT.exec_min_max returned error:ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package INV_MMX_WRAPPER_PVT"

Steps
The issue can be replicated with the below steps:
1. Select your Inventory responsibility
2. Go to Inventory: (N) Planning : Min-Max Planning
3. Select your organization in Change Organization window if you are prompted for this
4. In Parameters window, keep all defaulted values
5. Submit
6. See the concurrent request completed with Error status
7. See the following in the request log:
[
MSG-00069: Calling INV_MMX_WRAPPER_PVT.exec_min_max from Before Report Trigger
MSG-00070: INV_MMX_WRAPPER_PVT.exec_min_max returned error:ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package INV_MMX_WRAPPER_PVT Procedure EXEC_MIN_MAX
REP-1825: Before Report trigger returned FALSE.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1825: MSG-00069: Calling INV_MMX_WRAPPER_PVT.exec_min_max from Before Report Trigger
MSG-00070: INV_MMX_WRAPPER_PVT.exec_min_max returned error:ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package INV_MMX_WRAPPER_PVT Procedure EXEC_MIN_MAX
REP-1825: Before Report trigger returned FALSE
.
]

Changes

The problem would surface when trying to implement the Min-max planning functionality for the first time or for a newly created Inventory organization.

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
 Cause #1 - Missing customer address / location association
 Cause #2 - Missing Financial Options or missing profile setting
 Cause #3 - Large key flexfield structure
Solution
 Solution for cause #1 - Missing customer address / location association
 Solution for cause #2 - Missing Financial Options or missing profile setting
 Solution for cause #3 - Large key flexfield structure
References


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