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