Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
DFF is not created when using value set with validation type "Table" — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DFF is not created when using value set with validation type "Table"

Received Response
34
Views
8
Comments
edited Mar 2, 2021 12:28PM in Self Service Procurement 8 comments

Summary

DFF not created when using value set with validation type "Table"

Content

Creating DFF to show department values on requisition page.

create a value set with validation type "Table". Using table "Per_Departments" to fetch "Name" whose datatype is varchar2(240).

create a DFF for Requisition header and use the value set. When trying to save DFF getting following error --

 
The value set KC_DEPTS cannot be assigned to the global segment Dept. (FND-2627)
In application 10071 and descriptive flexfield POR_REQUISITION_HEADERS, value set KC_DEPTS cannot be assigned to global segment Dept which uses column ATTRIBUTE2. 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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!