Work Order Cost Estimation Ends With Error Ora-12899 (Doc ID 1361568.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Cost Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to estimate for WO with direct item requirement related to closed PO, the following error occurs.

ERROR
-----------------------
ORA-12899: value too large for column "BOM"."CST_EAM_DIRECT_ITEMS_TEMP"."PO_CLOSED_CODE" (actual: 14, maximum: 10) in Package CST_eamCost_PUB Procedure Delete_eamBalAcct
Error: CST_eamCost_PUB.Insert_tempEstimateDetails() in Package CSTPECEP Procedure ESTIMATE_WORKORDER(37):

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