Forecast Set Form MRPFFDIF Errors ORA-6512 at APPS.MRP_MANAGER_PK Line 2270 When Querying Existing Forecast
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.
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
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