My Oracle Support Banner

SQL Error On GVT_JOB_PRT_VW2 Business Unit AUS01 (Doc ID 2578134.1)

Last updated on JULY 21, 2020

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a report, the following error occurs.


Navigation

Workforce Administration-->Job Information-->Report-->Notice of Personnel Action USF

ADD New Runctrol ID and Enter Business unit as AUS01 

Select Processed by Human Resources and Enter Begin Date example: 07/01/2019 and End Date as: 08/06/2019 and

Click on Filter Push Button you will get following error


ERROR
-----------------------

File: /vob/peopletools/src/psppr/ramget.cppSQL error. Stmt #: 709 Error Position: 222 Return: 904 - ORA-00904: "BUSINESS_UNIT": invalid identifier
Failed SQL stmt: SELECT EMPLID, EMPL_RCD, TO_CHAR(EFFDT,'YYYY-MM-DD'), EFFSEQ, NAME, SSN, GVT_NOA_CODE, DEPTID, LOCATION, GVT_PAR_CUR_STATUS, TO_CHAR(GVT_DATE_WRK,'YYYY-MM-DD'), GVT_WIP_STATUS, GVT_WIP_RECORD FROM PS_GVT_JOB_PRT_VW2 where business_unit like :1 and gvt_wip_status = :2 and gvt_date_wrk between TO_DATE(:3,'YYYY-MM-DD') and TO_DATE(:4,'YYYY-MM-DD')



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.