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.
Hello There,
ReplyDeleteIn 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
Merhaba,
ReplyDeleteI’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
Hi There,
ReplyDeleteGreat 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.