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
What is gap analysis, how do you defined?
what is the use of hr: security profile, while configure multiorg?
What is the use of hr: user type, while configure multiorg?
What is the use of gl set of books name, while configure multiorg?
What is meaning of deprecation?
what is the difference between before pages trigger and after parameter trigger in reports ?
What are the types of setups in apps inventory module
How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.
Can Adjustments be imported?
We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?
What is the meaning holding tax?
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?
Explain about Localization (IND & US ) in Oracle Apps ?
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?