EGL9.2: SQL Error: ABENDED At Step OI_TFLT_PRCS.uLvlNd.uLvlNd (SQL) -- RC = 8601 (108,524) When Running Tree Flattener Process On Sql Server Platform

(Doc ID 1675532.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

CUSTOMER ENVIRONMENT
==========================
Application release 9.2
Image   unknown

PeopleTools 8.53
Environment Production after upgrading to 9.2

Platform/HW Arch: Microsoft Windows x64 (64-bit)
Platform Ver: 7
DB: Microsoft SQLServer
DB Ver: 2008 SP2
DB Platform: Microsoft Windows x64 (64-bit)
DB Platform Ver: 2008 R2



ISSUE
=========
After upgrading to FSCM 9.2, then specify the Tree Fields at Set Up Financials/Supply Chain> Operational Reporting > Tree Flattener > Tree Fields and submit the Tree Flattener process for the ACCOUNT tree at Set Up Financials/Supply Chain> Operational Reporting >Tree Flattener> Tree Flattener Request, a process error is received.

ERROR MESSAGE
===============
Process 14990 ABENDED at Step OI_TFLT_PRCS.uLvlNd.uLvlNd (SQL) -- RC = 8601 (108,524)


EXPECTED RESULTS
==================

Tree flattener will complete successfully


ACTUAL RESULTS
==================
Tree flattener fails with sql error when run on sql server

BUSINESS IMPACT
================
Can not successfully run tree flattener on sql server

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