E-AE: Online Application Engine Program Fails with Error: Temporary Table processing failure during allocation phase. (108,530) (Doc ID 780695.1)

Last updated on FEBRUARY 14, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 to 8.49 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 10-Apr-2014***


Symptoms

Statement of what the issue is in this FSCM 8.9 Environment.  (Could be any FSCM/HCM/CRM environment on any release, and could be with any Application Engine program that is run online.)

In this situation the PO_REQCANCEL Application Engine, which is launched in the online system via the CallAppEngine, fails and will not run.

When attempting to use the functionality that launches the PO_REQCANCEL Application Engine via CallAppEngine, the following error occurs:

ERROR
-----------------------
Popup Errors;

SQL error. Stmt #: 2677 Error Position: 12 Return: 942 - ORA-00942: table or view does not exist

Followed by;

DELETE FROM PS_REQ_CHG_HDR_T4 WHERE PROCESS_INSTANCE >= 0

And;

Temporary Table processing failure during allocation phase. (108,530)

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