Generate Budget From Workplan Resources Errors - ORA-06502 ORA-06512: at "APPS.FND_MESSAGE (Doc ID 1372087.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Sep-2013***
Checked for relevance on 08-JUN-2015

Symptoms

Generating a budget from workplan.

Planning options for generating the revenue., generate a budget by Resource Class, left the Employee and Job fields blank in the Rate Schedules Screen.

Generating budget gives unexpected error.
Details shows:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502:
PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_MESSAGE", line 943
ORA-06512: at "APPS.FND_MESSAGE", line 904
ORA-06512: at line 1


If  you select Employee and Job fields ( not leaving this as blank) generation process works.

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