Creating a Value set for the supplier’s name as LOV

 

Creating a Value set for the supplier’s name as LOV for which in DFF we have done restriction to display only 120 characters only:  (Use the Substring function while creating Value set.)

 

The value set BSP_VENDOR_NAME cannot be assigned to the global segment Vendor. (FND-2627)
In application 667 and descriptive flexfield QP_PRICE_LIST_CHARGES_FLEX, value set BSP_VENDOR_NAME cannot be assigned to global segment Vendor which uses column ATTRIBUTE_CHAR1. The assigned value set must have a data type that is compatible with the column data type and its maximum length must be no longer than the column length and its validation type must not be view object.

Issue : Value Column Length:360

Solution:

From Clause : POZ_SUPPLIER_V

value column name: Substr(vendorname,1,120)

If you want to display the inventory orgs as values set please refer below setup

From Clause : INV_ORG_PARAMETERS

value column name: ORGANIZATION_CODE