My Oracle Support Banner

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

Last updated on MAY 19, 2018

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


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.