Error APP-FND-01564: ORACLE Error 1480 In CREDEFCLD When Adding Value Into Independant Value Set.
Last updated on MARCH 08, 2017
Applies to:Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.
When entering a value > 60 characters into the independent valueset, which is linked to a dependent valueset, the following error occurs:
Cause: CREDEFCLD failed due to ORA-01480: trailing null missing from STR bind value.
The SQL statement being executed at the time of the error was: INSERT /* $Header: fdfvsu.lc 120.8.12010000.4 2009/09/17 18:19:04 tebarnes ship $ */ INTO FND_FLEX_VALUES (FLEX_VALUE_SET_ID, PARENT_FLEX_VALUE_LOW, FLEX_VALUE_ID, FLEX_VALUE, SUMMARY_FLAG, FLEX_VALUE, SUMMARY_FLAG, ENABLED_FLAG, COMPILED_VALUE_ATTRIBUTES, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)VALUES(:value_set_id, :parent_value, :value_id, :dependant_default_value, :summary_flag, 'Y', :compvtv, SYSDATE, :user_id, SYSDATE, :user_id) and was executed from the file &amp;ERRFILE.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms