Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8169 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 |
is UOM maintained at master level or organization level or both?
what is MRC? Why it is needed?
What is Value Set?
How many schemas we have? how many you have used?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
When loading data from staging table to interface table , how to reload the invalid record once again ?
How do u identity its name of report?
what are the types of interfacing?
which parameters passed in report in oracle developer how to pass
Oder of firing triggers in form
What r the type Models in the system parameters of the report?
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
Oracle Apps Technical 
