Human Capital Management - EBS (MOSC)

MOSC Banner

SSHR Packages unable to read data from secure views occasianally

edited Jun 7, 2012 3:12AM in Human Capital Management - EBS (MOSC) 4 commentsAnswered
Hello Friends,

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

Tagged:

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