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 r issues faced in gl

2279


payment types and payment methods.

1437


While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.

2293


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

2566


Charge Back Setups ?

1706






can we define 2 different currency revaluation at a time??

1906


Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples

2014


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

2070


What is gap analysis, what are the pre-requisities?

748


HI, once we create the standard invoice then we can get journal entry item expense a/c-dr to liability a.c then item it will reflect through inventory, but liability a/c . it will reflect from GL , it is possible .

1416


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

1784


can any one tell me what exactly functional consultant do on daily basis? client requirements?

532


Invoice Approval Process?

2789


What is difference between primary and secondary ledger

615


difference between primary ledger and secondary ledger in r12

1098