Building The Create And Alter Scripts Error: Numeric Truncation PS_AUC_TREE_NODE:TREE_NODE_ID (Doc ID 2215753.1)

Last updated on DECEMBER 19, 2016

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Upgrade

When upgrading from FSCM 9.1/8.53 to 9.2 PI19 /8.55.08. When running the step 'Building the Create and Alter Scripts' there will be 2 records in error that will not alter: Error: PS_AUC_TREE_NODE - Field TREE_NODE_ID requires truncation with numeric data loss. Record skipped. Also occurs for PS_AUC_CATEGRY_HDR:TREE_NODE_ID. The data in this field contains numbers that are 4 digits long, but the field in Application Designer allows only 3 digits. In 9.1 the field length for TREE_NODE_ID is 6 digits and this has changed to 3 digits in 9.2.

ERROR
--------
Error: PS_AUC_TREE_NODE - Field TREE_NODE_ID requires truncation with numeric data loss. Record skipped


Steps to reproduce the issue:
1. After upgrading from 9.1 to 9.2
2. Run the Building the Create and Alter Scripts
3. Getting error message


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