My Oracle Support Banner

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 FEBRUARY 14, 2019

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.


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


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

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