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 and later
Information in this document applies to any platform.


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


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