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.
Hi let ,me know if you are interested in blogging professionally for a company
ReplyDeletedrop me a mail for details (kmihir@gmail.com)
Hi,
ReplyDeleteThanks for your Very informative article.
Oracle WebADI Dependent Download Parameters. Need Sample
Could you please let me know how do we create DEPENDENT parameters in webADI (DOWNLOAD). This is a urgent requirement. I could find samples for dependent Lovs in the WebADI sheet.(Usage of three java files as in this article.). How do we use this for Download parameters.
Requirement
Parameter1 : Grade Name
Parameter2: Grade Step (This should be dependent on Grade Name. i.e., It should list Grade Steps belonging to that particular Grade alone.)
Now based on these 2 parameters my content view query would fetch and display records in the webADI sheet. In which the use can update and then upload. We use $FLEX$.value set in the Concurrent programs types. But how do we implement the same in webADI input parameters.
Hi,
ReplyDeleteCan you please share the details how to restrict the LOV values with distinct values without repeating the same values