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

Pages

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 :

20 comments:

  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!

    Grazie,
    Nisha

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


    Obrigado,

    morgan

    ReplyDelete
  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):
    XMLELEMENT("FORM",
    XMLELEMENT("TR",
    XMLELEMENT("TABLE",
    XMLATTRIBUTES('bgcolor:#eeeeee' AS STYLE),
    XMLELEMENT("TR",
    XMLELEMENT("TD",
    XMLELEMENT("b", 'Name: ')
    ),
    XMLELEMENT("TD",
    XMLELEMENT("INPUT",
    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).

    MuchasGracias,
    Preethi.

    ReplyDelete
  4. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete
  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 https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  6. 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

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

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

    ReplyDelete
  9. 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

    ReplyDelete
  10. Thank you very much for writing such an interesting article on this topic. This has really made me think and I hope to read more. 토토사이트

    ReplyDelete
  11. 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.https://www.blackmartappdownloads.com/

    ReplyDelete
  12. buy twitch followers While there are tons of games out there that are graphically rich and meant to take advantage of your computers hardware to render realistic characters, environment and special effects, not a lot of us have the money to spend on gaming rigs to even be able to play these games. Fortunately though, there are also games that have been developed that you can play within your browser, making use of flash which doesn't need quite as much video processing power for you to play.

    ReplyDelete
  13. 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, https://twitchviral.com/

    ReplyDelete
  14. https://www.visualaidscentre.com/service/eyes-specialist-delhi/ 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.

    ReplyDelete
  15. https://www.buyyoutubesubscribers.in/2021/11/20/how-to-earn-money-from-youtube-views/ 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.

    ReplyDelete
  16. 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

    ReplyDelete
  17. 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

    ReplyDelete
  18. https://www.visualaidscentre.com/lasik-eye-surgery-in-delhi/ 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.

    ReplyDelete
  19. https://onohosting.com 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.

    ReplyDelete
  20. When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your. Mod Apk Download

    ReplyDelete