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 and Fusion Self Paced Training Videos by Industry Experts. Please Check

  5. 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.