ETL9.1: Bundle 23 For 9.1 Error: GPBR_ESOC_PARAM. Return: 942 - ORA-00942: table or view does not exist. Statement: select a.enabled from PS_GPBR_ESOC_PARAM A

(Doc ID 2229472.1)

Last updated on MARCH 17, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Technical

Bundle 23 for 9.1 Error: GPBR_ESOC_PARAM

Bundle #23 for 9.1 delivers PeopleCode (DERIVED_SC_BRA.SHIFT_TYPE_DTL_BRA.RowInit Record PeopleCode) that is giving an error when Payroll tries to pull up the Setup HRMS ==> Product Related ==> Time and Labor ==> Schedules>Definitions page. The App Server log shows:

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

Error Position: 22
Return: 942 - ORA-00942: table or view does not exist
Statement: select a.enabled from PS_GPBR_ESOC_PARAM A
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 that is giving an error when Payroll tries to pull up the Setup HRMS ==> Product Related ==> Time and Labor ==> Schedules>Definitions page.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms