ERE: RE_GENTRANS Goes To No Success Because Of RE_UTILITIES Related Error. (Doc ID 1600738.1)

Last updated on OCTOBER 11, 2016

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 8.9 and later
Information in this document applies to any platform.
*** Currency Check 07-May-2015 ***
*** Currency Check 11-Oct-2016***

Symptoms

When running RE_GENTRANS, we get the following error message:

PeopleTools 8.52.09 - Application Engine Server
Copyright (c) 1988-2013 Oracle and/or its affiliates.
All Rights Reserved

PSAESRV started service request at 12.18.39 2013-06-17

Error committing work. The host environment could not complete the CommitWork() function. (2,712) RE_UTILITIES.KeyGenerator.OnExecute Name:RestoreEntity PCPC:4847 Statement:83
Called from:RE_UTILITIES.KeyGenerator.OnExecute Name:GenerateBlockKeys Statement:28
Called from:RE_GENTRANS.INSTRNSB.GBL.default.1900-01-01.Step07.OnExecute Statement:4

Process 13646948 ABENDED at Step RE_GENTRANS.INSTRNSB.Step07 (PeopleCode) -- RC = 8 (108,524)

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

PSAESRV completed service request at 12.18.42 2013-06-17"

This issue occurs when there is no entry for "RE_LS_TXN" in RE_ENTITY_DEFN table which stores the last generated key value for the key fields of RE records.
As a workaround, please find out the maximum value for LS_TXN_ID field in RE_LS_TXN table and insert the same in the RE_ENTITY_DEFN table as :

ENTITY_NM : RE_LS_TXN
LASTGEN_KEY :

If no rows are found in RE_LS_TXN table then value of LASTGEN_KEY should be 0.

After insertion, please run the Transaction Generator application engine (RE_GENTRANS).


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