E-AD/SQL Server: Peoplesoft Resolving Sql, Which Has Schema Name, To All Upper Case, Causing Error When Trying To Execute It
(Doc ID 2439335.1)
Last updated on SEPTEMBER 05, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
On : 8.55 version, Application Designer - MS SQL Server
When attempting to build Record Views or use SQL objects that references records in other database instances, via linked servers, the following error occurs.
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The OLE DB provider "SQLNCLI11" for linked server "SLC11YUW" does not contain the table ""E920G7WE"."DBO"."PS_INSTALLATION"".
The table either does not exist or the current user does not have permission
The issue can be reproduced at will with the following steps:
1. Create a Record View with a SQL Text referencing a record in another database instance, via linked server
SELECT <field list>
SELECT AM, AP, AR
2. Try to build the Record View.
3. SQL Error occurs
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document