Close Requisitions (PO_REQRCON) Process Abends at Step RX42000.AWESTEP with Insufficient Memory Available Statement (Doc ID 1443573.1)

Last updated on DECEMBER 15, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


When attempting to run a Close Requisition Process the following error occurs.

Error:

SQL error. Function: Rowset.Fill Error Position: 28 Return: 8007 - Insufficient memory available Statement: select message_seq from ps_mESSAGE_LOG WHERE PROCESS_INSTANCE =:1 AND MESSAGE_SEQ = :2 FOR UPDATE OF PROCESS_INSTANCE Original Statement: %SelectByKeyRLR(:1)

Fatal SQL error occurred. (2,125) EOAW_CORE.ENGINE.PathInst.OnExecute Name:Retrieve PCPC:827 Stat ement:10 Called from:EOAW_CORE.ENGINE.StageInst.OnExecute Name:RetrievePaths Statement:121 Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:RetrieveStages Statement:372 Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:InitByThread Statement:109 Called from:EOAW_CORE.DEFN.AWTxn.OnExecute Name:GetEndedAppInst Statement:72 Called from:EOAW_CORE.ApprovalManager.OnExecute Name:ApprovalManager

PO_REQRCON.RX4200.AWESTEP (PeopleCode), RC = 24

359970 PO_REQRCON RX4200 AWESTEP PeopleCode 24

Steps to Replicate Issue:

1. Navigate to Main menu: Purchasing > Requisitions > Reconcile Requisitions > Close Requisitions
2. Select Requisition Run Option as 1 BU Unit and Click on Run
3. Check the Process PO_REQRCON
4. Check the Message Log and you will see the error

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