SQL Language (MOSC)

MOSC Banner

View working on APPS schema but not anther schema

edited Apr 23, 2020 12:12AM in SQL Language (MOSC) 8 commentsAnswered ✓

We  are using  R12.1.3 - with DB 11g.

Now we created  view  in APPS schema  - It is working

we give grant -select  read access for this view to  another schema OPNS

now  when do select statement from this view OPNS - getting error

---------------

internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. This indicated that a process encountered an exceptional condition.

----------------------------------

Please help us to fix this issue

Regards

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center