CostCodeEntityBean.ejbLoad() failed; Error when Adding or Modifying a Cost Code (Doc ID 904950.1)

Last updated on JULY 05, 2016

Applies to:

Primavera Contract Management - Version 10.0 and later
All Platforms
Cost code definitions are an optional feature that enable you to sort and display cost information in custom reports.

When you add a cost code, you can refer to the cost code definition structure established by your organization to properly format the complete cost code.

Creating cost codes that conform to an established cost code definition format enables you to use the definitions to customize cost reports by filtering, sorting, and grouping on any part of your definition. See the Contract Management User Guide or online Help within the application for more information about cost code definitions and cost codes.

Columns that represent the cost code definitions are placed on the CSMT_TABLE and the CSMT view. If the same exact cost code definition columns do not appear on both the CSMT_TABLE and the CSMT view errors will result when attempting to add a new cost code or edit an existing cost code.

Symptoms

EJBException error after selecting Add Cost Code:  EJBException:; nested exception is: javax.ejb.EJBException: CostCodeEntityBean.ejbLoad() failed;

INFO [STDOUT] (http-80-2) ERROR - DatabaseMgrDAO..executeQueryObject(String,int) SQLException :
ERROR [STDERR] (http-80-2) com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name '<name of bad column>'.

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