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 the difference between before pages trigger and after parameter trigger in reports ?
Can Adjustments be imported?
What is Work Flow of AP,AR, Sales & Purchase
I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done in Oracle Financials? Answers will be Appreciable. Thank You.
how service tax work.
What are the types of setups in apps inventory module
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
What is the db number of a particular customer TCA?
How do you adjust receivables?
What kind of necessary ap information you gather from the client?
Can I do a payment of 50 bills on a post date. If yes, then how?
encumbrence set ups?
What is the meaning holding tax?
There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.
Anyone provide the oracle fin/scm definetions