Database Adapter does not recognize Timestamp column (Doc ID 396348.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.2.0.2
This problem can occur on any platform.

Symptoms

BPEL database wizard shows an error at the Select Table view:

"Some tables contain columns that are not recognized by the Database Adapter,
so they will be captured as Strings: 

My_timestamp (TIMESTAMP(9))

To fix this problem, cancel this wizard, edit the Offline Table definition to
change the type of the above columns to that of the closest supported type, and
run the Database Adapter wizard again. Please consult the Database Adapter
documentation for detailed instructions on how to fix this problem."

.

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