How to Create Dependent Table Value set in Oracle Fusion

 
 
Dependent Table Value set in Oracle Fusion:
 
 

Hi friends , we all know that in Oracle Apps R12 we creates dependent value set through $Flex command but in Fusion this thing has been changed now. Here we use some different syntax to create Dependent table value set.

 

 

If you need to validate the input against a list of values from an application table, then create a value set with the Table validation type. You define which table you want to use and you specify the column that contains the valid value. You can optionally specify the description and ID columns, a WHERE clause to limit the values to use for your set, and an ORDER BY clause.

 

1. :{SEGMENT.segment_code}  :- If you want to show the Table valueset value based on the Value selected in your Descriptive Flex Field Segment. Then you can use this System. Where in this syntax segment_code is the name of the DFF segment.

 

 

2.:{VALUESET.value_set_code} :- if you want to show the Table valueset value based on the value selected in other value set in your web-page. you can use this syntax.

 

3.:{FLEXFIELD.internal_code} :- This bind variable refers to an internal code of the flexfield in which the value set is used, or to a validation date.

 

The internal_code could be

 

APPLICATION_ID — the application ID of the flexfield in which this value set is used. The data type of APPLICATION_ID and its resulting bind value is NUMBER

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

DESCRIPTIVE_FLEXFIELD_CODE — the identifying code of the flexfield in which this value set is used. The data type of DESCRIPTIVE_FLEXFIELD_CODE and its resulting bind value is VARCHAR2. Note that you use this string for both descriptive and extensible flexfields.


CONTEXT_CODE — the context code of the flexfield context in which this value set is used. The data type of CONTEXT_CODE and its resulting bind value is VARCHAR2.


SEGMENT_CODE — the identifying code of the flexfield segment in which this value set is used. The data type of SEGMENT_CODE and its resulting bind value is VARCHAR2.  

4:-:{PARAMETER.parameter_code}:- If you want to show your table value set values based on the value selected in the fields of your web-page backend table then you can use this syntax.