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

Last updated on JANUARY 26, 2024

Applies to:

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

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