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.

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.

Answer / uday

not null,
set up,
business rules

............. validations are there

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers   Tech Mahindra,

---

where u do setup of operating unit?

1 Answers   TCS,

---

FLEX FIELDS?

2 Answers  

---

what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

---

How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,

---

what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

---