IF ANY TABLE(S) HAS TIMESTAMP COLUMN, NOT WORKING IN EXTERNAL DATA SOURCE IN BAM (Doc ID 977493.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Integration BAM - Version: 10.1.3.3 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms


You have created a Data Object that use an External Data Source pointing to an Oracle table that's using a TimeStamp column.  However any attempt to insert data into the table returns a BAM Dashboard error indicating the Data Boject is not reachable, for example:

ADC Server exception in OpenViewset().

Details <<

ADC Server exception in OpenViewset().
Source: "ActiveDataCache" ID: "ADCServerException"

ERROR - no error information available
Source: ""

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