What r the validation types?
Answers were Sorted based on User's Feedback
Answer / guest
oracle supports 8 types of validations, but GL accounting
flexfield supports only 3 types of validation.
1. independent
2. dependent
3. table
coming to rest of validation we have
4. none
5.special
6.pair
7.translatable dependent
8.translatable independent
Independent:this tpye of value set does not depend on value
of other segement, example department is independent where
as sub department is dependent. Independent value set are
stored in application object library table.
dependent:sub department depends on independent value
(department).
Note: u wont see dependent value while defining flexfiled
qualifier.
Table: this tpye of value set is done with the help of
technical consultant. if we are using this type we cant
enter new segment values. it iwlll be predefined by
technicalconsultant.
Example in benz showroom u can see only few types of models
C,S,E classes and if the user creates new segment value by
Dclass it a loss to the show room . so in order to restrict
the user table type of validation comes into picture.
coming to other types
Tranlatable independent: when u install oracle application
in different langauges we use this type of validation .
None:after selecting none type if u enable number only
check box user cannot create values in alphabetic
characters,similarly if u use uppercase it allows only
alphabetic characters.
Special & pair :
They are used in reports design . so dont worry about that.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / niranjan
1) None -------- validation is minimal.
2) Independent -------- input must exist on previously
defined list of values
3) Dependent ------ input is checked against a
subset of values based on a prior value.
4) Table ----- input is checked against values in
an application table
5) Special ------ values set uses a flex field itself.
6) Pair ------ two flex fields together specify a
range of valid values.
7) Translatable independent ----- input must exist on
previously defined list of values;translated values can be used.
8) Translatable dependent ------- input is checked against a
subset of values based on a prior values; translated value
can be used.
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / uday
not null,
set up,
business rules
............. validations are there
Is This Answer Correct ? | 0 Yes | 2 No |
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what is pl/sql table and pl/sql records? what is the use of that?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
what is aim methodolozy
what is meant by lexical parameter
In unix Schell sript what is very 1st line to be wriiten .
What are triggers?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
How to print invoice from APPS(front end).if we have invoice number in hand with us???
Do you know what are user profiles in apps. Any examples you can give?
Do you know what is applysys in oracle application database schema, what is apps?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?