Interface property can be used to set the value set. This will provide list option in excel sheet and will have limitation on values.
Usages of component will provide standard EBS LOV option. Steps are as below -
1) Desktop Integration Manager (R) >> Manage Component >> Create Component
Provide display name, internal name and application.
Component Type:
LOV-Table -
Ø SQL details will be provided into interface column properties
Ø Component name should be provided in interface column properties
LOV-JAVA (Please click here)
Complete component details and apply.
Table_column-alias – Interface column name
Table_column – Value set column name (Meaning)
Table-select-column - Interface column name
Go to interface >> properties window and provide the component created.
