What r the validation types?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3092


In hierarchical structure of a database? we have write query from where we should start?

1718


How can you achieve loose coupling in soa framework?

732


How to move the one file from one instance to another instance? And your scripts also?

619


What is oracle soa suite and what are its different components?

659






What do you understand by a set of books?

659


What is a value set? List its various types.

658


Can you define an erp system?

686


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1696


what is global tempory table?

6327


how can i print random rows in plsql table

1948


How is choreography different from orchestration?

667


What are do's and dont's of Interface?

1915


how do you describe O2C along with tables

2317


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2475