GPAUS: Getting A SQL Error When Running The STP Preparation Process

(Doc ID 2407433.1)

Last updated on JUNE 05, 2018

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

STATEMENT:
========
Getting a SQL error when running the STP Preparation process
We've applied selective fixes from PUM 26 to apply Single Touch Payroll in our development environment.
While running the STP Preparation process in our development environment, we're getting following error:

ERROR:
=======
File: E:\pt85519c-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 3086 Error Position: 0 Return: 601 -
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot find the object "PS_GPAU_STP_TMPA9" because it does not exist or you do not have permissions.
Failed SQL stmt: TRUNCATE TABLE PS_GPAU_STP_TMPA9
Temporary Table processing failure during allocation phase. (108,530)

STEPS TO REPLICATE:
==============
The issue can be reproduced at will with the following steps:
1.Navigate to Main Menu > Global Payroll & Absence Mgmt > Authority Correspondence > STP Payroll Event Prep AUS
2.Run STP Payroll Event Prep AUS process for one employee.
3.Application engine GPAU_STP_PRC failed with error.

Changes

 

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