Forecast Set Form MRPFFDIF Errors ORA-6512 at APPS.MRP_MANAGER_PK Line 2270 When Querying Existing Forecast (Doc ID 730103.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

The following issue has been found to occur in Apps 12.0.4/12.0.6 and 12.1 - When attempting to query a previously entered forecast in the Forecast Set form in the MRP module the following error occurs

ORA-06502: PL/SQL: numeric or value error, character string buffer too small
ORA-06512 at APPS.MRP_MANAGER_PK line 2270
FRM-40505: ORACLE error unable to perform query.

The issue can be reproduced at will with the following steps:
1.  Navigate Material Planner/Forecast/Forecast Sets
2. Try to query an existing forecast with existing entries
3. Errors occur



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