[SQL Server Native Client 10.0][SQL Server]Invalid object name 'PS_OPRID_VW'.
Dear All
We are using PeopleSoft Financial and Supply Chain 9-2 with no image or zero image update. PT is 8.53 while SQL Server is 2012.
Recently, faced with the following error when trying to retriever user preferences from the menu kindly refer attached file for more information:
file: E:\pt85309d-retail\peopletools\src\psppr\ramget.cppSQL error. Stmt #: 656 Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'PS_OPRID_VW'. Failed SQL stmt: SELECT DISTINCT TOP 301 OPRID, OPRDEFNDESC FROM PS_OPRID_VW ORDER BY OPRID
Any further information you may require for resolution of this error, kindly don't hesitate to let me know.