SSHR Packages unable to read data from secure views occasianally
We have implemented SSHR long time before, we are facing issues with some of our transactions, upon investigation, we found that during runtime, the procedure was unable to fetch data when it is calling a secured view table and error with NO DATA FOUND.
ex; select name from per_vacancies
select name from per_requisitions
select * from per_positions
the data will not be avaible and the SSHR transaction completes in error, solution for this would be change the views to the ALL tables like per_all_positions. I raised an SR, not recived a good response, do you have any idea why this is happening.???