Service: Select from CS_INCIDENTS_B_SEC Returns No Rows
Last updated on FEBRUARY 23, 2017
Applies to:Oracle Teleservice - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 10-Sep-2013***
In E-Business Suite 220.127.116.11 there is a synonym APPS.CS_INCIDENTS_B_SEC for table
This synonym is referenced by CS_INCIDENTS_VL_SEC, which is referenced in csd_incidents_v.
A query in SQL Plus, Toad, or SQL Developer against csd_incidents_v does not return rows.
As APPS user from SQL Plus, Toad, or SQL Developer:
1) Rows exist for CS.CS_INCIDENTS_ALL_B, but selecting from synonym APPS.CS_INCIDENTS_B_SEC returns no rows.
2) Cannot see the synonym in the schema browser
WHAT IS WORKING
- Select statement against CS.CS_INCIDENTS_ALL_B => rows are returned
- Synonym APPS.CS_INCIDENTS_B_SEC can be seen
- Select statement against APPS.CS_INCIDENTS_B_SEC => rows are returned
-- Steps To Reproduce:
- Set up Service Security
- Run a query against APPS.CS_INCIDENTS_B_SEC as APPS.
- No rows are returned.
- Run the same query against APPS.CS_INCIDENTS_B_SEC as SYS and rows are returned.
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