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