My Oracle Support Banner

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 JANUARY 01, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.