Gantt Chart Display Error Message When Opening Gantt Chart From Ascp Exception Detail.

(Doc ID 1330460.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms


On : 12.1.3 version, Planner workbench

When attempting to complete Gantt Chart,
the following error occurs.

ERROR
-----------------------
error:ORA-06502:PL/SQL:numeric or value error:character string buffer too small
ORA-06512:at "APPS.MSC_GANTT_UTILS",line 9700
ORA-06512:at "APPS.MSC_GANTT_UTILS",line 10258
ORA-06512:at "APPS.MSC_GANTT_PKG",line 1644

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Check workbench plan via RESPONSIBILITY "Advanced Supply Chain Plan".
2. Select plan "P-110317-1 (UAT Test)"->click right button->Exceptions->Summary->Late replenishment for sales order->"Demand: Item" as "81-JN902.G02"->click right button->Gantt Chart
3. System showed error message as follow:
error:ORA-06502:PL/SQL:numeric or value error:character string buffer too small
ORA-06512:at "APPS.MSC_GANTT_UTILS",line 9700
ORA-06512:at "APPS.MSC_GANTT_UTILS",line 10258
ORA-06512:at "APPS.MSC_GANTT_PKG",line 1644

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete Gantt Chart.

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