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.
- 2 Answers
- 8313 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / basha
we can apply the condotion by using 'when sal<500' before
columns name and after the into statemnt
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / prasanna
WHILE DEVELOPING THE xml format rtf you can make condition
on the field using choose element
| Is This Answer Correct ? | 1 Yes | 1 No |
what is po approval hierarchy?
What is the difference between buyer&employee in PO module?
where u do setup of operating unit?
what is pick selection list generation report.
what is organization id
What are the files we submit while your program move to testing instance?
what is the difference between oracle 8i and 9i?
is UOM maintained at master level or organization level or both?
Do you know where we can check the status of po?
How to insert data into two tables using single control file?
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
in one report using two layout models.if yes how to do
Oracle Apps Technical 
