Can i increse/Decrease ths size of value set ?

Answer Posted / mahadev patil

We can increase/decrease the Valueset MAX SIZE.
Increasing the size is easy and we can do it from front end , but for decreasing, front end will not allow this operation, from backend with a simple update statement we can easily decrease the MAX SIZE. (Note- The existing values sixe should be less than 10 Char)
Ex -
BEGIN
UPDATE fnd_flex_value_sets
SET MAXIMUM_SIZE = 10
where flex_value_set_name = 'XXX_NAME';
Commit;
END;

thanks,
Mahadev Patil
Belgaum,Karnataka, India

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is gap analysis, how do you defined?

642


what is the use of hr: security profile, while configure multiorg?

629


What is the use of hr: user type, while configure multiorg?

696


What is the use of gl set of books name, while configure multiorg?

641


What is meaning of deprecation?

614






what is the difference between before pages trigger and after parameter trigger in reports ?

1951


What are the types of setups in apps inventory module

1898


How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.

2064


Can Adjustments be imported?

1705


We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?

1561


What is the meaning holding tax?

656


How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?

1395


How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2310


Explain about Localization (IND & US ) in Oracle Apps ?

2699


Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?

1585