PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

unable to create view using linked server

edited Jun 26, 2019 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

Using Sql server as our database server - Tools 8.55.21

trying to create view using linked server ;

SELECT EMPLID

,HIRE_DT

,EFFSEQ

,NAME

,EMPLID

,LOCATION

, EMPL_STATUS

,BUSINESS_TITLE

, WORK_PHONE

  FROM PSHRTST.dbo.PS_EMPLOYEES

error msg

SQL Build process began on 4/26/2018 at 11:19:54 AM for database PSFINTST.

Error: NJ_MIN_EMPL_VW - SQL Error. Error Position: 0  Return: 601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'PSHRTST.DBO.PS_EMPLOYEES'.

CREATE VIEW PS_NJ_MIN_EMPL_VW (EMPLID, HIRE_DT, EFFSEQ, NAME, BADGE_ID, LOCATION, EMPL_STATUS, BUSINESS_TITLE, PHONE) AS SELECT EMPLID ,HIRE_DT ,EFFSEQ ,NAME ,EMPLID ,LOCATION , EMPL_STATUS ,BUSINESS_TITLE , WORK_PHONE FROM PSHRTST.dbo.PS_EMPLOYEES

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