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.
Expected to return HLS Case records where a contact of a specific type exists on HLS Case record.
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
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