Views not available in Oracle

book

Article ID: 143146

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Identity Suite

Issue/Introduction

We were using below query to get report from MS-SQL and now we migrated to oracle. As per Engineering team, oracle do not contain any views in it so can you please help us to get below query data.

refer Ticket Case#20164672 for engineering team confirmation on view.

Query1: SELECT FieldValue1 AS SalesID, ResName1 AS Res1, ResName2 AS Res2, ResName3 AS Res3, FieldValue3 AS Universe FROM [ig_sdb].[dbo].[SAGE_RESOURCES_FULL_VIEW] WHERE FieldValue1 IN (${lowes.sales.id})

Query2:   SELECT
[RoleName],[ResName1],[ResName2],[ResName3] FROM
[ig_sdb].[dbo].[SAGE_LINKS_ROLE_RESOURCE_VIEW]
WHERE RoleName like
'%Disconnected%'

 

could you please help us to identify the tables in oracle from where we will get this data. 

Details about environment:

Identity Governance 14.2 Virtual Appliance 

oracle 12cR2

Environment

Release : 14.2

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Resolution

It has been confirmed by Engineering that the product is shipped with views only when SQL Server is used as a DB. We don't have any views in Oracle.
Therefore it is expected not to see any views in the local setup you are currently running with.