My Oracle Support Banner

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 SEPTEMBER 05, 2018

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.