Unable To Add/update BO On C1-TAXFORM Maintenance Object. (Doc ID 2262313.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Public Sector Revenue Management - Version 2.4.0.1.0 and later
Information in this document applies to any platform.

Goal

After upgrade to PSRM V2.4.0.1.0 when trying to add a new custom BO on C1-TAXFORM Maintenance Object, it is giving an error.

SYSUSER - 717513-2123-1 2017-04-25 12:17:18,178 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (jdbc.spi.SqlExceptionHelper) ORA-00904: "ILM_ARCH_SW": invalid identifier

SYSUSER - 717513-2123-1 2017-04-25 12:17:18,178 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (batch.internal.BatchingBatch) HHH000315: Exception executing batch [ORA-00904: "ILM_ARCH_SW": invalid identifier
]
SYSUSER - 717513-2123-1 2017-04-25 12:17:18,178 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.impl.QueryImpl) Error getting iterator on hibernate query 'from ObjectRevision objRev where objRev.maintenanceObject = :mo and objRev.businessObject.id = :boId and objRev.statusDateTime <= :dateTime and objRev <> :rev and objRev.primaryKeyValue1 = :pk1'
org.hibernate.exception.SQLGrammarException: ORA-00904: "ILM_ARCH_SW": invalid identifier
 

Create a new custom BO using C1-TAXFORM Maintenance Object

Due to this issue, users cannot create new BOs.
 

Solution

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