ETL9.1:Batch Approval Abend With Return: 8007 Error - Insufficient Memory Available in TL_APPRV_AE.SetTerm Section (Doc ID 1370947.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

  On: 9.1 version, batch approvals:

When attempting to run batch approval process, the process abends with the following error:

ERROR
-----------------------
The batch approval abended with the following error when ran for larger group:

SQL error. Function: CreateSQL
Error Position: 28
Return: 8007 - Insufficient memory available
Statement: select distinct(eoawstep_staTUS) FROM PS_EOAW_STEPINST WHERE EOAWPRCS_ID = :1 AND EOAWDEFN_ID = :2 AND EFFDT = TO_DATE(:3,'YYYY-MM-DD') AND EOAWSTAGE_NBR = :4 AND EOAWTHREAD_ID IN (SELECT EOAWTHREAD_ID FROM PS_TL_APP_PAY_XRF WHERE EOAWPARENT_THREAD = :5)
Original Statement: select distinct(EOAWSTEP_STATUS) from PS_EOAW_STEPINST where EOAWPRCS_ID = :1 and EOAWDEFN_ID = :2 and EFFDT = %DateIn(:3) and EOAWSTAGE_NBR = :4 and EOAWTHREAD_ID in (select EOAWTHREAD_ID from %table(:5) where EOAWPARENT_THREAD = :6)

SQL error in Exec. (2,280) EOAW_CORE.ENGINE.StageInst.OnExecute Name:status PCPC:25887 Statement:404
Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:CheckIfComplete Statement:870
Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:TerminateLine Statement:1020
Called from:EOAW_CORE.ApprovalManager.OnExecute Name:DoLineTerminate Statement:166
Called from:HMAF_AWE.WRAPPERS.ApprovalManager.OnExecute Name:DoLineTerminate Statement:75
Called from:TL_APPRV_AE.SetTerm.GBL.default.1900-01-01.Step

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 16.42.35 2011-10-18


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create payable time for approval
2. Run batch approval process
3. The process abends with above error message.


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