My Oracle Support Banner

Service: Select from CS_INCIDENTS_B_SEC Returns No Rows (Doc ID 786828.1)

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 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

- 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.


To view full details, 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 a vibrant support community of peers and Oracle experts.