Oracle Cloud ERP -Fusion (SaaS) – ValueSet Creation and Query to extract

Steps to Create

As an administrator, here’s how you can create/view the ValueSet

  1. In the Setup and Maintenance work area, go to:
    • Task: Manage Value Sets
  2. Click on + , in search Results to create
--Types of Value Sets
SELECT distinct validation_type , decode(validation_type  
              ,'I' ,'Independent'  
              ,'D' ,'Dependent'  
              ,'N' ,'None'  
              ,'P' ,'Pair'  
              ,'U' ,'Special'  
              ,'F' ,'Table'  
              ,'X' ,'Translatable Independent'  
              ,'Y' ,'Translatable Dependent') validation_type  FROM  FND_FLEX_VALUE_SETS ; 

--Value Set Details
 SELECT FFVS.flex_value_set_id, ffvs.flex_value_set_name, ffvs.description, ffvs.validation_type
 FROM  FND_FLEX_VALUE_SETS FFVS; 

 --Table Type Value Set Query Details
 SELECT  
  ffvs.flex_value_set_name, fvvt.from_clause, fvvt.where_clause, fvvt.order_by_clause
 FROM FND_VS_VT_TABLE_EXT  FVVT , FND_FLEX_VALUE_SETS FFVS
 where 1=1
 and fvvt.value_set_id = ffvs.flex_value_set_id;  
 

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleCloud