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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!