GPAUS: Getting A SQL Error When Running The STP Preparation Process
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.
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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms