EAP Brazil Localization and Core: Reset Tree Node Gaps Process Goes To No Success With Error (Doc ID 2142060.1)

Last updated on JUNE 14, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management Brazil - Version 9.1 and later
PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the 'Reset Tree Node Gaps' process the following error occurs:

"ORA-01407: cannot update ("SYSADM"."PSTREENODE"."PARENT_NODE_NUM")"

STEPS
1. Login to PIA
2. Navigate to Tree manager > Tree Utilities
3. Run the 'Reset Tree Node Gaps' process for multiple trees
4. The error occurs

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