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 is organization id

3 Answers  

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---

where do u specify in org_id?

2 Answers  

---

oracle apps architecture

1 Answers   TCS,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

In what situation u create the BPA.

2 Answers   Accenture,

---

Types of cursors?

3 Answers  

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,

---