Answer / srinivas.r

We are having to two types the error records.....
1)Rejected by the SQL Loader.
These are stored in the '.BAD' file......
2)Rejected by the condition which have been mention in the
control file.
These are stored in the '.dis' file......

atfer getting the error records in the specified file then
we will correct the errors and proceed them once again...

Answer / roshan

if where clause doesn't satified the condition and flatfile
error, so we can refer discardfile.... and debug the errors

What are profile options?

4 Answers   Accenture,

---

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,

---

Where I can download D2K software?

2 Answers  

---

What are the validations you don in .CTL file in inbound interface process?

1 Answers  

---

what is meant by Table space?

2 Answers  

---

what is organization id

2 Answers   Wipro,

---

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

how can u find the status in po?

1 Answers  

---

cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,

---

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

---

Presently u are working in which version?

4 Answers   Accenture,

---