Tag Archives: ORA-06502

ORA-06502 Saving Work Order

Problem: The following error is occurring:

The following errors occur when trying to update operations of Firm work orders:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at “APPS.FND_MESSAGE”, line 418

ORA-06512: at “APPS.FND_MESSAGE”, line 461

ORA-06512: at “APPS.FND_MESSAGE”, line 585

ORA-06512: at “APPS.FND_MESSAGE”, line 537

ORA-06512: at “APPS.APP_EXCEPTION”, line 42

ORA-06512: at “APPS.EAM_WORKORDER_UTIL_PKG”, line 1165

ORA-06512: at “APPS.EAM_OPERATIONS_PKG”, line 347

Steps to Reproduce Issue:

  1. Log on as user operations
  2. Enterprise Asset Management
  3. Work Orders > Work Order
  4. Seattle Maintenance
  5. WO90203
  6. Click Operations
  7. When the start and end time is changed, error occurs.

Solution: Apply Patch 4432063.

Refer to Metalink Doc ID: 357568.1 (Error ‘ORA-06502’ Occurs When Saving Changes To Work Order Operation)