Answer Posted / rajiv

LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)

what are the different transaction clauses in AR?

2167

---

can we get profile values in report without using user exists is it possible how?

2933

---

Tell me how to debug the report?

1172

---

How to create a purchase order without a requisition?

1252

---

What do you understand by concurrent programs?

1145

---

How many schemas we have? how many you have used?

2112

---

testing tools?

2301

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2671

---

List the types of flexfield?

1087

---

What are do's and dont's of Interface?

2472

---

Can you differentiate between mediator and osb?

1193

---

q)what are the validations in sql*loader

2456

---

where to define interorganization transaction charges and what are the different options?

2465

---

In hierarchical structure of a database? we have write query from where we should start?

2303

---

What is count(*) from po_vendors(any table)?

1139

---