EGL9.2: When Running Allocation The Process ABENDED at Step FT_TREESEL.uStats.uStats

(Doc ID 2154733.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Allocations

When attempting to run the below processes, both are failing with the error mentioned:

- the Allocation process ran to No Success when trying to update statics on a table after applying PUM13;

- the SEC_BLD application engine ran to No Success when tree data ( or some other data) results in table having less than 5000 rows - so UpdateStats is not being called from (FT_TREESEL.Ranges.uStats) (Do When)

Application Engine: FT_TREESEL Section: uStats STEP: uStats Action:SQL
%UpdateStats(%Bind(FT_TSEL_WRK_AET.RECNAME_SEL_TBL, Noquotes))

Exception from Message Log:
Process 445837 ABENDED at Step FT_TREESEL.uStats.uStats (SQL) -- RC = ?

Trace information of the sql that failed:
-- 15.26.53 ....................(FT_TREESEL.uStats.uStats) (SQL)
RECSTATS PS_SAMDIFF_ERROR('UPDATESTATS: Cannot locate record definition') LOW
-- 15.26.53 Process 445837 ABENDED at Step FT_TREESEL.uStats.uStats (Action SQL) -- RC = ?

The issue can be reproduced at will with the following steps:
1. Navigate to Allocations > Define and Perform Allocations > Request Allocation and run Application Engine program FS_ALLC.


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