Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Miscellaneous
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 
An article on Value Sets, for beginners that follow http://getappstraining.blogspot.com
Question:
What is value set?
Answer: It is a set of values

Question: Why do we need value sets?
Answer: You do not always want a user to enter junk free text into all the fields. Hence, Oracle Apps uses value set to validate that correct data is being entered in the fields in screen.

Question: Is value set attached to all the fields that require validations?
Answer : A big NO

Question: Then where lies the usage of value sets?
Answer: Broadly speaking, value sets are attached to segments in Flexfields. You can argue that value sets are also attached to parameters of concurrent program(but in reality oracle treats parameters as Descriptive Flexfields)

Question: This is insane, flexfields haven’t been covered in http://getappstraining.blogspot.com as yet?
Answer: Agreed, hence let’s restrict value set explanation to their usage in concurrent program parameters.

Question: Any examples?
Answer: For the namesake, lets add a Parameter to the concurrent program that we defined in “Concurrent Program Training Lesson link”. Lets add a parameter named “cost centre”, the values to this parameter must be restricted to one of the three values, i.e. HR, SEC, IT.

At the time of submission of the concurrent program the user should be able to pick a cost centre from a list. This is where value set gets used.

Lets now define a simple value set as described above.

Step 1. Go to Application Developer, and select menu /Validation/Set
Image


Step 2. Now define a value set of type Independent. We will cover the other most widely used Type “Table” latter.
Image


Step 3. Now, lets add three independent values to the value set for this Cost Centre list. Hence click on menu Values within Validation
Image

Step 4. Here we add the values for IT, HR, SEC to this independent value set.
Image

“CONTROL-S” to save the data

Step 5. Now let us go back to Concurrent Program that we created in earlier training lesson and Click on Parameters
Image


Step 6. Now lets create a parameter, and attach the value set that we created to this parameter.
Image


Step 7.
Now to test this, lets go to receivables manager and click on Requests.
Image
Click on Request,

Step 8.
Submit New Request, and then click on OK.
Image


Step 9
Now, we can see the values defined in the value set here.
Image


Anil Passi

Overall Rating (0)

0 out of 5 stars

People in this conversation

  • hi anil
    once again i appreciate urs effort .but is these finicial stuff.please can u tell what r the question they would ask for specialy for oracle hrms functional consultant in london.i mean to say process of inteview .i have done my mba(hr) .is that to apply for oracle hrms in UK we should have previous UK experience please guide me .
    i will be waiting for urs reply
    thanks bye

    0 Like
    Short URL:
  • Hi Reddy,

    The rules of the game are the same weather in UK or US or in India.
    The best way to pass interviews is to impress them with your knowledge. To that effect you must do as much reading as possible. The interview questions are there to help you with some ideas. However the ingredient for guaranteed success is your knowledge.

    Thanks,
    Anil Passi

    3 Like
    Short URL:
  • hi anil
    once again i appreciate urs effort .but is these finicial stuff.please can u tell what r the question they would ask for specialy for oracle hrms functional consultant in london.i mean to say process of inteview .i have done my mba(hr) .is that to apply for oracle hrms in UK we should have previous UK experience please guide me .
    i will be waiting for urs reply
    thanks bye

    2 Like
    Short URL:
  • Hi Reddy,

    The rules of the game are the same weather in UK or US or in India.
    The best way to pass interviews is to impress them with your knowledge. To that effect you must do as much reading as possible. The interview questions are there to help you with some ideas. However the ingredient for guaranteed success is your knowledge.

    Thanks,
    Anil Passi

    13 Like
    Short URL:
  • thanks anil
    for valuable suggestion . if u have time can u please can u post interview questions for functional role for oracle hrms not payroll .becaz u have more idea .beacz i dont have previous experience in hrms .i am going to aplly for jobs these week.i will be happy if u can.
    thanks
    reddy

    0 Like
    Short URL:
  • thanks anil
    for valuable suggestion . if u have time can u please can u post interview questions for functional role for oracle hrms not payroll .becaz u have more idea .beacz i dont have previous experience in hrms .i am going to aplly for jobs these week.i will be happy if u can.
    thanks
    reddy

    0 Like
    Short URL:
  • ihave uderstand why oracle consider parameter as discriptive flexfield

    what i understand is because pop up window appear when u click on parameter or after selecting concurrent program

    my mistke less concentration

    regards and thaks
    balkrishna

    0 Like
    Short URL:
  • When you submit a concurrent program to run, Oracle lets you enter values into its Parameters.

    This happens becasue Oracle pops-up a small window that contains all the parameters for the concurrent program being submitted.

    That pop-up wnidow is nothing but a descriptive flexfield screen.

    Not much emphasis is needed on this topic, as Conc program parameters being Descriptive Flexfields is something that gets taken care of internally by Oracle.


    Many Thanks,
    Anil Passi

    0 Like
    Short URL:
  • i am not uderstand oracle treat parameter as discriptive field , what it means
    please advise

    0 Like
    Short URL:
  • ihave uderstand why oracle consider parameter as discriptive flexfield

    what i understand is because pop up window appear when u click on parameter or after selecting concurrent program

    my mistke less concentration

    regards and thaks
    balkrishna

    0 Like
    Short URL:
  • When you submit a concurrent program to run, Oracle lets you enter values into its Parameters.

    This happens becasue Oracle pops-up a small window that contains all the parameters for the concurrent program being submitted.

    That pop-up wnidow is nothing but a descriptive flexfield screen.

    Not much emphasis is needed on this topic, as Conc program parameters being Descriptive Flexfields is something that gets taken care of internally by Oracle.


    Many Thanks,
    Anil Passi

    1 Like
    Short URL:
  • i am not uderstand oracle treat parameter as discriptive field , what it means
    please advise

    0 Like
    Short URL:
  • Hi Anil,

    Great work yaar.....

    Rgds
    Shabeer.S

    0 Like
    Short URL:
  • Hi Shabeer

    See this link, its an article contributed by Rakesh

    http://getappstraining.blogspot.com/2006/12/value-sets-in-oracle-apps.html

    Thanks,
    anil Passi

    0 Like
    Short URL:
  • Hi Anil,

    If psbl. can u differentiate the value sets...(7 types).

    Regards
    Shabeer.S

    0 Like
    Short URL:
  • Hi Anil,

    Great work yaar.....

    Rgds
    Shabeer.S

    1 Like
    Short URL:
  • Hi Shabeer

    See this link, its an article contributed by Rakesh

    http://getappstraining.blogspot.com/2006/12/value-sets-in-oracle-apps.html

    Thanks,
    anil Passi

    0 Like
    Short URL:
  • Hi Anil,

    If psbl. can u differentiate the value sets...(7 types).

    Regards
    Shabeer.S

    0 Like
    Short URL:
  • Certanily you can.

    If your filteration is based on profile option, then I suggest neatest way would be to create a database view which performs the filteration of data[based on profile option etc]. You can then use the database view in the SQL Query of table type value set.

    thanks,
    anil

    0 Like
    Short URL:
  • Comment: Hi Anil Again very good stuff. Just few queries : from where can I read in detail about all the types of value sets?? Oracle Documentation???. I have access to dev environment and know how to create dependent and independent value set but would like to try my hands on other types as well. Also, is it possible to restrict the values of the value set based on Organization (other than the Business Group). Suppose I have two Org under by BG - Org A, and Org B. Both the Orgs have their own Functions (e.g - IT & Technical in Org A) and (HR & Sales in Org B). While creating the position which uses Functions as one of the value sets, is it possible to restrict the value sets based on the Organization if I am using security profile based on Organizations? Thanks Mayank

    0 Like
    Short URL:
  • Hi Mayank

    The steps when using View for Table Type Value set are exactly the same as that for creating VS of table type on table.

    Instead of table name , you will specify view name in table name field
    see links
    http://getappstraining.blogspot.com/2006/12/value-sets-in-oracle-apps.html

    http://photos1.blogger.com/x/blogger/1078/3631/1600/874155/valueset_07.gif

    0 Like
    Short URL:
  • Hi Anil

    Thanks for your response. Could you please give me an example of creating a table dependent value set using a databse view (or let me know where can I read about in detail). Thanks a lot for your help as always!

    Regards,
    Mayank

    0 Like
    Short URL:
  • Hi Anil,

    This is really a good effort.
    I would like to ask one question.
    Is there any way by which we can pass multiple values for a parameter using value set.

    Regards
    Saily

    0 Like
    Short URL:
  • Hi Saily

    I am afraid, by standard practice, you will only pass one value per valueset.

    Yes, you can indeed concatenate strings with a delimiter to pass multiple values in one parameter....however there is no reason to take such approach. Please define one parameter per value being passed to concurrent program

    thanks
    anil

    1 Like
    Short URL:
  • hi anil,
    thanx for such a nice blog.
    i have some confussion...What is the procedure, if we want to create values in independent and dependent valuesets based on database table (for example po_headers_all (po_header_id) as INDEPENDENT value set and po_lines_all (po_line_id) as DEPENDENT valueset)

    0 Like
    Short URL:
  • hi vishal

    in order to achieve your requirement, in the table type value set of po_lines_all, include a where clause such as WHERE po_header_id = :$FLEX$.PO_HEADER_ID_VS_NAME

    thanks,
    anil

    0 Like
    Short URL:
  • Hi Anil,

    Please advice on how to set up
    1. Pair valuesets
    2. Dependent valuesets

    Thanks.

    0 Like
    Short URL:
  • Please refer to the link below that explains different types of value sets

    http://getappstraining.blogspot.com/2006/12/value-sets-in-oracle-apps.html

    Thanks,
    Anil Passi

    0 Like
    Short URL:
  • I have to create a value set having Maximum_SIZE =>6,Precision=>2 ,MIN_VALUE=>0.00 and MAX_VALUE=>100.00.

    When i am submitting my request then in the Parameter window, if i enter 12.35 then program accept as it is but if i enter 12.356 then it shows an error message stating that U CAN ENTER UPTO 2 DECIMAL VALUES.
    OR
    After 2 decimal point, it will not allow us to enter any value.

    Is it possible with value set?

    0 Like
    Short URL:
  • Please refer to this link to find info about Special Value Set


    http://getappstraining.blogspot.com/2006/12/value-sets-in-oracle-apps.html

    Thanks,
    Anil

    0 Like
    Short URL:
  • Guest - Shilpad

    Hi Anil,

    Really very helpful site!

    I have defined independent valueset (number)with LOV as '1,5,10.15,20,25,30,35,40,45' but while running the report it is showing/sort by first digit/character not by its value as '1,10,15,20,25,30,35,40,45,5', I want to print as I mentioned above, could you please help me in this regard.

    Thanks & Regards,
    Shilpa

    0 Like
    Short URL:
  • Guest - sandyhs

    I am unable to see any screen-shots despite hitting 'show-picture'. Any suggestions?

    0 Like
    Short URL:
  • Guest - vizith

    hii yaar ..
    i hav this prob while creating a value set .. wwhich of table type .. here is the query try to helpme out ..

    (SELECT DISTINCT transfer_batch,FROM_WAREHOUSE,TO_WAREHOUSE,SCHEDULED_RELEASE_DATE FROM ic_xfer_mst )

    WHERE
    TRUNC(SCHEDULED_RELEASE_DATE) BETWEEN
    TO_DATE(:$FLEX$.FROM_DATE,'DD/MM/YYYY') AND
    TO_DATE(:$FLEX$.TO_DATE,'DD/MM/YYYY')
    AND FROM_WAREHOUSE=nvl(:$FLEX$.DV_WHSE,'%')
    ORDER BY TRANSFER_BATCH

    1 Like
    Short URL:
  • Hi Anil,

    I followed the steps:

    1)From Message Form created message with language US, type ERROR, Message Text and submitted concurrent program Generate Messages.

    2)Called this message through a valueset-type Special and event:validate with conditions.

    3)Assigned this valueset to a concurrent program parameters to validate.

    4) bounced the apache server.
    Issue is the Message Name is not calling the actual message text from message form, instead displaying Message Name at runtime.

    eg: fnd_message.set_name('ONT','TEST_MSG');
    fnd_message.raise_error;

    Showing message TEST_MSG at runtime instead of actual message text.
    please suggest how to overcome from the issue.

    thanks in advance,
    Ram

    0 Like
    Short URL:
  • Guest - sarunraj

    Hi Anil,

    First let me appreciate you for the good work that you are doing. Its great!!

    I just wanted to know about $FLEX$ and its usage.
    Can you give me an example on the same?

    Thanks in Advance,
    Arun
    "Impossible is Nothing"

    1 Like
    Short URL:
  • Guest - Ani

    Hi Anil,

    I've three parameters TYPE,Project and Organization in a report.
    Type is either Project or Organization.
    If I select Project in Type field the Organization field grays out and Project field gets enabled. Similarly if Organization is selected then Project field grays out and Organization field gets enabled.
    Please let me know how can a field be grayed out depending on the values of another field.

    Thanks
    Anjani

    1 Like
    Short URL:
  • Guest - PavanR

    Hi Anil,

    How do i disable a parameter2 on submit request, depending on a lov selected value of some other parameter1. Parameter2 is not a LOV. It is a user enterable field.

    Please let me know how can i do this.

    Thanks
    Pavan

    0 Like
    Short URL:
  • Guest - Anil Passi

    Hi Pavan

    You will have to attach a value set to both those parameter. Without that, it isn't possible to have dependent segments in Descriptive Flexfields

    Thanks
    Anil Passi

    0 Like
    Short URL:
  • Guest - hisham

    hi anil i saw ur doc for creating independent value set type. Can u pls help to create a value set of table .Its urgent

    1 Like
    Short URL:
  • Guest - Pradeep_B

    Hi Anil,
    First of all, thanx for such an informative article n u guys rock.
    well, I am in a situation where i need only distinct values from a column in my value set and i dont want to create a view for it. How do i go about it? I checked some other forums and they mentioned to add a select statement with distinct in the Table Name field, but that somehow didnt seem to work very well.. is there any other way to do so and if not may be i am doing something wrong while entering the select statement. whatever the case may be, i would greatly appreciate if you can throw some light to it.
    Thanx,
    Pradeep.B

    0 Like
    Short URL:
  • Guest - Hari Babu

    Hi,
    I have tow parameters. Depending on the first parameter value the scond parameter should be in disabled or enabled. How can we achieve this?

    0 Like
    Short URL:
  • Guest - Sandip Jadhav

    Hi Pradip,

    This is regarding distinct values in LOV.

    At the time of creating LOV, in table name write query like this e.g. (SELECT DISTINCT element_name,reporting_name FROM PAY_ELEMENT_TYPES_F_TL) A.

    Then in Name and ID, select values like this - A.element_name, A.reporting_name
    Write in where clause if u need.

    Save it.

    This will work.

    Cheers,
    sandip

    0 Like
    Short URL:
  • Guest - rameshk

    Hi anil,
    how can we change the valueset based on the previous value.

    Example
    if value of previous valueset is null then
    populate the value form X table with different where clause
    else
    populate the value from y Table with different where clause


    Please update me if we have a wayout to get this resolved.
    regards
    Ramesh

    0 Like
    Short URL:
  • Guest - Pradeep Agarwal

    Hi Anil,

    First of all, thanx for such an informative Article abount value set.it was very good artcle.
    Anil can u help me abt concurrent program in oracle apps.actually i m a ERP fresher in this field.
    Please help me ASAP.

    Regards

    Pradeep Agarwal

    0 Like
    Short URL:
  • Hi Anil,
    thanx a lot for such an informative articles.
    can you please help me in creating table validated value sets.

    -->in the edit information we have id,meaning and value in the colums frame which columns do we need to specify can you please illustrate with an exapmle.

    Regards
    Ramya

    0 Like
    Short URL:
  • Guest - Richa Kulkarni

    Hello Anil,
    I have interview with a company in another 2 weeks on Oracle Apps. Can you please provide me with the basic questions that can be asked. Also, which things to prepare. Please please help me ...that will be a great help from you :)
    Thanks
    Richa

    0 Like
    Short URL:
  • Guest - sumit verma

    i want to attech one value set to a parameter which takes two values say A and B on each run of the concurrent program. this value should change on the ever next run of the progarm. tat is if for now it is running for A the next it should run for B. how can i degine this value set. And values A and B are constant type

    0 Like
    Short URL:
  • Guest - kzaffar

    Hi Anil,

    What are (Pair, translatable dependent , transalable independent )validation types

    0 Like
    Short URL:
  • Guest - jyotsna

    I followed the above steps mentioned in your tutorial.
    I was able to run it without thevalue sets ok. Record got inserted in the table. But when I run this request with value set, why do I get this error ?
    I get this error :

    XX_HELLOWORLD module: XX Hello World
    ---------------------------------------------------------------------------

    Current system time is 04-MAR-2008 14:10:24

    ---------------------------------------------------------------------------

    **Starts**04-MAR-2008 14:10:25
    ORACLE error 6550 in FDPSTP

    Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
    PLS-00306: wrong number or types of arguments in call to 'XX_REGISTER_USER_PRC'
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored.

    1 Like
    Short URL:
  • Guest - saurav

    I have 2 parameters.

    1)1st parameter has independent value set and it will have only 2 possible values 'week' or 'month'. My 1st value set name is xx_period_type

    2)2nd parameter has value set which should display the
    'weekno-year'of last 5 years if parameter1 value passed is 'week'.

    3)2nd parameter value set should display the 'month-year' of last 5 years if parameter1 value passed is 'month'.

    My code for 2nd list of value is :-

    (SELECT DECODE(:parameter1,'week',(TO_CHAR(SYSDATE -((LEVEL-1)*7) ,'ww-YYYY')),TO_CHAR(ADD_MONTHS(SYSDATE,-LEVEL 1),'Month-YYYY')) week_month FROM dual CONNECT BY LEVEL< DECODE(:parameter1,'week',52,12))

    This code is working fine from sqlplus on oracle client and even if I hardcode 'week'at the place of :parameter1 the value set is working fine in concurrent program,but
    when I used :$FLEX$.xx_period_type at the place of :parameter1
    it is giving error APP-FND-00005:INCORRECT ARGUMENTS WERE PASSED TO USER EXIT #MESSAGE_TOKEN in value set.

    Thanks in advance.

    1 Like
    Short URL:
  • Guest - Vivek Subramaniam

    Hi,

    I have a query: When using a dependent value set in a DFF field, how does the application decide, which is the field that contains the indepdendent value set?

    For examle consider a DFF where I have four fields - COUNTRY1, COUNTRY2, COUNTRY3, and CITY.

    The first three fields are all attached to the same independent valueset COUNTRY_VS.
    The fourth field CITY is attached to a dependent valueset CITY_VS, which is dependent on COUNTRY_VS.

    I want the CITY field to get populated on the basis of the value entered in COUNTRY2.

    How can this be achieved? How will the application know that it has to check the data entered in COUNTRY2, and not COUNTRY1 or COUNTRY3?

    Thanks in advance.
    Regards,
    Vivek S.

    0 Like
    Short URL:
  • Hello Anil,
    Can we creat a Independent Value Set and then use form personlization to link it to a field in the Define User Form.( FAX field)?
    How?

    1 Like
    Short URL:
  • Guest - Aditi

    Hello,

    I want to a DFF in Material Transaction form which will give me detail for the PO release number.. I was able to add and view the DFF but now how to get the corresponding data in the segment is a question

    The SQL which i have mentioned is

    WHERE pra.release_number in
    (Select release_number from rcv_transactions rt, po_releases_all pra
    where rt.transaction_id = :$FLEX$.rcv_transaction_id
    and pra.po_release_id (+)=rt.po_release_id)

    is there any change in the code.. as its not working...

    0 Like
    Short URL:
  • Guest - swapna

    Hi all,

    My requirement is:
    I have an LOV which contains 2 values ... 1) GL DATE 2) PERIOD
    and there four parameters FROM PERIOD
    TO PERIOD
    FROM GL DATE
    TO GL DATE.
    If the user enter PERIOD then only the FROM-TO PERIOD should get enable.. n vise versa....

    for PERIODS i have created a value set... but for DATE i have to use only FND_STANDARD_DATE.. using this.. how can i achieve this....

    Please help me out in this regard... its urgent...

    0 Like
    Short URL:
  • Guest - Haarika

    Dear sir,
    I want to know the concept of dependent,segment,profile value sets.How can we access the data through these value sets?give one example and explain.
    Thanks,
    Haarika

    0 Like
    Short URL:
  • Guest - GANGA RAJU AENIKE

    Hi,
    I attached a table value set to DFF Segment.When hi value set conditio fal i want display custom mesage instae of 'No list of values found'.Ho to do it?

    0 Like
    Short URL:
  • Guest - wildrose

    Helo sir ,

    I am having a problem with a development and i have no clue how to implement it. Well i have a value set which is dependent on the previous one..If the previous field is set to 'yes',then the second field becomes mandatory ..but if we choose no ,the field should not be mandatory...i know we can implement this by form personalization but it is for a list of parameters for a concurrent program...Thanks

    Shikha

    1 Like
    Short URL:
  • Guest - Radhavijaym

    Hi,
    i had created a parameter by name sort by.
    i cretaed a value set for sort by with independent a type.
    when i navigate to sysadmin--&gt;application--&gt;validation--&gt;values
    im unable to cretae values . im getting error frm:40200: field protected against update

    plz help me how to solve this issue.
    this is an urgent issue for me.

    0 Like
    Short URL:
  • Guest - Suman Banerjee

    Hi,
    I need to pass the values of the value set from Oracle EBS suit to a custom database application whenever there is any any change in the values of the value set. Is there any standard business event for value set? If not we can create new business event but it should be get triggered from some point. I am looking for the triggering point. Is any other way to sense the change of records?? Please suggest...

    1 Like
    Short URL:
  • Guest - rajibnag

    how to create dependent value set to another dependent value set

    1 Like
    Short URL:
  • Guest - otmane

    hi all,

    please can you help me to create a value set with a multipe choice on a liste of value.

    Otmane,
    Thanks in advance :)

    1 Like
    Short URL:
  • Guest - vara

    hi anil i know u r excellent in apps can u tell me wat are the questions frequntly asked in interviews regarding apps
    can u help me pleaseeeeeeeeeeeeeee

    0 Like
    Short URL:
  • Guest - austin

    I have two parameters in the concurrent program say par1 and par2 with value sets parset1 and parset2 respectively
    both being table type value sets.

    Both parameters have to be enabled while running program and if i give value to par1 the parset2 should be updated according to the value chosen.

    I used :$FLEX$.parset1 in WHERE clause of parset2 but due to that par2 is grayed out while running the prog and its enabled only if par1 is given value.

    Provide solution ASAP.Thnx in advance

    1 Like
    Short URL:
  • Guest - Abdul Ghaffar

    Thanks Sandip.

    I am in a situation in which length of Query is more than 240 characters.
    What is the suitable solution in this case, I don’t want to use Option of Creating a View for value set.

    Regards
    Abdul Ghaffar

    0 Like
    Short URL:
  • Guest - RAJITHA BADDAM

    hi anil,

    In one of my form i need to set null value to filed which is defined as a database item. FND_STANDARD_DATE is attached as a value set. I tried to set as :line.attribute1= null and :line.attribute= ' '; :line.attribute1 := to_date(null);
    UPDATE OE_ORDER_LINES_ALL
    SET attribute1 = null
    WHERE line_id = :LINE.LINE_ID;
    None of the ways its worked. When I am trying to hardcode the value :line.attribute1:=sysdate its working. Please let me know anyone has any idea.

    Thanks & Kind Regards,

    Rajitha Baddam

    0 Like
    Short URL:
  • Guest - A.Sam

    Hi Anil,

    I have a value set, and i want to know what are the segments have this value set.

    How to find it, Anil?

    Query/Any Report?

    -Thanks,
    A.Sam

    0 Like
    Short URL:
  • Guest - Kenan

    hi Anil,I wanna ask you,I created Balncing Segment Value and Update it,Now I want to update Intracompany Balancing Rule,but can't.System doesn't show Balancing Segment Values that I made,it showew only All Others,what kind of mistake have I made?Thanks

    0 Like
    Short URL:
  • Guest - obulesh

    Hi
    I have Two Segments Attached with 2 Value Value sets,
    EX: VS1, VS2 value sets
    My Setup:
    VS1 is independent value set having values: a, b, c
    VS2 id dependent value set(Table validation)
    Look ups
    Lookup_types a b c (Not Created)
    Loookup codes a1 b1
    and meanings a2 b2
    a3 b4
    VS2 is table validation where condition is Lookup_type = $FLEX$.VS1

    Now if we select 'a' from seg1 then Seg2 is displaying a1, a2, a3 (as expected)
    If we select 'b' from seg1 then seg2 is displaying b1, b2, b3 (as expected)
    If we select 'c' from seg1 then seg2 has to become free text item to user able enter
    the data instead of No Lovs Warning.

    Please help me some one

    Thanks in advance

    Regards
    Obulesh.

    Now if we select 'a' from seg1, Seg2 has to display a1, a2, a3.
    If we select 'b' from seg1, seg2 has to display b1, b2, b3
    and if we select 'c' from seg1 then seg2 has to become free text item when user suppose enter
    the data.
    my setup is: VS1 is independent value set having values a, b, c,
    VS2 is table validation where condition is Lookup_type = $FLEX$.VS1
    i used $flex$.VS1 then if I select 'a' from seg1, then a1, a2, a3 values displayed for seg2.
    and Look Ups , lookup type a a1, a2, a3, b b1, b2, b3, c is not created.
    if I select 'b' from seg1, then b1, b2, b3 values displayed for seg2.
    if i select 'b' from seg1, it is showing no lovs.

    0 Like
    Short URL:
  • Guest - obulesh

    Hi
    I have Two Segments Attached with 2 Value Value sets,
    EX: VS1, VS2 value sets
    My Setup:
    VS1 is independent value set having values: a, b, c
    VS2 id dependent value set(Table validation)
    Look ups
    Lookup_types a b c (Not Created)
    meanings a1 b1
    a2 b2
    a3 b3
    VS2 is table validation where condition is Lookup_type = $FLEX$.VS1

    Now if we select 'a' from seg1 then Seg2 is displaying a1, a2, a3 (as expected)
    If we select 'b' from seg1 then seg2 is displaying b1, b2, b3 (as expected)
    If we select 'c' from seg1 then seg2 has to become free text item to user able enter
    the data instead of No Lovs Warning.

    Please help me some one

    Thanks in advance

    Regards
    Obulesh.

    0 Like
    Short URL:
  • Guest - Sai Praveen

    For key flexfields I need to create dependent valueset on another dependent valueset is it possible and how

    0 Like
    Short URL:
  • how to get values like 01-jan ,01-feb ,01-mar<br /> upto 01-dec<br /> as a list values through TABLE value set

    0 Like
    Short URL:

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2016  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  910111213
     

Enquire For Training

Related Items