My Oracle Support Banner

E-COB: Cobol Process Fails With Error Message 'ORA-00903: Invalid Table Name' After PUM Upgrade and Applying Tax Update (Doc ID 3011694.1)

Last updated on JUNE 10, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Symptoms

After upgrading to HCM 9.2 PUM image 46 and applying Tax Update 24A, when trying to run PSPPYRUN or any payroll process, it is failing with the following error in CBL_PSPPYRUN_xxxxxxx.log:

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 00903
Error Message : ORA-00903: invalid table name
Stored Stmt : PSPLDTL2_U_TRUNC
SQL Statement : TRUNCATE TABLE .PS_PY_PYBL_TM_WRK

It looks to be missing the SYSADM in the TRUNCATE statement.

The stored statement is failing even though the record (PS_PY_PYBL_TM_WRK) is present in the database.

Environment
-------------
PeopleTools 8.57.21
HCM 9.2 PUM 46
Visual Cobol 6.0
Red Hat Enterprise Linux 7.0

Sample Replication
------------------

1. Run any payroll cobol process like PSPPYRUN.
2. Observe the error above.

Changes

HCM 9.2 PUM 46 Upgrade and applying Tax Update 24A.

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.