My Oracle Support Banner

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

Last updated on AUGUST 16, 2019

Applies to:

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

Symptoms

On : 9.2 version, Job / Personal Information

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


Navigates to Workforce Administration-->Job Information-->Report-->Notice of Personnel Action USF--> ADD New Runctrol ID and Enter Business unit as AUS01 and 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')



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