APPS TO FUSION

.......Our Journey from Apps To Fusion

Click here to Receive Email
For New Articles


Miscellaneous Technology

Value set basics in Oracle Apps

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

Comments   

0 #1 reddy 2006-12-12 00:00
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
Quote
0 #2 Anil Passi 2006-12-12 00:00
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.

T hanks,
Anil Passi
Quote
0 #3 reddy 2006-12-12 00:00
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
Quote
0 #4 Anil Passi 2006-12-12 00:00
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.

T hanks,
Anil Passi
Quote
0 #5 reddy 2006-12-13 00:00
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
r eddy
Quote
0 #6 reddy 2006-12-13 00:00
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
r eddy
Quote
0 #7 balkrishna 2006-12-14 00:00
ihave uderstand why oracle consider parameter as discriptive flexfield

wh at 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
balkrish na
Quote
0 #8 Anil Passi 2006-12-14 00:00
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.

T hat 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.


Ma ny Thanks,
Anil Passi
Quote
0 #9 balkrishna 2006-12-14 00:00
i am not uderstand oracle treat parameter as discriptive field , what it means
please advise
Quote
0 #10 balkrishna 2006-12-14 00:00
ihave uderstand why oracle consider parameter as discriptive flexfield

wh at 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
balkrish na
Quote
0 #11 Anil Passi 2006-12-14 00:00
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.

T hat 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.


Ma ny Thanks,
Anil Passi
Quote
0 #12 balkrishna 2006-12-14 00:00
i am not uderstand oracle treat parameter as discriptive field , what it means
please advise
Quote
0 #13 Shabeer.S 2007-01-25 00:00
Hi Anil,

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

Rega rds
Shabeer.S
Quote
0 #14 shabeer 2007-01-25 00:00
Hi Anil,

Great work yaar.....

Rg ds
Shabeer.S
Quote
0 #15 Anil Passi 2007-01-25 00:00
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
Quote
0 #16 Shabeer.S 2007-01-25 00:00
Hi Anil,

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

Rega rds
Shabeer.S
Quote
0 #17 shabeer 2007-01-25 00:00
Hi Anil,

Great work yaar.....

Rg ds
Shabeer.S
Quote
0 #18 Anil Passi 2007-01-25 00:00
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
Quote
0 #19 Anil Passi 2007-02-02 00:00
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
Quote
0 #20 Mayank 2007-02-02 00:00
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
Quote
0 #21 Anil Passi 2007-02-08 00:00
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.

Inste ad 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
Quote
0 #22 Mayank 2007-02-08 00:00
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!

Rega rds,
Mayank
Quote
0 #23 Saily 2007-03-01 00:00
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
Quote
0 #24 Anil Passi 2007-03-01 00:00
Hi Saily

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

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

than ks
anil
Quote
0 #25 Vishal 2007-04-27 00:00
hi anil,
thanx for such a nice blog.
i have some confussion...Wh at 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)
Quote
0 #26 Anil Passi 2007-04-29 00:00
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_HEAD ER_ID_VS_NAME

thanks,
anil
Quote
0 #27 Sanjai 2007-05-02 00:00
Hi Anil,

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

Th anks.
Quote
0 #28 Anil Passi 2007-05-02 00:00
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
Quote
0 #29 Amit 2007-05-16 00:00
I have to create a value set having Maximum_SIZE =>6,Precision=> 2 ,MIN_VALUE=>0.0 0 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?
Quote
0 #30 Anil Passi 2007-05-27 00:00
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
Quote
0 #31 Shilpad 2007-08-21 19:10
Hi Anil,

Really very helpful site!

I have defined independent valueset (number)with LOV as '1,5,10.15,20,2 5,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
Quote
0 #32 sandyhs 2007-09-17 10:53
I am unable to see any screen-shots despite hitting 'show-picture'. Any suggestions?
Quote
0 #33 vizith 2007-09-21 04:39
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,SC HEDULED_RELEASE _DATE FROM ic_xfer_mst )

WHERE
TRUNC(SCHEDULE D_RELEASE_DATE) BETWEEN
TO_DATE(:$FLEX $.FROM_DATE,'DD /MM/YYYY') AND
TO_DATE(:$FLEX $.TO_DATE,'DD/M M/YYYY')
AND FROM_WAREHOUSE= nvl(:$FLEX$.DV_ WHSE,'%')
ORDER BY TRANSFER_BATCH
Quote
0 #34 Ram Babu 2007-10-08 10:17
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','TE ST_MSG');
fnd_message.ra ise_error;

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

thanks in advance,
Ram
Quote
0 #35 sarunraj 2007-10-10 02:17
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"
Quote
0 #36 Ani 2007-10-15 14:49
Hi Anil,

I've three parameters TYPE,Project and Organization in a report.
Type is either Project or Organization.
I f 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
Quote
0 #37 PavanR 2007-11-02 19:41
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
P avan
Quote
0 #38 Anil Passi 2007-11-02 20:08
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

Tha nks
Anil Passi
Quote
0 #39 hisham 2007-11-15 05:17
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
Quote
0 #40 Pradeep_B 2007-11-27 15:53
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,
Prad eep.B
Quote
0 #41 Hari Babu 2007-11-28 07:25
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?
Quote
0 #42 Sandip Jadhav 2007-12-15 10:41
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,re porting_name FROM PAY_ELEMENT_TYP ES_F_TL) A.

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

Save it.

This will work.

Cheers,
sandip
Quote
0 #43 rameshk 2007-12-28 07:56
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.
regar ds
Ramesh
Quote
0 #44 Pradeep Agarwal 2008-01-09 05:58
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
Quote
0 #45 ramya 2008-01-16 09:39
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.

Regar ds
Ramya
Quote
0 #46 Richa Kulkarni 2008-01-23 01:59
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
Quote
0 #47 sumit verma 2008-02-12 09:17
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
Quote
0 #48 kzaffar 2008-02-26 10:24
Hi Anil,

What are (Pair, translatable dependent , transalable independent )validation types
Quote
0 #49 jyotsna 2008-03-04 19:12
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_HELLOWORL D 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_US ER_PRC'
ORA-065 50: line 1, column 7:
PL/SQL: Statement ignored.
Quote
0 #50 saurav 2008-03-13 06:30
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'o f 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(:paramet er1,'week',(TO_ CHAR(SYSDATE -((LEVEL-1)*7) ,'ww-YYYY')),TO _CHAR(ADD_MONTH S(SYSDATE,-LEVE L 1),'Month-YYYY' )) week_month FROM dual CONNECT BY LEVEL< DECODE(:paramet er1,'week',52,1 2))

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_peri od_type at the place of :parameter1
it is giving error APP-FND-00005:I NCORRECT ARGUMENTS WERE PASSED TO USER EXIT #MESSAGE_TOKEN in value set.

Thanks in advance.
Quote
0 #51 Vivek Subramaniam 2008-04-30 03:45
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?

Than ks in advance.
Regard s,
Vivek S.
Quote
0 #52 TUAN 2008-05-02 11:43
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?
Quote
0 #53 Aditi 2008-08-22 09:50
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_num ber in
(Select release_number from rcv_transaction s rt, po_releases_all pra
where rt.transaction_ id = :$FLEX$.rcv_tra nsaction_id
and pra.po_release_ id (+)=rt.po_relea se_id)

is there any change in the code.. as its not working...
Quote
0 #54 swapna 2008-11-17 09:27
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_DA TE.. using this.. how can i achieve this....

Please help me out in this regard... its urgent...
Quote
0 #55 Haarika 2009-01-02 08:31
Dear sir,
I want to know the concept of dependent,segme nt,profile value sets.How can we access the data through these value sets?give one example and explain.
Thanks ,
Haarika
Quote
0 #56 GANGA RAJU AENIKE 2009-01-16 02:17
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?
Quote
0 #57 wildrose 2009-02-02 07:59
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...Thank s

Shikha
Quote
0 #58 Radhavijaym 2009-02-04 22:02
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-->a pplication--> ;validation--&g t;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.
Quote
0 #59 Suman Banerjee 2009-11-01 00:39
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...
Quote
0 #60 rajibnag 2009-11-11 08:49
how to create dependent value set to another dependent value set
Quote
0 #61 otmane 2009-11-23 05:24
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 :)
Quote
0 #62 vara 2010-01-03 02:06
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 pleaseeeeeeeeee eeeee
Quote
0 #63 austin 2010-04-30 08:04
I have two parameters in the concurrent program say par1 and par2 with value sets parset1 and parset2 respectively
bo th 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
Quote
0 #64 Abdul Ghaffar 2010-06-22 07:20
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
A bdul Ghaffar
Quote
0 #65 RAJITHA BADDAM 2010-10-11 10:57
hi anil,

In one of my form i need to set null value to filed which is defined as a database item. FND_STANDARD_DA TE is attached as a value set. I tried to set as :line.attribute 1= null and :line.attribute = ' '; :line.attribute 1 := 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.attribute 1:=sysdate its working. Please let me know anyone has any idea.

Thanks & Kind Regards,

Rajitha Baddam
Quote
0 #66 A.Sam 2011-02-17 01:20
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/An y Report?

-Thank s,
A.Sam
Quote
0 #67 Kenan 2011-10-25 01:13
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
Quote
0 #68 obulesh 2011-12-25 15:06
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)
Loo k ups
Lookup_type s a b c (Not Created)
Loooku p 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.

Pleas e help me some one

Thanks in advance

Regard s
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.
Quote
0 #69 obulesh 2011-12-25 15:13
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)
Loo k ups
Lookup_type s a b c (Not Created)
meanin gs 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.

Pleas e help me some one

Thanks in advance

Regard s
Obulesh.
Quote
0 #70 productos 2014-06-04 20:00
You ought to take part in a contest for one of the highest quality sites on the net.
I'm going to highly recommend this web site!
Quote

Add comment


Security code
Refresh

You are here: Home Technical Articles Miscellaneous Value set basics in Oracle Apps