view did not show data when loging with apps users
Our oracle ebs views are not showing data except we login with sys user (sysdba). suppose po_headers_v is not showed data when
we login with any user other than sys. Is there some grant privilleges issue.
2nd view example is RA_CUSTOMER_TRX_PARTIAL_V . both view has same behaviour but when we run oracle transaction(receivable)
form it shows data, actually this view is calling at that time.
db :11.1
apps: 12.1.3
os: sun solaris 10
Thanks