Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Wednesday, 11 October 2017

Value Set Types in Oracle Apps

Value set is a set of rules or conditions or properties or attributes which are going to enforce to the segment.

      Independent: If validation type is independent, we can define values for the value set and we can use at the time of transaction time.

      Dependent: If validation type is dependent, then we cannot define values for value set. Dependent values are always depending on the independent value set.

      None:  If validation type is none, we cannot define values for the value set. User can enter desire value at the time of transactions entry. 

      Pair & Special: Used in the programs to add additional pop up window for parameters.

      Table: If validation type is table, then we cannot define values but we can use values from tables.

      Translate dependent & Independent: We use to translate the segment values into desire language. 

Share this article :


  1. Hello There,

    In debt to you for making my learning on the
    Oracle Apps Tutorials area so hassle-free! I lay my faith on your writings.

    I have a requirement of partitioning a table first on retinoid column then after sub partition by year column and then by month column. How to do this three level partition on a table.
    I am thankful to any suggestions to achieve this requirement.

    Awesome! Thanks for putting this all in one place. Very useful!


  2. Merhaba,

    I’ve often thought about this #topic. Nice to have it laid out so clearly. Great eye opener.

    I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So, if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be beginning to show 3-11-16. Is that possible?

    Appreciate your effort for making such useful blogs and helping the community.



  3. Hi There,

    Great post. Well though out. This piece reminds me when I was starting out Value Set Types in Oracle Apps after graduating from college.

    I'm new to xmltype. I want to create a form populated with my query data. I just need help with how to add input fields with a certain type and their name/values. For example, I have the following line but it's not working correctly. The database value is appearing outside the input field.
    Code (SQL):
    XMLATTRIBUTES('bgcolor:#eeeeee' AS STYLE),
    XMLELEMENT("b", 'Name: ')
    XMLELEMENT("NAME", myName)
    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).


  4. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  5. There are several hundred games available for mobile phones. Apple's iPhone has an apps store filled with one adventure after another. AFK Arena Codes

  6. Prime Accounts are relatively new and introduced by the gaming company itself. The Prime Account is different from other accounts in that players have to link the account with their phone number csgo prime account buy valorant accounts

  7. Very useful info. Hope to see more posts soon!. ufabet เว็บตรง

  8. Marketing suggestions as well as strategies could be talked about within "real time" instead of getting e-mail soaring regarding that is much less efficient API platform ​as well as time-consuming as well as complicated sometimes

  9. New advancements and old ones who are on their own feet, and with a spray of new programming dialects of 2021 has a ton coming up for you, for purchasers as well as for the engineers.

  10. There are a few areas of interest in the advancement of portable applications that the present versatile app designers need to focus on. New advancements and old ones who are on their own feet,

  11. Car games come with in all types and sizes. Gaming companies are constantly renovating their game strategies to find better and bigger buyers for their products. With action and war games attaining new levels of popularity, car game manufacturers are trying equally hard to keep up with the market standards. Some of the popular car game categories are listed below.

  12. Learn how to market with your YouTube account the right way. Many people don't know how to advertise on YouTube the correct way. Here is how I do it.

  13. I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. ajp150

  14. This particular is usually apparently essential and moreover outstanding truth along with for sure fair-minded and moreover admittedly useful My business is looking to find in advance designed for this specific useful stuffs… Videobuddy Apk

  15. We can use YouTube for watching video clips or even whole movies now. We can also create something called 'Infomercials' and load them onto YouTube. These can be used as a YouTube promotion marketing strategy for your product or service.

  16. You may have heard of video marketing, and may even have tried your hand at one or two videos, but gave up after that because they do not seem to be bringing traffic to your website and don't get any hits on YouTube either. This article is to help you get to grips with YouTube and how to use it to drive traffic to your website.

  17. 1833 S Coast Hwy, Oceanside, CA, 92054 is the beauty salon in Oceanside, CA where you can take advantage of a huge range of services and forget about your worries at least for a little bit. We now have over 15 years of experience and this is just one of the reasons why we are able to provide you with so many amazing services. But if you are still not sure whether to set an appointment with us, you should read the following paragraphs and learn a bit more about us.

    Why Are We Different?

    nail salons near oceanside ca

    At our nail and spa salon Oceanside CA, you can treat yourself to a nice manicure and pedicure, eyelash extensions, brow threading, and more. We are ready to serve each and every one of you.
    We are working only with quality products and equipment, which is the reason why everyone who takes advantage of our services will enjoy long-lasting and beautiful results.
    If you found us online, you can take advantage of a 10% discount on the first procedure you get at our salon.
    Our extensive experience in the beauty industry is the reason why so many people choose our beauty salon. We can meet all your requirements and will answer any questions you may have.

    If you are currently looking for a nail and spa salon in Oceanside, CA, you should try 1833 S Coast Hwy, Oceanside, CA, 92054 and all the amazing services we offer! Stop by the salon if you have questions or want to set up an appointment, or just give us a call at (760) 721-4876 right away!