Security Data Objects Are Not Working With Objects That Use An External Data Source: java.sql.SQLSyntaxErrorException: ORA-00904: "_Column_Name": invalid identifier (Doc ID 1484666.1)

Last updated on JUNE 01, 2015

Applies to:

Oracle SOA Platform – BAM (Business Activity Monitoring) - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

A Security Filter was created on a Data Object that uses an External Data Source.
The second time we view the contents of a Data Objects that has the Security Filter defined we receive the following error in the BAM Console:

Oracle® Fusion Middleware Developer's Guide for Oracle SOA Suite 11g
Part Number E10224-15    
Creating Security Filters

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