My Oracle Support Banner

Error APP-FND-01564: ORACLE Error 1480 In CREDEFCLD When Adding Value Into Independant Value Set. (Doc ID 2029267.1)

Last updated on FEBRUARY 05, 2023

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:


Getting APP-FND-01564: ORACLE error 1480 in CREDEFCLD while adding values in value set.
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: 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 &ERRFILE.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.