How may I see the data in the Oracle view like I see it through the application ?
Posted
by Luc M
on Stack Overflow
See other posts from Stack Overflow
or by Luc M
Published on 2010-05-03T21:31:05Z
Indexed on
2010/05/03
21:38 UTC
Read the original article
Hit count: 248
when I navigate through the Oracle application with my application user and the right responsibility, I see the data.
I use the "record history" menu to see which table/view is used by application.
So, I got PA_EXPEND_ITEMS_ADJUST2_V.
When I'm connected with apps user in a sqlplus session,
SELECT * FROM PA_EXPEND_ITEMS_ADJUST2_V
gives me 0 rows.
I guess that there's something is misconfigurated with the apps but what ?
How may I view the rows of PA_EXPEND_ITEMS_ADJUST2_V using apps user in a sqlplus session ?
How may I see the data in the Oracle view like I see it through the application ?
© Stack Overflow or respective owner
