TriniDBA

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)