ORA-00904 When Opening View on External Data Object that is Filtered Using Active Now

(Doc ID 748443.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Integration BAM - Version: 10.1.3.1
This problem can occur on any platform.

Symptoms

When opening a report with a view that has an Active Now filter with Active Now enabled on an external data object, you see the following: 

Exception Message
An error has occurred in the ADC storage system. ORA-00904: "52b3110c-de85-4bb3-b2fa-e932dd"."_Submitted_Date": invalid identifier

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