Building The Create And Alter Scripts Error: Numeric Truncation PS_AUC_TREE_NODE:TREE_NODE_ID
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.
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: 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
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