EWO Equipment Installation Data-Related Error for ORA-12899: value too large for column "ASAP"."EQUIPMENT"."WORK_ORDER_NUMBER" (Doc ID 2195182.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Symptoms

An ORA-12899 error is thrown when attempting to install new equipment via an Engineering Work Order where the length of the order's Work Order Number field exceeds 15 characters. Below are the errors displayed in the GUI in the order they are received.


Complete text of first error

Images of the errors in the order they are received.  The first image highlights the Work Order Number field value that is mapped over from the EWO order and causing the "ORA-12899: value too large for column" error..

Recreation steps

The issue can be reproduced at will with the following steps:

1. Create a new Engineering Work Order and edit the Work Order Number field with a value using its limit of 17 characters

2. Click the Manage Equipment link

3. Click the Install Equipment link

4. Query for a Network Location to install new equipment

5. Right click in the Equipment Inventory window and select "Add"

  * Note the value in the Work Order Number field within the data window has been mapped over from the EWO

6. Enter the desired information and click OK to install the equipment. The errors are thrown here.


Business impact

New equipment cannot be installed using an EWO where the order's Work Order Number field exceeds 15 characters.

Changes

Cause

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