Siebel View Based On A Oracle Sql View Does Not Return Any Result.

(Doc ID 2351512.1)

Last updated on JANUARY 22, 2018

Applies to:

Siebel Tools - Version 8.0.0.13 SIA [20448] and later
Information in this document applies to any platform.

Symptoms

On : 8.0.0.13 SIA [20448] version, Loyalty

ACTUAL BEHAVIOR
---------------
Siebel view based on a Oracle sql view does not return any result.

Created a Siebel view based on a Oracle SQL view, IN THE SIEBEL schema, but this one does not return anything.
Created a table via "External Table Schema Import" in tools, typed as "Exernal view", because it's a Oracle view (cf: https://docs.oracle.com/cd/B40099_02/books/EAI2/EAI2_ExtBusComps3.html)
But the view is display but empty.
When trace/log is enabled, there is a select from the Oracle view. if this sql is copied and pasted from the trace file to SQL Developer, there is something (it's NOT empty).
However, nothing displayed in Siebel client.

EXPECTED BEHAVIOR
-----------------------
Siebel view based on EBC of Oracle SQL View should retrieve the data, similar to what is seen via SQL developer.


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