ERE: RE_GENTRANS Goes To No Success Because Of RE_UTILITIES Related Error.
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***
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
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms