My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 8.9 and later
Information in this document applies to any platform.


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 :


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).




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.