My Oracle Support Banner

Invalid SQL Generated When Enabling Org Visibility On Child BC (Doc ID 2639829.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Siebel CRM - Version 16.19 [IP2016] and later
Information in this document applies to any platform.

Symptoms

Expected to return HLS Case records where a contact of a specific type exists on HLS Case record.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


-Exposed the Organization MVL on the child BC HLS Case Contact
-Added the Organization record for the BC view mode
-HLS Case/HLS Case Contact link to always use organization visibility
-Compile to srf or deliver the workspace
-Login into Client
-Go to Cases> Case List
-Query in case Name as "EXISTS ([Case Contact Type] = "xyz")"

ObjMgrLog    Error    1    000000025e421d8c:0    2020-02-10 19:13:59    (oracon.cpp (4792)) SBL-DBC-00105: An error has occurred executing a Sql statement.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute    Execute    5    000000025e421d8c:0    2020-02-10 19:13:59    ORA-00904: "SIEBEL"."S_CONTACT"."ROW_ID": invalid identifier

Cause

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
Symptoms
Cause
Solution
References


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