My Oracle Support Banner

Internal Exception: Java.sql.SQLSyntaxErrorException: ORA-00904: "CREATION_DATE": Invalid Identifier (Doc ID 2376593.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle SOA Suite - Version to [Release 11gR1]
Information in this document applies to any platform.


On : version, Mediator Service Engine

After applying Mediator Merge Patch 27254956 (MERGE REQUEST ON TOP OF SOA BP FOR BUGS 24795394 25736925 18599002 ), the mediator related composites are failing.

Below is the error that is seen in the in the soa server logs at the time of issue.

Caused By: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 ( (Build 111018)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "CREATION_DATE": invalid identifier

Error Code: 904
ENCING_LEVEL,CONTAINER_ID,RESEQUENCER_TYPE,TIMEOUT_DURATION,CREATION_DATE) values (?,?,?,?,?,?,?,systimestamp at time zone 'UTC',?,?,?,?,?,?)
  bind => [ItQJC235+7qaubQWKhiAytSwaDHdT+PMCGhne5XlIjI=, default/SyncAcctSiebelAggrEventConsumer!1.0/SyncAcctSiebelAggrEventConsumer_RS, receive, 1-1F3S
9V2, null, -1, null, 0, OPERATION_SEQUENCING, 7AADE9B1239411E8BFDD1DB62BFBAF02, FIFO, null, 2018-03-12 10:56:22.779]
Query: DataModifyQuery()
  at oracle.toplink.exceptions.DatabaseException.sqlException(
  at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(


To view full details, 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 a vibrant support community of peers and Oracle experts.